.

ISNUMBER Function Dictionary

Function Dictionary Function Examples Function Categories

ISNUMBER          
 
 
Cell Entry Result
1 TRUE  =ISNUMBER(D4)
1-Jan-98 TRUE  =ISNUMBER(D5)
  FALSE  =ISNUMBER(D6)
#DIV/0! FALSE  =ISNUMBER(D7)
Hello FALSE  =ISNUMBER(D8)
What Does It Do ?              
This function examines a cell or calculation to determine whether it is a numeric value.
If the cell or calculation is a numeric value the result TRUE is shown.
If the cell or calculation is not numeric, or is blank, the result FALSE is shown.
Syntax                
=ISNUMBER(CellToTest)
The cell to test can be a cell reference or a calculation.
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 =ISNUMBER() 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 :  eric
    The Salary is :   £ 12,000
 =IF(ISNUMBER(E35),VLOOKUP(E35,C29:E33,3,FALSE),VLOOKUP(E35,D29:E33,2,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