ISTEXT Formula in Excel

 

What Does It Do ?

This functions tests an entry to determine whether it is text.

If the entry is text is shows TRUE.

If the entry is any other type it shows FALSE.

Syntax

=ISTEXT(CellToTest)

Formatting

No special formatting is needed.

Example

The following table was used by a personnel department to lookup the salary of an employee.

The employee can be entered as a Name or as a Numeric value.

The =ISTEXT() function has been used to identify the type of entry made, and then the =IF() decides which VLOOKUP to perform.

=IF(ISTEXT(E33),VLOOKUP(E33,D27:E31,2,FALSE),VLOOKUP(E33,C27:E31,3,FALSE))