Excel ISNUMBER Function

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

Information

Returns

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

Download Excel File

 Example of ISNUMBER function
error

Comments (No)

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.