Excel FunctionsExcel ISTEXT Function

ISTEXT tests if Cell is a text


The ISTEXT Function a conditional function that returns either TRUE or FALSE as result. Thus if 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 ISTEXT Function, if the referred cell contains text, it means the condition is met and the TRUE result will be returned.

Remember in the ISTEXT function, the only cells containing text strings will be returned TRUE.

Any cell not containing text e.g. error, number, and formula/ logical values will be returned as FASLE. However, if numbers or logical values are stored as text this function will return TRUE.


The ISTEXT 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.

Organically grow the holistic world view of disruptive innovation via empowerment.
OUR LOCATIONSWhere to find us
GET IN TOUCHSocial links
Taking seamless key performance indicators offline to maximise the long tail.

Copyright by Excel Accountancy. All rights reserved.

Copyright by BoldThemes. All rights reserved.