ISTEXT Function

Checks whether a value is text.
Sample Usage
IF(ISTEXT([Task Name]1), "This is text", "This is not text")
Syntax
ISTEXT(
  • value
)
  • value
    The value, typically within a cell, to check.
Usage Notes
  • This function is typically used inside of another function, for example: IF, COUNTIF, or SUMIF.
Examples

This example references the following sheet information:

 Clothing ItemItem NumberTransaction TotalUnits Sold
1T-ShirtC001$1,170.0078
2PantsC002$1,491.0042
3JacketC003$812.00217

Given the table above, here are some examples of using ISTEXT in a sheet:

FormulaDescriptionResult
=SUMIF([Clothing Item]:[Clothing Item], ISTEXT(@cell), [Units Sold]:[Units Sold])Sum the values in the “Units Sold” column for rows where the value in the “Clothing Item” column is text. All 3 rows meet the criteria.337
=IF(ISTEXT([Clothing Item]2), [Clothing Item]2 + " is a text value", [Clothing Item]2 + " is not a text value")If the value in the “Clothing Item” column for row 2 is text, return the value in that cell followed by “is a text value”, if not return the value in that cell followed by “is not a text value" text string.
 
Pants is a text value
=COUNTIF([Clothing Item]3:[Units Sold]3, ISTEXT(@cell))Count the number of cells in row 3 that are text values.2
Was this article helpful?
YesNo