ISNUMBER

Returns true if the specified value is a number value.

Syntax

=ISNUMBER(value, fuzzy)

Arguments

Argument	Type	Description
value	Any	The value to test
fuzzy	Boolean	Specify 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.