[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
ISLOGICAL ( value )
Description: Determines if value contains a logical value or refers to a cell containing a logical value.
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 logical value or refers to a cell containing a logical value; otherwise, FALSE.
[Example:
ISLOGICAL(TRUE) results in TRUE
ISLOGICAL(A10) results in FALSE, when A10 contains 123
ISLOGICAL({TRUE,2}) results in TRUE
ISLOGICAL({2,TRUE}) results in FALSE
end example]