Iserror Formula in Excel
Iserror Formula lets you find what kind of error is there in a cell. It is best used with other logical functions like If Formula.
For example, you can use the ISERROR function in conjunction with the IF function to perform a different action if an error occurs:
= IF( ISERROR(A1), “An error occurred.”, A1 * 2)
This formula checks to see if an error condition exists in A1. If so, the IF function returns the message “An error occurred.” If no error exists, the IF function performs the calculation A1*2.
The values returned by the Iserror formula are
| ISERROR | Value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!). |
This Excel tutorial has been created to help you learn microsoft excel online. On http://www.myelesson.org you get excel help and online file download facility. This video lesson covers the entire topic in simple and easy to understand step by step approach.