Microsoft Office Tutorials and References

In Depth Information

**Correcting Calculation Errors**

For Your Information: Avoiding Error Displays in Formulas

If you include empty cells in a formula, an error message, such as

#DIV/0! might appear in the formula cell. You can avoid this message

by adding a function to check for errors. If the formula generating

an error message for empty cells is =
Formula
, then change it to

=IF(ISERROR(
Formula
),””,
Formula
). If the ISERROR function is

true, the IF function returns an empty string, instead of an error mes-

sage.