Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

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 »
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 »
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 »