IS_DECIMAL

Description

Returns TRUE if the string represents a valid decimal number; otherwise, returns FALSE.

Syntax

IS_DECIMAL(string) -> Boolean

Parameters

ParameterData TypeRequiredDescription
stringStringYesThe text to evaluate as a decimal number.

Examples

IS_DECIMAL("2500.75")
-- Returns TRUE.
IS_DECIMAL("$1,250.00")
-- Returns FALSE, only decimal numbers are accepted.

Tips

  • The function returns FALSE if the string is empty or contains any characters that do not form a valid decimal number.