[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
ISNUMBER ( value )
Description: Determines if value contains a number or refers to a cell that contains a number.
Arguments:
|
Name |
Type |
Description |
|
any |
The value to be tested. No conversion shall take place on an argument passed to this function. |
Return Type and Value: logical – TRUE if value contains a number or refers to a cell that contains a number; otherwise, FALSE.
[Example:
ISNUMBER(10.56) results in TRUE
ISNUMBER(A10) results in FALSE, when A10 contains ABC
ISNUMBER({1,"ABC"}) results in TRUE
ISNUMBER({"ABC",1}) results in FALSE
end example]