**Rational**

Check a cell for the numerical value

**Description**

The Excel ISNUMBER function check if a specified cell has a numeric value and returns “TRUE” if a cell has a numeric value, and “FALSE” when a cell does not.

**Syntax**

=ISNUMBER(value)

**Parameters**

**value – **Refer cell to check numerical value

**Return Value**

A Boolean value (TRUE or FALSE)

**Key Notes**

- The ISNUMBER formula returns TRUE only if the value in the cell is number. The function will also return FALSE if a numerical value is stored in a text format.
- The formula returns TRUE with a number, currency, date and another number formatting. Must not include a non-numerical character or text formatting in the cell.
- The ISNUMBER formula is part of IS functions that return either TRUE or FALSE, depending on the argument they’re evaluating.

For example if a cell is empty to check what it return like here B11 apply formula =ISNUMBER(B11) it return FALSE for blank cell.

## Keep Reading Similar Functions:

### ISODD

The ISODD function checks if a specified cell has an odd numeric value and returns “TRUE” when a cell has an odd numeric value and “FALSE” for an even number.

### N

The N function returns a code number by converting specific reference based on a set of rule. I.e., =N(B6) will return 43093, B6 refers to ’24-12-2017′.

### ISEVEN

The ISEVEN function checks if a cell has even numeric value and returns “TRUE” for even numeric value, & “FALSE” for an odd number.