ISNUMBER in excel is a logical function in excel which we use to find out that if the target or the cell being referred to is blank or not, the method of using this formula is =ISNUMBER ( Reference Cell) the argument reference cell is the cell which we want to check or identify, if we have for example =ISNUMBER (T1XT) the output is false as the argument does not only has numbers in it.
Syntax:= ISNUMBER (value)
The ISNUMBER function syntax has the following arguments:
- Value (required argument) – This is the expression or value that needs to be tested. It is generally provided as a cell address.
Example: Let’s look at some Excel ISNUMBER function examples and explore how to use the ISNUMBER function as a worksheet function in Microsoft Excel:
Syntax: =ISNUMBER(A2)
Result:
Based on the Excel spreadsheet above, the following ISNUMBER examples would return:
Syntax: =ISNUMBER(A3)
Result: FALSE
Syntax: =ISNUMBER(A4)
Result: FALSE
Syntax: =ISNUMBER(A5)
Result: TRUE
Syntax: =ISNUMBER(A6)
Result: FALSE
Syntax: =ISNUMBER(A7)
Result: TRUE
Syntax: =ISNUMBER(A8)
Result: FALSE
Syntax: =ISNUMBER(A9)
Result: FALSE
Note:
- Typically, value is supplied as a cell address, but you can wrap other functions and formulas inside ISNUMBER to test the result.
- ISNUMBER will return TRUE for Excel dates and times since they are numeric, and FALSE for numbers entered as text.
- ISNUMBER is part of a group of functions called the IS functions.
