Menu
EXCEL ISNONTEXT FUNCTION
Excel ISNONTEXT Function Introduction
This function looks for a non-text value and returns TRUE or FALSE as a logical value. If the value is a non-text value, ISNONTEXT will return TRUE, otherwise FALSE. For blank cells, ISNONTEXT will also return TRUE.
Description of Excel ISNONTEXT Function
Syntax:
=ISNONTEXT (value)
Parameter list:
value – the value which will be evaluated.
Value is frequently provided as a cell address.
Step By Step Guide of ISNONTEXT Function
- If this is a text value or a reference to a cell holding a text value, ISNONTEXT returns FALSE, otherwise TRUE.
- ISNONTEXT returns TRUE when value is a reference to an empty cell.
- ISNONTEXT will return FALSE if value is an empty string, because an empty string is considered text.
Key Points
- Nonprinting letters and whitespace are treated as text, thus if ISNONTEXT is called on a cell that contains them, it will return FALSE even though the cell seems to be empty.
- Numbers entered as text, such as ‘1234,’ are treated as text and return FALSE by ISNONTEXT.
- ‘The logical equal of NOT(ISTEXT(value)) is ISNONTEXT(value).
- In conditional statements, this function is most commonly used in combination with IF.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
