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")