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