Errata

Errata for Head First Excel

Submit your own errata for this product.

The errata list is a list of errors and their corrections that were found after the product was released.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version	Location	Description	Submitted by	Date submitted
PDF	Page 147 top	On page 147, it says that "Excel for Windows defines the integer 0 as January 1,1900" But I think that the integer Excel uses to represent (internally) this date is 1 and not 0. No date in Excel is defined as 0. Furthermore, if what I think is correct then the next sentence "so the integer 1000 represents 1,000 days after January 1, 1900." is also inaccurate (should be 999). In addition, I would emphasize two more points (that I think, "deserve" being mentioned): 1. As far as I know, Excel does not recognize dates below 1/1/1900. 2. There's a "bug" in Excel, which refers to February 29,1900 as valid date, even though 1900 was not a leap year.	Meni Porat	Apr 14, 2010
Printed	Page 201 Top-left	I think the label "You need to convert the rate and term..." should point to rows 3 and 4 of the spreadsheet, not rows 4 and 5.	Magesh Jayapandian	Oct 18, 2010
Printed	Page 345 Middle-left	The label "You've used COUNT, which counts based on one condition." should say (and point to) COUNTIF instead of COUNT. COUNTIF counts based on one condition. COUNT counts based on zero conditions.	Magesh Jayapandian	Oct 21, 2010