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