IsError(expression)

Category: Logical function

This function returns TRUE if the result of expression is an error. Otherwise, it returns FALSE.

Return value type: Boolean (TRUE/FALSE)

iserror( 100 / [FieldA] ) //Returns FALSE if [FieldA] is 200

iserror( 100 / [FieldA] ) //Returns TRUE if [FieldA] is 0  (Error - division by zero)

iserror( left([FieldA], 'ZZZ') ) //Returns TRUE (Error - Inappropriate parameter)

• IfError(expressions, expression2)
• IsBoolean(expression)
• IsEmpty(expression)
• IsInteger(expression)
• IsNumber(expression)
• IsNumeric(expression)
• IsText(expression)