syntax:functions:iserror
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
| Argument | Type | Description |
|---|---|---|
| expression | Expression | Any 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
syntax/functions/iserror.txt · Last modified: 2021/08/16 04:57 by craigt