ISNUMBER

Check a cell for the numerical value in Excel
Returns TRUE if the value is a number

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:

Check a cell for odd or even numerical value in Excel

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.

Read More »
Converts data into a code number in Excel

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

Read More »
Check a cell for even number in Excel

ISEVEN

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

Read More »