Excel 2002 Formulas

Excel 2002 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 2002 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 31:
  The last paragraph refers to Figure 2-1, which is not correct. There is no figure that shows the Formula Palette.
• Page 41:
  At the bottom of the page, the Alt key is misspelled as "Alf".
• Page 77:
  In the first paragraph in the "Deleting a Row or Column" section, the range reference after deleting row 1 should be =Sheet1!$C$2:$E$5
• Page 134:
  Not really an error. Just a much more efficient formula to extract the middle name (thanks to Andy Hollandbeck):
  
  =IF((ISERR(FIND(" ",SUBSTITUTE(A1," ","",1)))),"",
  LEFT(REPLACE(A1,1,FIND(" ",A1),""),
  FIND(" ",REPLACE(A1,1,FIND(" ",A1),""))))
   
• Page 318:
  Table 11-2 lists the formulas used in the worksheet shown in Figure 11-5. However, the workbook on the CD-ROM contains an error. Cell B19 contains a value. It should contain the formula listed in the table:
  
  =Nomx_Effx(7%,12)
• Page 353:
  The cell references in the text do not match Figure 13-1 (they are off by one row). The correct formulas are in the workbook on the CD-ROM.
•  Page 367:
  The text states that the schedule of dates for an IRR must be in sequence. Actually, the first transaction must be the earliest, but subsequent transactions need not be in sequential order.
• Page 372:
  The formula at the top of the page is incorrect, and it's also incorrect in the file on the CD-ROM. The correct formula for calculating the growth rates is:
  
  =(C5-B5)/B5
• Page 458-459:
  The formulas shown do not match those in the example file on the CD.
•  Page 528:
  The last sentence of the first section contains an error. It should be: If the count is greater than 0, the formula returns TRUE...
• Page 532:
  The HASLINK function only identifies formulas that contain a left bracket (not a set of brackets). To identify formulas that contain a set of brackets, modify the function to use this statement:
  
  HASLINK = cell.Formula Like "*[[]*]*"
• Page 639-641:
  The Function procedures on these pages contain an extraneous assignment statement. You can remove the following statement from each function:
  
  NumRows = Rows.Count
•  Page 693:
  The second listing for the USER function declares its optional argument as Boolean data type. In fact, optional arguments must always be Variants. The function works properly, but that's only coincidental! The correct declaration statement is:
  
  Function USER(Optional UpperCase As Variant)
•  Page 714:
  The formula at the bottom of the page does not return the count of records in which the Product is Widgit and the Month is January. The array formula on page 715 returns the correct result.
  

### End of known errors ###