Differences

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

--- syntax:functions:isnumeric [2021/07/20 03:01] – craigt
+++ syntax:functions:isnumeric [2021/08/29 00:39] (current) – craigt
@@ Line 1: / Line 1: @@
 ====== IsNumeric(expression) ======
+Category:  Logical function
-Returns TRUE if the expression is a number or text that looks like a number, otherwise, it returns FALSE.
+\\
+=====Description=====
+This function returns TRUE if the result of //expression// is a number or text that looks like a number.  Otherwise, it returns FALSE.
-^  Example  ^  FieldA  ^  Result  ^
+\\
-| IsNumeric( [FieldA] )  |  200 |  TRUE  |
+=====Arguments=====
-| IsNumeric( [FieldA] )  | It's a number!  |  FALSE   |
+^Argument^Type^Description^
-| IsNumeric( [FieldA] )  |100  |  TRUE   |
+|expression|Expression|Any expression that could potentially result in a number, or text that appears as a number.|
+**Return value type:** Boolean (TRUE/FALSE)
+\\
+=====Examples=====
-=== See also ===
+  isnumeric(123) //Returns TRUE
-  * [[syntax:functions:isinteger|IsInteger]]
+  isnumeric('456') //Returns TRUE
-  * [[syntax:functions:isnumber|IsNumber]]
+  isnumeric('100' & '20') //Returns TRUE (the result '10020' appears as a number)
+  isnumeric('This is a number!') //Returns FALSE
+  isnumeric('100A') //Returns FALSE
+\\
+===== See also =====
+  * [[syntax:functions:isboolean|IsBoolean(expression)]]
+  * [[syntax:functions:isempty|IsEmpty(expression)]]
+  * [[syntax:functions:iserror|IsError(expression)]]
+  * [[syntax:functions:isinteger|IsInteger(expression)]]
+  * [[syntax:functions:isnumber|IsNumber(expression)]]
+  * [[syntax:functions:istext|IsText(expression)]]