ISNUMBER

ISNUMBER(value)

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

valueThe 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 ISDATE - 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

 AB
1=ISNUMBER(4) = -120
2=ISNUMBER(1.25) = -1some text
3=ISNUMBER(-100) = -1""
4=ISNUMBER(B1) = -1 
5=ISNUMBER("4") = 0 
6=ISNUMBER("some text") = 0 
7=ISNUMBER(B2) = 0 
8=ISNUMBER(B3) = 0 
9=ISNUMBER(B4) = 0 
10=ISNUMBER(TRUE) = 0 
11=ISNUMBER(FALSE) = 0 

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 "4" a number.
6 - Is the value "some text" a number.
7 - Is the value in cell "B2" a number.
8 - Is the value in cell "B3" a number.
9 - Is the value in cell "B4" a number.
10 - Is the value TRUE a number.
11 - Is the value FALSE a number.

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top