Errata

The sample workbook on the ZW worksheet tab shows

EFF ist rund (German again)

It should say EFF is approximately

Note from the Author or Editor:
Changed sample files.

There are minor typos in the .xlsx file. Cell J1 should be Total price, not Totoal price

Note from the Author or Editor:
Changed head line in J1 from "Totoal price" to "Total price"; will send the changed sample file to Kenyon Brown [mailto:kbrown@oreilly.com].

The DVD shows the following Chapter05_Names.xlsx:

Heute+10
Heute+14
Heute+20
Heute+30

I have no idea what language that is or what it translates to.

Also on the same page under "Sample Files", the next to the last sentence says:

"The sample files are found in the Chapter05 folde."

It should read:

"The sample files are found in the Chapter05 folder."

Note from the Author or Editor:
Please change the 2nd sentence in Sample Files box to:
"The sample files are found in the Chapter05 folder."

The DVD samples address worksheet has a defined name that says

Einzahlungen

I think this is German and it should say Proceeds.

Note from the Author or Editor:
Sample file corrected.

This is very minor, but the last sentence in the paragraph titled Example says:

This is more flexible then the LOOKUP()

It should say

This is more flexible than the LOOKUP()

Note from the Author or Editor:
In the last sentence of the 5th paragraph

"This is more flexible then the LOOKUP()"

change to

"This is more flexible than the LOOKUP()"

In the Sample files note area it says

"Use the Column-Row worksheet"

It should say, "Use the Columns-Rows worksheet"

Note from the Author or Editor:
Please change the text from "Use the Column-Row worksheet..." to "Use the Columns-Row worksheet..."

Bullet 2 says, "criteria2:"">10000

It should say, "criteria2:">10000

Note from the Author or Editor:
Please change text in Bullet 2 from
criteria2:"">10000"
to
criteria2:">10000"

The second sentence under Note says,

If the one of the criteria...

It should say,

If one of the criteria...

The first sentence after figure 12-34 says,

As to you can see in Figure 12-34, the number of months with sales over $150,000 increased by eight in 2008.

It should say,

As to you can see in Figure 12-34, the number of months with sales over $150,000 increased to eight in 2008.

Also the sample file shows 10% of the values shown in the sample files on the COUNT workbook, the COUNTIFS worksheet.

Note from the Author or Editor:
Please change the text
"If the one of the criteria..."
to
"If one of the criteria..."
and
change the first sentence after figure 12-34 from
"As you can see in Figure 12-34, the number of months with sales over $150,000 increased by eight in 2008."
to
"As you can see in Figure 12-34, the number of months with sales over $150,000 increased to eight in 2008."

The sample files for both of these pages has the same error in the Probability workbook, the FISHER and FISHERINV worksheets.

It says,

Z-value 1 aus 2005
Z-value 1 aus 2006
Z-value 1 aus 2007
Z-value 1 aus 2008

"aus should be changed to "from" as "aus" is German

Note from the Author or Editor:
Corrected workbooks sent to rachelj@oreilly.com

The second sentence in the 2nd paragraph says:

The four classes are specified in the Class column.

It should say:

The four classes are specified in the Category column.

This will make Figure 12-57 and the worksheet FREQUENCY in the COUNT workbook match.

Note from the Author or Editor:
Please change text to
"The four classes are specified in the Category column."

The sample file for the GEOMEAN function says:

Question: How has changed the percentage turnover in comparison to previous month?

I think you mean:

How has the percentage turnover changed in comparison to the previous month?

Note from the Author or Editor:
Corrected sample files Average.xlsx and xls sent to rachelj@oreilly.com.

In the Regression.xlsx workbook, worksheet GROWTH
the first chart title says:

Exponential trend from Jan 03-June 05

I think it should read

Exponential trend from Jan 06-June 08

Note from the Author or Editor:
Exchange the sample files in download area with new workbooks Regression.xlsx and xls sent to rachelj@oreilly.com

The first sentence say ...and online orders betweeen January 2007 and June 2008.

It should say...andonline orders between January 2006 and June 2008.

