isnumber
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.
| 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) |
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 : | ####### | ||
| =IF(ISNUMBER(E35), VLOOKUP(E35,C29:E33,3, FALSE), VLOOKUP(E35,D29:E33,2, FALSE)) | |||