ISTEXT Function (Functions in Excel)
Cell To Test | Result | |
Hello | TRUE | =ISTEXT(D4) |
1 | FALSE | =ISTEXT(D5) |
25-Dec-98 | FALSE | =ISTEXT(D6) |
FALSE | =ISTEXT(D7) |
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. |
ID No. | Name | Salary | |
1 | Alan | £10,000 | |
2 | Eric | £12,000 | |
3 | Carol | £8,000 | |
4 | Bob | £15,000 | |
5 | David | £12,000 | |
Type Employee Name or ID : | 3 | ||
The Salary is : | £ 8,000 | ||
=IF(ISTEXT(E33),VLOOKUP(E33,D27:E31,2,FALSE),VLOOKUP(E33,C27:E31,3,FALSE)) | |||
0 comments:
Post a Comment