Indicates whether the specified value is an error by returning True or False.
When using this function it is important to understand the difference between and error value and an error string.
Please see the topic Info: Error Value And Error String for more information.
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 |