.

ISTEXT Function Dictionary

Function Dictionary Function Examples Function Categories

ISTEXT            
 
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))

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download