also the first bulleted point says,

website vistis between January 2008 and June 2008

It should say:

website visits between January 2006 and June 2008

Note from the Author or Editor:
Please change text to
"...andonline orders between January 2006 and June 2008."

and the first bullet point text to
"...website visits between January 2006 and June 2008"

The sample file under the Average workbook, HARMEAN worksheet needs some rewording.

It says:

Exercise:
A biker is doing a 300 miles tour through the mountains. The way is splitted in 5 sections. He is measuring the speed per section.
Now the biker would like to calculate the overall average speed out of the avarage speed of the single sections.
With the result he will respond the question with which constant speed he had done the way in the same time.

There are several mistakes in wording here. Since I'm not sure what wording you prefer, I'm not even making a suggestion here.

Then the other text box also has an error.

It says:

With this calculation the statement that the geometric mean ist smaller the the harmonic mean and the arithmetic mean is smaller than the geometric one is verified.

The word ist should be is and the first of the two the's right before harmonic mean should be the word "than."

Note from the Author or Editor:
I don't know the right translation for this example? Can somebody check this in sample files?
The mistakes in textbox 2 are removed
Find new sample files Average.xlsx and xls sent to rachelj@oreilly.com.

The second sentence says,

"First you have to calculate the speed v in m/s for the actual miles travelled..."

It should say,

"First, you have to calculate the speed v in m/s for the actual miles traveled..."

for consistency in the paragraph.

Note from the Author or Editor:
Please change text to
"First, you have to calculate the speed v in m/s for the actual miles traveled..."

The sample file refers one to the KURTOSIS worksheet, but it is just KURT.

Note from the Author or Editor:
Please change text in Sample Files area to
"Use the KURT worksheet..."

The last sentence says,

After you are finished, press the F2-key and Ctrl+Page Up+Enter.

It should say,

After you are finished, press Ctrl+Shift+Enter.

to create the array and fill in the cells with the solutions being sought.

Note from the Author or Editor:
Please change text in last sentence in CAUTION to
"After you are finished, press Ctrl+Shift+Enter."

The last sentence in the section says,

"After you are finished, press the F2 key and Ctrl+Page Up + Enter."

If you are trying to fill the selected cells with the formulas and their results this is not going to work.

It should say,

"After you are finished, press Ctrl+Shift+Enter."

Note from the Author or Editor:
Please change last sentence in CAUTION to
"After you are finished, press Ctrl+Shift+Enter."

The sentence says,

"The lognormal distribution is right skewed (see Figure 12-72 later in this section)."

Figure 12-72 is located on page 491 and doesn't appear to show the results expected from the formula.

Did you mean Figure 12-91 or Figure 12-92, or some other Figure?

Note from the Author or Editor:
Please change text from
"...(see Figure 12-72 later in this section)."
to
"...(see Figure 12-91 later in this section)."

The first sentence in the third paragraph says,

