Microsoft Office Tutorials and References

In Depth Information

This formula uses the IFERROR function, which was introduced in Excel 2007.

Figure 15-7 shows a worksheet that uses both versions of this formula.

Figure 15-7:
Two versions of an array formula that calculates the sum of the digits in an integer.

Summing rounded values

Figure 15-8 shows a simple worksheet that demonstrates a common spreadsheet problem: rounding errors. As

you can see, the grand total in cell E7 appears to display an incorrect amount. (That is, it's off by a penny.) The

values in column E use a number format that displays two decimal places. The actual values, however, consist

of additional decimal places that do not display due to rounding (as a result of the number format). The net ef-

fect of these rounding errors is a seemingly incorrect total. The total, which is actually $168.320997, displays as

$168.32.