ISNUMBER Function (Functions in Excel)
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)) | |||
0 comments:
Post a Comment