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.
Updated 6 months ago