Indicates whether the specified value is an error by returning True or False.
Error values that are checked are #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? and #NULL
IsError([Value])
Where:
Value is the value to test.
Rule | Meaning |
|---|---|
| IsError(TotalReturn) | This function checks the value in TotalReturn, which is #NAME? to determine if it is an error. In this case the IsError function will return True as #NAME? is an error. |
| IF(IsError(TotalReturn) = True,1,TotalReturn) | This example is making good use of the IsError function so any error does not get driven into any output parameter. In this case when TotalReturn does equal an error value a value of 1 will be used, otherwise the correct result of TotalReturn will be used. |
| Value | Outcome |
|---|---|
| 10 | False |
| Red | False |
| #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL | True |