...is symmetrical (as shown in Figure 12-95.

That is not correct as Figure 112-95 refers to the MAXA().

I think you mean Figure 12-102 again.

Note from the Author or Editor:
It's a typo. In the first sentence in the third paragraph instead of "Figure 12-55" the expression must be "Figure 12-102".

The two figures on the page show pounds and the sample file in the Probability workbook, PROB worksheet shows kilograms.

Not a big deal, but they should read the same.

Note from the Author or Editor:
sample file corrected.

the 3rd bullet says that

order (required)

but the explanation of the argument is such that it is really optional.
So, shouldn't it say:

order (optional)

Note from the Author or Editor:
Please change the text 3rd bullet on page 569
from
"order (required)"
to
"order (optional"

RANK.AVG() and RANK.EQ both refers one to sample files that don't exist.

RANK.AVE worksheet in the Count workbook &
RANK.EQ worksheet in the Count workbook

Note from the Author or Editor:
Will send the sample files to rachelj@oreilly.com.

RANK.AVE AND RANK.EQ both say that the order is a required argument.

However, they are explained as optional and when calculations are done with either, it is not a required argument.

both bullets should say

order (optional)

Note from the Author or Editor:
Please change text in 3rd bullet and last bullet on page 571
from
"order (required)"
to
"order (optional)"

This is beside the formula with the results 1.7....

T.INV.2S(F10*2;F13)

It is incorrect.

It should say

=T.INV.2T(F4*2,F7)

Note from the Author or Editor:
Will send corrected sample file to rachelj@oreilly.com

The last sentence says,

..."and press Ctrl+Page Up+Enter"

It should say,

"and press Ctrl+Shift+Enter"

Note from the Author or Editor:
In the last sentence in the first paragraph change from
"and press Ctrl+Page Up+Enter"
to
"and press Ctrl+Shift+Enter"

The sentence says,

"If the data contains outliers-that is, a few values that are to high or to low..."

It should say,

"If the data contains outliers-that is, a few values that are too high or too low..."

Note from the Author or Editor:
Please change the sentence
"If the data contains outliers-that is, a few values that are to high or to low..."
to
"If the data contains outliers-that is, a few values that are too high or too low..."

It says,"

You specify 0.12 for the percent argument. This means that 5 percent of the original values are excluded from the calculation.

I don't think the percentage is right in the second statement according to your wording on the previous page.

Shouldn't that be 6% from the higher and 6% from the lower values are excluded?

Note from the Author or Editor:
Please change the sentence
"This means that 5 percent of the original values are excluded from the calculation."
to
"This means that 6% from the higher and 6% from the lower values are excluded."

The sentence refers one to Figure 12-45 and it should be Figure 12-156.

Note from the Author or Editor:
It's a typo.
In the second line of the first paragraph instead of "Figure 12-45" the expression must be "Figure 12-156".

In the Depreciation Calculation workbook, in theAMORDEGRC worksheet there are two errors

The first one is that the currency types are mixed, Euro and USA.

The second is the title to a column entitled: Buchwert

Which is German and should say Book Value.

Note from the Author or Editor:
The sample file will be updated.

In the Depreciation Calculation workbook, in theAMORDEGRC worksheet there are two errors

The first one is that the currency types are mixed, Euro and USA.

The second is the title to a column entitled: Buchwert

Which is German and should say Book Value.

Note from the Author or Editor:
The sample file will be updated.

The second bullet on page 699 says,

Date (required)

It should say,

Date_Purchased (required)

2nd bullet on pg. 700 says,

Residual_Value (required)

It should say,

Salvage_Value (required)

The same error is made in the worksheet for AMORDEGRC.

Note from the Author or Editor:
In the second bullet on page 699 change
"Date (required)"
to
"Date_Purchased (required)."

In 2nd bullet on page 700 change
"Residual_Value (required)"
to
"Salvage_Value (required)."

The second bullet on page 702 says,

Date (required)

It should say,

Date_Purchased (required)

4th bullet on pg. 702 says,

Residual_Value (required)

It should say,

Salvage_Value (required)

The same error is made in the worksheet for AMORLINC.

Also noticed more German words on this and the previous error.

Note from the Author or Editor:
In the second bullet on page 702 change
"Date (required)"
to
"Date_Purchased (required)."

In 4th bullet on page 702
"Residual_Value (required)"
to
"Salvage_Value (required)."

Example says,

This function was used in the detailed calculations of the examples for RATE() and YIELD().

It should say,

This function was used in the detailed calculations of the examples for PRICE() and YIELD().

Note from the Author or Editor:
"the examples for RATE() and YIELD()"
should be
"the examples for PRICE() and YIELD()".

The sentence after Examples says,

This function was used in the detailed calculations of the examples for RATE() and YIELD().

It should say,

This function was used in the detailed calculations of the examples for PRICE() and YIELD().

Note from the Author or Editor:
In the third paragraph instead of
"the examples for RATE() and YIELD()"
it should be
"the examples for PRICE() and YIELD()".

The sentence says,

This function was used in the detailed calculations of the examples for RATE() and YIELD().

It should say,

This function was used in the detailed calculations of the examples for PRICE() and YIELD().

on all three pages

Note from the Author or Editor:
Page 709 and Page 711,
"the examples for RATE() and YIELD()"
should read
"the examples for PRICE() and YIELD()".

Page 712, the mentioned line is correct.

The second bullet says,

Residual_Value (required)

To be consistent with the Excel formula in th workbook it should say,

Salvage_Value (required)

Note from the Author or Editor:
Change
"Residual_Value (required)"
To
"Salvage_Value (required)"

In order to be consistent with Excel formulas, "Repayment" should be changed to "Redemption" in both places.

Plus their is a minor error in the worksheet Bill of Exchange, out to the side of one formula is says "dicount" and it should say "discount."

Note from the Author or Editor:
Change
"Repayment"
to
"Redemption"
in both places.

In order to keep the book and formula in Excel in agreement, the following change should be made,

Nominal_Interest (required)

should become

Coupon (required)

Note from the Author or Editor:
Change
"Nominal_Interest (required)"
to
"Coupon (required)."

In order to make the formulas in Excel and the book match the following changes should be made:

Capital (required)
Interest (required)

should be changed to:

Principal (required)
Schedule (required)

Note from the Author or Editor:
Change
"Capital (required)"
to
"Interest (required)"

and change
"Principal (required)"
to
"Schedule (required)"

The workbook Sample Files have German in the Defined Names area for formulas

Note from the Author or Editor:
The sample files have been revised and will be online soon.

Bullet # 4 says,

Repayment (required)

It should say, Redemption (required)

in order to make the book in alignment with the formula in Excel.

Bullet #2 on page 735 also uses the work "Repayment" where the word "Redemption" should be.

Note from the Author or Editor:
In the forth bullet point on Page 734 "Repayment" should read "Redemption".

In the second bullet point on Page 735 "Repayment" should read "Redemption".

In order to make the formulas in Excel and the book in alignment the following change should be made:

"Estimated_Value"

should be changed to:

Guess

Sentence two in the same paragraph uses "Estimated_Value" and it should also be changed to "Guess."

Table 15-4 does not show the zero year where (80,000) must be placed. It also has periods where commas should be in the amounts in the table.

Note from the Author or Editor:
Page 738: Please change in 2nd bullet "Estimated_Value" to "Guess" (also in Sentence two in the same paragraph).

The Sample Files first sentence says,

"Use the IRR worksheet...

There is no IRR worksheet.

Instead, IRR is found under IVK worksheet.

Also, there are German names in the Defined Name area for formulas.

Note from the Author or Editor:
The sample files have been revised and will be online soon.

Please change text in Sample Files section from "Use the IRR worksheet..." to "Use the IKV worksheet..."

The syntax and the 3rd bullet should be changed to be in alignment with the formula in Excel.

Nominal_Interest should be changed to Coupon

The 2nd sentence in Example says,

January 4, 2030

the worksheet says under Price Calculations MDURATION worksheet

January 4, 2013

Note from the Author or Editor:
Page 742: The syntax and the 3rd bullet please change from "Nominal_Interest" to "Coupon".

Page 743: The date in the 2nd sentence in Example please change from "January, 4, 2030" to "January 4, 2013".

"Investment" should be changed to

"Finance_rate"

and

"Reinvestment" should be changed to

Reinvest_rate

This will bring the book in alignment with the formulas in Excel.

Note from the Author or Editor:
please change like suggested in error description

To make the book in alignment with the formulas in Excel, change

"Periods" to "Npery"

Note from the Author or Editor:
please change like suggested in error description

Table 15-6 shows periods rather than commas in the numbers.

It should be 15,000 not 15.000

the same error is throughout the table.

The sample files worksheet has surpluses spelled with two s's

The last sentence on page 751 says August 30, 2010. To make it consistent with the Sample File it should just say "six years.'

Table 15-7 has years listed under the Duration Year header, but the workbook just shows the numbers of the year 1-6.

Note from the Author or Editor:
please change like suggested in error description

The syntax on page 752 and the bullets at the top of page 753 should be changed to be in alignment with the formulas in Excel.

First_Interest_Date should be changed to First_Coupon
Yield should be changed to Yld
Repayment should be changed to Redemption

Last bullet on the page also refers to First_Interest_Date and it should be First_Coupon

Note from the Author or Editor:
please change like suggested in error description

To make the syntax in alignment with the formulas in Excel, the following changes should be made:

First_Interest_Date should be changed to First_Coupon
Repayment should be changed to Redemption

The 4th bullet says

First_Interest_Date

It should say

First_Coupon

Note from the Author or Editor:
please change like suggested in error description

To make the Syntax in the book in alignment with the formulas in Excel

First_Interest_Date should be changed to First_Coupon
Repayment should be changed to Redemption

The 4th bullet also has First_Interest_Date and it should be changed to First_Coupon

The 6th bullet says

Price and Yield

It should read

Price

(there is no Yield in this formula)

The 8th bullet uses First_Interest_Date

It should be First_Coupon

Finally, the next to last sentence on the page says,

"It is similar to the calculation shown earlier in Figure 15-7."

However, Figure 15-7 in on page 770.

It should read

It is similar to the calculation shown later in Figure 15-7 on page 770.

Note from the Author or Editor:
Change (whole page):
"First_Interest_Date" to "First_Coupon"
"Repayment" to "Redemption"

Change in the 6th bullet:
"Price and Yield" to "Price"

Change the next to last sentence on the page:
"It is similar to the calculation shown earlier in Figure 15-7."
to
"It is similar to the calculation shown later in Figure 15-7 on page 770."

In order to make the book in alignment with the formulas in Excel the following changes should be made:

Last_Interest_Date should be changed to Last_Interest
Yield should be changed to Yld
Repayment should be changed to Redemption

These changes should be made in both the Syntax and bullets.

Note from the Author or Editor:
Please change text in both the Syntax and bullets:
"Last_Interest_Date" to "Last_Interest"
"Yield" to "Yld"
"Repayment" to "Redemption"

First of all the workbook ODDLYIELD has between spelled betwenn

Also the German word Zinssatz for Interest rate appears

Also assumed is mispelled as assumend in two instances

Syntax:

Last_Interest_Date should be changed to Last_interest
Repayment should be changed to Redemption

On page 760, bullet one should be changed to Last_interest
Bullet four should be changed to Redemption

Pg. 761 the formula should replace "Repayment" with Redemption

and the second sentence under Example reads

"It is similar to the calculation in Figure 15-7, shown earlier."

It should say,

"It is similar to the calculation in Figure 15-7, shown later on page 770.

Note from the Author or Editor:
On Page 759: ODDLYIELD () - Syntax

"Last_Interest_Date"
should be changed to
"Last_interest"

"Repayment"
should be changed to
"Redemption"

On page 760
First line
"Last_Interest_Date"
change to
"Last_Interest"

4th Bullet
"Repayment (required)"
change to
"Redemption (required)"

Page 761

In the formula
"Repayment"
change to
"Redemption"

The second sentence under Example reads
"It is similar to the calculation in Figure 15-7, shown earlier".

It should say,
"It is similar to the calculation in Figure 15-7, shown later on page 770".

The sample file will be updated.

The sample files in Repayment Calculation, PMT worksheet has the word

Konto

It is German for "Account"

Note from the Author or Editor:
The sample file will be updated.

In the first paragraph the number "1" should be changed to the number "4" to keep the illustration in Table 15-7 and the sample worksheet in alignment.

Paragraph 2 where each of the formulas show a "1", they should be changed to show a "4."

The 3rd line of the second paragraph should say "124" not "126."

The 3rd sentence in the second paragraph says "counts 239" and it should say "counts 236 and in the same sentence the amount of $29.47 should be $29.50.

Finally, the 4th paragraph on the second line says,

fractional duration of 126 days

It should say

fractional duration of 124 days.

Note from the Author or Editor:
Change all as it is suggested in the error description.

To be in alignment with the formulas in Excel the following changes should be made:

From:

Syntax PRICEDISC(Settlement, Maturity, Disc, Repayment, Basis)

To:

Syntax: PRICEDISC(Settlement, Maturity, Discount, Redemption, Basis)

The 3rd bullet should also be changed from Disc to Discount

Note from the Author or Editor:
Current Syntax
"PRICEDISC(Settlement,Maturity,Disc,Repayment,Basis)"
change to
"PRICEDISC(Settlement,Maturity,Discount,Redemption,Basis)"

In the 3rd bullett it should read "Discount"
instead of "Disc."

Repayment should be changed to Redemption

Note from the Author or Editor:
Change
"Repayment"
to
"Redemption"

THe 4th sentence in the paragraph says.

'It works according to the pattern RECEIVED(day of purchase, day of maturity, usage, repayment, basis) and returns 0.46 percent."

It should say,

'It works according to the pattern RECEIVED(Settlement, Maturity, Investment, Redemption, Basis) and returns 500."

The function RECEIVED does not return a percentage. So, I am not sure which function you really mean to refer to here.

The last sentence in the paragraph says:

"The function YIELDDISC() works the same as RECEIVED() and returns the same result."

That statement is not correct. I think you mean the function INTRATE() in both sentences.

Note from the Author or Editor:
Current:
"It works according to the pattern RECEIVED(day of purchase, day of maturity, usage, repayment, basis) and returns 0.46 percent."

Change:
"It works according to the pattern RECEIVED(Settlement, Maturity, Investment, Redemption, Basis) and returns 500."

Change
"RECEIVED()"
to
"INTRATE()."

The workbook has the word

ZINS

which is German for Interest

Note from the Author or Editor:
The sample file has been revised and will be online soon.

The Syntax and 4th bullet have the word "Redemption" as the field name in the formula.

It should be changed to "Discount"

The 4th bullet should be further changed to say

"Specifies the percentage of the discount rate"

Note from the Author or Editor:
Change
"Redemption"
to
"Discount"

and current
"Specifies the percentage of the anticipative interest yield"
change to
"Specifies the percentage of the discount rate"

In order to make the Syntax in the book, the bullets and the formulas in Excel in alignment the following changes should be made:

Purchase_Value should be changed to Cost
Residual_Value should be changed to Salvage

Note from the Author or Editor:
Change
"Purchase_Value"
to
"Cost"

and change
"Residual_Value"
to
"Salvage"

The first sentence the last word in the sentence refers to the function:

RECEIVED().

That function does not return a percentage.

I think you mean to say:

INTRATE().

Note from the Author or Editor:
In the first sentence of page 789 "RECEIVED()" sholuld say "INTRATE()."

Under TBILLYIELD, the syntax and the 3rd bullet should be changed to Pr rather than Price.

The definition 1st sentence says,

...is arrears.

It should say,

...in arrears.

Finally, on page 791 the first sentence after the word Example

refers to YIELDDISC() AND RECEIVED().

I think it should say,

refers to YIELDDISC() AND INTRATE().

Note from the Author or Editor:
Page 790 - Syntax of the TBILLYIELD function: change "Price" to "Pr."
In the first sentence of the definition paragraph "annual interest rate is arrears" should read "annual interest rate in arrears."
In the third bullet point of the argument list: "Price (required)" should read "Pr (required)."
On page 791 in the paragraph Example: "RECEIVED()" should read "INTRATE()."

In order to make the syntax in the formulas in Excel match the ones in the book the following changes should be made to the syntax and bullets:

Price should be changed to Pr
Repayment should be changed to Redemption

The next to last bullet also uses the word Repayment when it should be Redemption.

The formula on pg. 801 uses Repayment and it should be replaced with the word Redemption also.

Note from the Author or Editor:
Page 799 -
Syntax: change "Price" to "Pr" and "Repayment" to "Redemption"
4th bullet "Price (required)" to "Pr (required)"
5th bullet "Repayment (required)" to "Redemption (required)".
Page 801 in the formula "Repayment" should read "Redemption".

The first sentence in the last paragraph says,

"...the next coupon payment date: April 2, 2011."

It should say,

"...the next coupon payment date: January 4, 2011."

Note from the Author or Editor:
In the second line of the last paragraph instead of "April 1, 2011" the date must be "January 4, 2011."

The syntax should be changed to be in alignment with Excel.

Price should be changed to Pr
Repayment should be changed to Redemption

The last sentence on the page refers to RECEIVED()

I think it should be INTRATE() because RECEIVED () does not return a percentage.

Note from the Author or Editor:
Change
"Price"
to
"Pr."

Change
"Repayment "
to
"Redemption."

Change
"RECEIVED()"
to
"INTRATE()."

Instead of "target value search" it should be "goal seek".

Page 804- the first sentence in the last paragraph says

...results from the repayment amount...

It should say

...results from the redemption amount...

A similar error is made in the first full paragraph, the first sentence on page 805.

The paragraph beginning with Bill of Exchange has an error in the last function mentioned in the last sentence.

It says (or RECEIVED()) and it should say

(or INTRATE())

Note from the Author or Editor:
On page 804 - the first sentence in the last paragraph
"results from the repayment amount"
should read
"results from the redemption amount"

On page 805 - the first sentence of the second paragraph
"the difference between repayment and price must be"
should be
"the difference between redemption and price must be".

On page 805 - last sentence of the forth paragraph
"(or RECEIVED()) "
should read
"(or INTRATE())"

In order to make the book in alignment with the formulas in Excel the following change should be made to the syntax and the next to last bullet on the page as follows:

Price should be changed to Pr

The first sentence in the second paragraph on pg. 808 says,

Example A federal bond was issued in the year 2000...

It should say

Example A federal bond was issued in the year 2010...

The next to last sentence says,

Using the known data with YIELDMAT() returns 0.32 percent.

It should say,

Using the known data with YIELDMAT() returns 0.39 percent.

Note from the Author or Editor:
In the syntax line of the YIELDMAT() function and in the two following bulleted lists replace "Price" by "Pr".

In the first sentence in the second paragraph on pg. 808,
"in the year 2000"
should say
"in the year 2010."

In the last line of the same paragraph
replace "0.32 percent" by "0.39 percent."

I suspect the paragraph that begins with "The sign number is taken ..." should read "The sign of the number is taken ..."

Note from the Author or Editor:
Please change from
"The sign number is taken ..."
to
"The sign of the number is taken ..."

"All four runners can make first place."

(probably "Any of the four runners could make first place." ... "All four" could, theoretically, TIE for first place, but in practical terms, only one will.)

Note from the Author or Editor:
Change from
"All four runners can make first place."
to
"Every of the four runners could make first place."

The sentece says on line 2 of the paragraph,

"you have to press Ctrl+Page Up+Enter after you enter the formula."

It should say,

"you have to press Ctrl+Shift+Enter after you enter the formula."

Note from the Author or Editor:
Please change the text on page 857 from
"...you have to press Ctrl+Page Up+Enter after you enter the formula."
to
"...you have to press Ctrl+Shift+Enter after you enter the formula."

More German is found in the SIGN() worksheet.

It says:

Verluste
Gewinn
Saldo

It should say:

Losses
Profit
Balance

Note from the Author or Editor:
Corrected sample file. Sent to editor.

It says:

...so you must press Ctrl+Page Up+Enter after you enter the formula.

It should say:

...so you must press Ctrl+Shift+Enter after you enter the formula.

Note from the Author or Editor:
Please change the text on page 877 from
"...so you must press Ctrl+Page Up+Enter after you enter the formula."
to
"...so you must press Ctrl+Shift+Enter after you enter the formula."

More German on the worksheet.

It says,

Ergebnis:

It should say,

Result:

Note from the Author or Editor:
The sample file will be updated.

The Sample Files sections refers to PRODUCT_SUM worksheet.

There is no such worksheet.

It should read: SUMPRODUCT() worksheet.

Also in the worksheet a German word appears.

It says,

Ananas

It should say,

Pineapple

Note from the Author or Editor:
Corrected sample file. Sent to editor.