This Excel tutorial explains 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 ISNUMBER function in Microsoft Excel is:
ISNUMBER( value )
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 Excel spreadsheet above, the following 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)