Home Computer IsNumber Excel formula Learn Step by Step.

IsNumber Excel formula Learn Step by Step.

1 min read
0
0
48
1ST.2

ISNUMBER

Isnumber Excel formula Syntax

 

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.

2ND
=IF(ISNUMBER(E35),VLOOKUP(E35,C29:E33,3,FALSE),VLOOKUP(E35,D29:E33,2,FALSE))
Load More Related Articles
Load More By amitgupta
Load More In Computer

Leave a Reply

Check Also

How to Check BUSY Updates

How to Check BUSY Updates Company > Check BUSY Updates Check BUSY Updates option provid…