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.
Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Check for Errors.
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.