Excel Annoyances 
by How to Fix the Most Annoying Things about Your Favorite Spreadsheet 

This errata page lists errors outstanding in the most recent printing.

If you have technical questions or error reports, you can send them to
booktech@oreilly.com.  Please specify the printing date of your copy.

This page was updated July 8, 2008.

Here's a key to the markup:
	[page-number]: serious technical mistake
	{page-number}: minor technical mistake
	<page-number>: important language/formatting problem
	(page-number): language change or minor formatting problem
	?page-number?: reader question or request for clarification



Confirmed errors:


Note from author:
My explanation in the text doesn't cover non-English language
configurations, so I think it's worth a note:

If your computer's default language setting uses commas to indicate decimal
values (e.g., 3,5 which is written in English as 3.5), you might encounter
problems using the INDEX formula described on page 84. The trick is to
change the commas to semicolons. In English, an INDEX formula should be
written using the syntax INDEX(reference, row_num, column_num, area_num). In
a European language, or other language that uses a comma as the decimal
separator, try the syntax INDEX(reference; row_num; column_num; area_num).

The INDEX formula is part of the broader LOOKUP family, which includes
VLOOKUP and HLOOKUP. You can type decimal values directly into a VLOOKUP
formula. In most European countries, you would write the decimal value for
"three and a half" as 3,5 (as opposed to 3.5 in English-speaking countries),
so using a comma as a decimal separator would change the formula
=VLOOKUP(1.5,A2:C10,2), which has the correct number of arguments (three),
to =VLOOKUP(1,5,A2:C10,2), which has an incorrect number of arguments
(four).

Curt
--


(xv)  1st paragraph, under "Using Code Examples" hed;
Line 4 says:
"permission unless you're reporducing..."
should be
 "reproducing"


(1)line two of second paragraph;
Line two reads: "...from it's habit of..." Should be "its habit of..."