Table of Contents

IsError(expression)

Category: Logical function


Description

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


Arguments

ArgumentTypeDescription
expressionExpressionAny expression that could potentially result in an error.

Return value type: Boolean (TRUE/FALSE)


Examples

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)


See also