Differences

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

--- syntax:functions:isnumber [2018/10/28 15:28] – dmitry
+++ syntax:functions:isnumber [2021/08/28 20:22] (current) – craigt
@@ Line 1: / Line 1: @@
 ====== IsNumber(expression) ======
+Category:  Logical function
-Returns TRUE if result of //expression// is a number, otherwise returns FALSE.
+\\
+=====Description=====
+This function returns TRUE if the result of //expression// is a number.  Otherwise, it returns FALSE.
+\\
+=====Arguments=====
+^Argument^Type^Description^
+|expression|Expression|Any expression that could potentially result in a number.|
+**Return value type:** Boolean (TRUE/FALSE)
+\\
+=====Examples=====
+  isnumber(123) //Returns TRUE
+  isnumber("It's a number!") //Returns FALSE
+  isnumber(100/3) //Returns TRUE
+  isnumber([FieldA]) //Returns FALSE (where [FieldA] is empty)
+\\
+===== See also =====
+  * [[syntax:functions:isboolean|IsBoolean(expression)]]
+  * [[syntax:functions:isempty|IsEmpty(expression)]]
+  * [[syntax:functions:iserror|IsError(expression)]]
+  * [[syntax:functions:isinteger|IsInteger(expression)]]
+  * [[syntax:functions:isnumeric|IsNumeric(expression)]]
+  * [[syntax:functions:istext|IsText(expression)]]
-^  Example  ^  FieldA  ^  Result  ^
-| IsNumber( [FieldA] )  |  200 |  TRUE  |
-| IsNumber( [FieldA] )  | It's a number!  |  FALSE   |
-| IsNumber( [FieldA] )  |   |  FALSE   |