ISNUMBER

Description

The ISNUMBER function tests where a value has a numeric type and is not blank.

Syntax

ISNUMBER(value)
Argument Required Description
value Yes The value you wish to test is numeric.

Result

  • TRUE if the value has a numeric type and is not blank
  • FALSE if the value does not have a numeric type or is not blank

Examples

The ISNUMBER function checks first and foremost the type of the value. Applying ISNUMBER to a text value will always evaluate to FALSE, even if there is a number in the text.

Expression Result Notes
ISNUMBER(3.4) TRUE
ISNUMBER("Bob") FALSE "Bob" has a text type, not numeric.
ISNUMBER(TRUE) FALSE TRUE is a value with a logical type, not numeric type
ISNUMBER(42) TRUE
ISNUMBER("42") FALSE Whenever you use quotes, the result has a type of text, not numberic
ISNUMBER(1/0) FALSE Dividing by zero results in a blank numeric value
ISNUMBER(0) TRUE
ISNUMBER(-1) TRUE
Next item
LAST