Calculation Formulas
Back to Calculation Formulas Overview
Back to Functions Overview
Function "IsNum"
IsNum(arg)
Function: Checks if the given argument can be converted into a number or set of numbers. Returns "true" if the argument can be converted into a number or set of numbers, "false" if not.
This function is a companion function to ToNum: If IsNum returns "true" for a given argument, then it is safe to use ToNum on the same argument (i.e. ToNum will not generate an error when used with the same argument).
Return-Type: Boolean
Arguments:
arg - can be of any type:
- Text: The text is parsed and an attempt is made to convert it into a number. If this is successful, then "true" is returned, otherwise "false".
- Text Set: All elements in the set are parsed and converted into numbers. If this is successful for all elements in the set, then "true" is returned, otherwise "false".
- Boolean: Always results in a return value of "true".
- Number or Number Set: Always results in a return value of "true".
Examples:
IsNum("12345")
IsNum(&AGE;)
IsNum(true)
IsNum("123" + "456")