How to Check Whether a Value is a Number

The ISNUMBER Function is to check whether a value is a number. The result returns TRUE when it is a number.




Value is required, the result returns TRUE when the value is a number and returns False when it is not a number.



Cell A1 is a logical value, not a number, so ISNUMBER(A1) returns False.


Cell A5 is 8, a number, so ISNUMBER(A3) returns True.

Download ISNUMBER Function

Leave a Reply