ISNUMBER

ISNUMBER(value)

Returns the boolean True or False depending if the value is a number.

value

The value you want to test.

REMARKS

* The "value" can refer to a value, cell reference, formula or a named range.
* You can use the ISODD function to return True or False depending if the value is an odd number.
* You can use the ISEVEN function to return True or False depending if the value is an even number.
* You can use the ISTEXT function to return True or False depending if the value is text.
* You can use the ISPRIME - User Defined Function function to return if a number is a prime number.
* You can use the ISINTEGER - User Defined Function function to return if a number is an integer.
* You can use the ISDATEVALID - User Defined Function function to return if a number represents a valid date.
* This function has been available since Excel 1997.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A	B
1	=ISNUMBER(4) = True	20
2	=ISNUMBER(1.25) = True	1/1/2023
3	=ISNUMBER(-100) = True	some text
4	=ISNUMBER(B1) = True	""
5	=ISNUMBER(B2) = True
6	=ISNUMBER("4") = False
7	=ISNUMBER("some text") = False
8	=ISNUMBER(B3) = False
9	=ISNUMBER(B4) = False
10	=ISNUMBER(B5) = False
11	=ISNUMBER(TRUE) = False
12	=ISNUMBER(FALSE) = False

1 - Is the value 4 a number.
2 - Is the value 1.25 a number.
3 - Is the value -100 a number.
4 - Is the value in cell "B1" a number.
5 - Is the value in cell "B2" a number. This is a date serial number that is displayed as a date.
6 - Is the text string "4" a number.
7 - Is the text string "some text" a number.
8 - Is the value in cell "B3" a number.
9 - Is the value in cell "B4" a number.
10 - Is the value in cell "B5" a number. This is an empty cell.
11 - Is the value TRUE a number.
12 - Is the value FALSE a number.