ISNUMBER

Posted on 18-01-2020 , by: admin , in , 0 Comments

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

Leave a comment