1. Spreadsheet.com Support
  2. Functions
  3. Information functions

ISNUMBER

Returns TRUE if the value is a number.

Sample Usage

ISNUMBER("Spreadsheet")
ISNUMBER(12)
ISNUMBER(C5)

Syntax

ISNUMBER(value)

  • value - The value to be checked.

 

Examples

ISNUMBER("Spreadsheet") evaluates to FALSE.
ISNUMBER(12) evaluates to TRUE.
ISNUMBER(C5) checks if the value contained in C5 is a number.

Notes

  • Numeric values that are enclosed in double quotation marks are treated as text. So, while ISNUMBER(12) evaluates to TRUE, ISNUMBER("12") evaluates to FALSE.