For example, Excel displays the #DIV/0! … The ISERROR function in Excel checks whether a value is an error and returns TRUE or FALSE.Add the IF function. … Use the IFERROR function to return the result of a formula (if there’s no error) or an alternative result, such as text (if there’s an error).
How do you use Iserror formula?
- Summary. …
- Test for any error.
- A logical value (TRUE or FALSE)
- =ISERROR (value)
- value – The value to check for any error.
- The ISERROR function returns TRUE for any type of error, including #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, #NULL!, #CALC!, and #SPILL! errors.
Why is Iserror used?
ISERROR is used in combination with the IF function to identify a potential formula error and display other formulas or text strings in message form or blanks. It can also be used with the IF function to display a custom message or perform some other calculation if an error is found. In financial analysis.
