# ISNUMBER

## 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.

=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.

### 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.

### 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.