Differences

This shows you the differences between two versions of the page.

--- syntax:functions:iserror [2015/04/03 18:54] – elenap
+++ syntax:functions:iserror [2021/08/16 04:57] (current) – craigt
@@ Line 1: / Line 1: @@
 ====== IsError(expression) ======
+Category:  Logical function
-Returns TRUE if result of //expression// is an error. Otherwise returns FALSE.
+\\
+=====Description=====
+This function returns TRUE if the result of //expression// is an error.  Otherwise, it returns FALSE.
-^  Example  ^  FieldA  ^  Result  ^  Remarks  ^
+\\
-| IsError( 100 / [FieldA] )  |  200  |  FALSE  | |
+=====Arguments=====
-| IsError( 100 / [FieldA] )  |  0  |  TRUE   | Error - division by zero |
+^Argument^Type^Description^
-| IsError( left([FieldA], 'ZZZ') )  |  Red    |  TRUE   | Error - Inappropriate parameter |
+|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:iferror|IfError(expressions, expression2)]]
+  * [[syntax:functions:isboolean|IsBoolean(expression)]]
+  * [[syntax:functions:isempty|IsEmpty(expression)]]
+  * [[syntax:functions:isinteger|IsInteger(expression)]]
+  * [[syntax:functions:isnumber|IsNumber(expression)]]
+  * [[syntax:functions:isnumeric|IsNumeric(expression)]]
+  * [[syntax:functions:istext|IsText(expression)]]