Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Checks whether a value is a number, and returns TRUE or FALSE.
Syntax
ISNUMBER(<value>)
Parameters
Term |
Definition |
|---|---|
value |
The value you want to test. |
Property Value/Return Value
TRUE if the value is numeric; otherwise FALSE.
Example
The following three samples show the behavior of ISNUMBER.
//RETURNS: Is number
=IF(ISNUMBER(0), "Is number", "Is Not number")
//RETURNS: Is number
=IF(ISNUMBER(3.1E-1),"Is number", "Is Not number")
//RETURNS: Is Not number
=IF(ISNUMBER("123"), "Is number", "Is Not number")