Excel 2000 Formulas

Excel 2000 Formulas

Errata

Ideally, I would like every book that I write to be completely accurate and error-free. The fast-paced nature of the computer book publishing industry makes this goal difficult to achieve. However, I assume complete responsibility for the content of my books.

Listed below are known errors in my Excel 2000 Formulas book. If you discover additional errors, please let me know.

NOTE: Some of these errors were corrected in subsequent printings of the book.

• Page 34:
  The symbol on the sixth line (Text concatenation) should be an ampersand (&)
  
• Page 35:
  The last formula on the page should read:
  
    =AND(A1<100,A2<100) 
• Page 36:
  The symbol in the sixth line of the table (Text concatenation) should be an ampersand (&)
• Page 51:
  In the last line on the page, the formula should be entered into cell A2 (not cell A1). 
• Page 74:
  Third paragraph. If column D is deleted, MyRange will then refer to Sheet1!$B$3:$C$5.
• Page 87:
  A clarification: When you type the formula named MonthNames, make sure that you include the brackets. This is different than an array formula typed into a cell.
• Page 95:
  The first sentence on the page refers to "this last example." That's an error. There are no previous examples in that chapter. 
• Page 96:
  The example of a formula with a set of empty parentheses is missing (between the first and second paragraphs). It should be: 
     =RAND()
• Page 119:
  The first sentence of the second paragraph contains an incorrect character. The sentence should read: Below you see a final example of using the & operator.
• Page 122:
  At the top of the page, the formula in cell F3 should be:
  
     =A3
• Page 126:
  At the bottom of the page, the text states that the FIND function is  not case-sensitive. That is incorrect, as demonstrated on page 127.  
• Page 129:
  Rule #3 should read: "If neither Rule #1 nor Rule #2 apply, use th." 
• Page 140:
  In the Searching for Dates sidebar, the second-to-last sentence should read: For example, if your worksheets contain a date displayed as 11/24/99, you must search for the date using 11/24/1999.
• Page 154:
  The second sentence in the second paragraph should read: For example, if cell A1 contains 12/31/1998 and cell B1 contains 01/01/1999, the formula returns a difference of one year, even thought he dates differ by only one day.
• Page 179:
  The function described in the table should be SUMX2MY2 (not SUMXMY2). 
• Page 185:
  In Table 7-2, the formula for the number of values exceeding three standard deviations above the mean should be:
  
     =COUNTIF(data,">"&AVERAGE(data)+STDEV(data)*3)
  
• Page 190:
  The second formula in the Total Occurrences in a Range section is an array formula (the brackets were omitted from the formula).
• Page 202:
  The parenthetical expression in the first sentence should be "<0".
• Page 205:
  In the Using Or criteria section, the array formula should be:
  
      {=SUM(IF((Office="Oregon") + (Difference<0),1,0)*Amount)}
  
• Page 210:
  The first sentence below the "on the CD" icon should be: The following formula returns the tax rate for the income in cell B2: 
• Page 210:
  The third argument for the HLOOKUP function should be row_index_num. This error is also present in the first bulleted list on page 211.
• Page 211:
  In the section titled The LOOKUP function, the syntax is given for the VLOOKUP function. The correct syntax for the LOOKUP function is:
  
      LOOKUP(lookup_value,lookup_range,result_range)
  
• Page 224:
  The formula at the bottom of the page refers to range named Price. It should refer to the range named Code.
• Page 240:
  The paragraph above Figure 9-5 refers to range A1:D2. The range reference should be E1:F2.
• Page 246:
  The 11th item in Table 9-3 should be: 
  
      <>?????
• Page 303:
  The formula for the volume of a sphere should be:
  
      =((radius^3)*(4*PI()))/3
• Page 303:
  The formula for the surface of a cone has an extra closing parenthesis. 
• Page 307:
  The third rounding formula, below, returns 120.00, not 123.00. 
  
    =ROUND(123.37,-1)
• Page 310:
  The sentence below the first formula example refers to -14.3. It should be -14.2. 
• Page 328:
  The second formula in the Using function with an array section should be:
  
      {=SQRT(A1:A10)} 
• Page 333:
  At the bottom of the page, the sentence should read: Note that this array contains five  rows of four elements (the same dimensions as the range).
  
• Page 346:
  Disregard the references to the {4,0,9} array. The formula examples at the bottom of the page should read:
  
    {1.3.2}
  
  and
  
    =SUM({1,3,2})
• Page 397:
  In Step #2, the last argument for the OFFSET function should be 1 (not 0).
• Page 468:
  In the first paragraph, the range reference should be A1:D12 (not A1:A12).
• Page 488:
  Production error in Table 18-2. The formula in the last row should read:
  
    =F1& " "&G1
• Page 543:
  In step 4, the second sentence should be: "If the Options button is disabled..."
• Page 546:
  The last line of code has two equal signs (=). The second equal sign should be an ampersand (&). The statement should read:
  
    REVERSETEXT = REVERSETEXT & Mid(text, i, 1)

### End of known errors ###