.

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)

.

Popular posts from this blog

TAMIL NADU Seventh MATHEMATICS, SCIENCE AND SOCIAL SCIENCE BOOK FREE DOWNLOAD | TAMIL NADU 7TH MATHEMATICS, SCIENCE AND SOCIAL SCIENCE BOOK FREE DOWNLOAD

TAMIL NADU Sixth MATHEMATICS, SCIENCE AND SOCIAL SCIENCE BOOK FREE DOWNLOAD | TAMIL NADU 6TH MATHEMATICS, SCIENCE AND SOCIAL SCIENCE BOOK FREE DOWNLOAD