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.office.com

 AB
1=ISNUMBER(4) = True20
2=ISNUMBER(1.25) = Truesome text
3=ISNUMBER(-100) = -£1.00""
4=ISNUMBER(B1) = -£1.00 
5=ISNUMBER("some text") = £0.00 
6=ISNUMBER(B2) = False 
7=ISNUMBER(B3) = False 
8=ISNUMBER(B4) = False 
9=ISNUMBER(TRUE) = False 
10=ISNUMBER(FALSE) = False 


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