Summary: Determine if formula result errors exist in your Microsoft Excel 2003 spreadsheets.
Depending on your Microsoft Excel 2003 spreadsheet, it might prove beneficial to determine whether or not a particular cell's value (which may be based on the result of a formula) is showing an error. Depending on the result, you may wish to alert the user with certain text in a highly-read section of the spreadsheet, perhaps in one of the top row cells.
The following formulas will check for error conditions:
Is cell CELL showing an error? This checks for any error except the #N/A (value not available) error.
Checks to see if cell CELL is showing an error. This will also detect the #N/A value.
Check to see if cell CELL is showing the #N/A (value not available) error only.
These formulas will either return TRUE or FALSE:
Example spreadsheet cells:
This will return the values:
You can combine these functions with the =IF worksheet function to display values or perform other functions depending on the result.
A10: =IF(ISERROR(A1),"The value of A1 has an error. Please check.","")
This will return the value:
A10: The value of A1 has an error. Please check.
Add: Del.icio.us | Digg | Furl | My Yahoo!
Last Modified on: July 13, 2008, at 12:04 A.M. EDT
Return to the Microsoft Excel 2003 Functions and Formulas page.
Search the Site: