Description
The ISNONTEXT Function a conditional function that returns either TRUE or FALSE as result. If means the condition is met, Excel returns the TRUE result otherwise it returns the text FALSE.
Conditional functions play a major role in dynamic Excel modeling as these provide the opportunity to vary results if the particular scenario changes.
In the ISNONTEXT Function, if the referred cell does not contain text, it means the condition is met and the TRUE result will be returned.
Remember in the ISNONTEXT function, is completely opposite to the ISTEXT function in which the true result is returned if the reference is TEXT value.
Any cell not containing text e.g. error, number, and formula/ logical values will be returned as TEXT. However, if numbers or logical values are stored as text this function will return FALSE.
=ISNONTEXT(value)
The ISNONTEXT function’s syntax has the following arguments:
- value Required
The value is the cell reference that you want to test against the condition if the cell is text. The value argument can be a blank (empty cell), error, logical value, text, number, or reference value, etc.
