Returns the boolean value true if the value passed to the function is a number else returns false.
= ISNUMBER(value)
|
value |
A value which has to be checked. The value can be specified as an integer (e.g., 37), a decimal value (e.g., 37.48), as a string, or as the value of a variable (e.g, UnitPrice). |
Boolean
|
Example |
Returns |
|
= ISNUMBER(37.48) |
True |
|
= ISNUMBER(“abcd”) |
False |
|
= ISNUMBER(“$-1,234”) |
True |
|
= ISNUMBER(UnitPrice) |
True if the value of UnitPrice is a number else returns False |