These docs are for v1.0. Click to read the latest docs for v1.2.

ISNUMBER

Returns true if the specified value is a number value.

Syntax

=ISNUMBER(value, fuzzy)

Arguments

ArgumentTypeDescription
valueAnyThe value to test
fuzzyBooleanSpecify whether the test should allow conversion

Examples

=ISNUMBER(1)true
Tests whether the number 1 is a number value.

=ISNUMBER("Name")false
Tests whether the string "Name" is a number value.

=ISNUMBER("1.23", false)false
Tests whether the string "1.23" is a number value without fuzzy matching.

=ISNUMBER("1.23", true)true
Tests whether the string "1.23" is a number value with fuzzy matching.

=ISNUMBER(@"Property 1")true
Tests whether the shape data property @"Property 1" (123) is a number value.