# 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.* 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.