Learn how to use the Excel ISNUMBER function with syntax and examples.
The Microsoft Excel ISNUMBER function can be used to check for a numeric value.
The syntax for the Microsoft Excel ISNUMBER function is:
ISNUMBER( value )
value is the value that you want to test. If value is a numeric value , this function will return TRUE. Otherwise, it will return FALSE.
The ISNUMBER function can be used in the following versions of Microsoft Excel:
The ISNUMBER function can be used in Microsoft Excel as the following type of function:
Let's look at some Excel ISNUMBER function examples and explore how to use the ISNUMBER function as a worksheet function in Microsoft Excel:
Based on the spreadsheet above, the following Excel ISNUMBER examples would return:
=ISNUMBER(A1) Result: TRUE =ISNUMBER(A2) Result: TRUE =ISNUMBER(A3) Result: TRUE =ISNUMBER(A4) Result: FALSE =ISNUMBER(5) Result: TRUE =ISNUMBER("5") Result: FALSE
(scroll to see more)