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.
Search JabSto ::




Custom Search