ISNONTEXT(value)

Returns the value True or False depending if the value is non text.

valueThe value you want to test.

Remarks

* The "value" can refer to a value, cell reference, formula or a named range.
* If "value" is a cell reference to an empty cell, then True is returned.
* You can use the ISTEXT function to return True or False depending if the value is text.
* You can use the ISNUMBER function to return True or False depending if the value is a number.
* For the Microsoft documentation refer to support.office.com

 A
1=ISNONTEXT("some text") = False
2=ISNONTEXT(10) = True
3=ISNONTEXT(B1) = True
4=ISNONTEXT(10/0) = True
5=ISNONTEXT(named_range) = False


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top