ISERR Function Dictionary
Function Dictionary | Function Examples | Function Categories |
ISERR | ||||||||||
Cell to test | Result | |||||||||
3 | FALSE | =ISERR(D4) | ||||||||
#DIV/0! | TRUE | =ISERR(D5) | ||||||||
#NAME? | TRUE | =ISERR(D6) | ||||||||
#REF! | TRUE | =ISERR(D7) | ||||||||
#VALUE! | TRUE | =ISERR(D8) | ||||||||
#N/A | FALSE | =ISERR(D9) | ||||||||
#N/A | FALSE | =ISERR(D10) | ||||||||
What Does It Do ? | ||||||||||
This function tests a cell and shows TRUE if there is an error value in the cell. | ||||||||||
It will show FALSE if the contents of the cell calculate without an error, or if the error | ||||||||||
is the #NA message. | ||||||||||
Syntax | ||||||||||
=ISERR(CellToTest) | ||||||||||
The CellToTest can be a cell reference or a calculation. | ||||||||||
Formatting | ||||||||||
No special formatting is needed. | ||||||||||
Example | ||||||||||
The following tables were used by a publican to calculate the cost of a single bottle | ||||||||||
of champagne, by dividing the cost of the crate by the quantity of bottles in the crate. | ||||||||||
Table 1 shows what happens when the value zero 0 is entered as the number of bottles. | ||||||||||
The #DIV/0 indicates that an attempt was made to divide by zero 0, which Excel does not do. | ||||||||||
Table 1 | ||||||||||
Cost Of Crate : | £24 | |||||||||
Bottles In Crate : | 0 | |||||||||
Cost of single bottle : | #DIV/0! | =E32/E33 | ||||||||
Table 2 shows how this error can be trapped by using the =ISERR() function. | ||||||||||
Table 2 | ||||||||||
Cost Of Crate : | £24 | |||||||||
Bottles In Crate : | 0 | |||||||||
Cost of single bottle : | Try again! | =IF(ISERR(E40/E41),"Try again!",E40/E41) | ||||||||