The ‘ISNUMBER’ formula in Excel is used to ascertain whether or not a specified input cell contains a numerical value. It returns TRUE if the specified cell contains a number, or FALSE if it does not. For example, =ISNUMBER(“Test”) would return FALSE, whereas =ISNUMBER(“12”) would return TRUE.

The ISNUMBER function is part of a larger group of IS functions that all return logical values (i.e. TRUE or FALSE). The other IS functions are ISODD, ISEVEN, ISBLANK and ISTEXT.

**Syntax **

=ISNUMBER(value)

**Arguments **

*Value* – input cell to check. Note that only individual cells can be specified.

**Function category**

**Returns**

Returns a logical value i.e. TRUE if the specified cell contains a numerical value or FALSE if it does not.

## Comments (No)