Home Search

DriveWorks Solo 22
IsError

Send Feedback

IsError

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

Syntax

IsError([Value])

Where:

Value is the value to test.

Examples

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.

Example Outcomes

ValueOutcome
10False
RedFalse
#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULLTrue