Search

Learn Iserror File formula Ms Excel Step by step

ISERROR

Know all about Excel Formulas error types
What Does It Do ?
This function tests a cell or calculation to determine whether an error has been generated.
It will show TRUE for any type of error and FALSE if no error is found.

Syntax
=ISERROR(CellToTest)
The CellToTest can be a cell reference or a formula.

Formatting
No special formatting is needed.

Example
The following tables was used to calculate the difference between two dates.
Table 1 shows an error due to the fact that the first entry was entered using an inappropriate
date format.

Table 1

Iserror example 1
Table 2 shows how the =ISERROR() function has been used to trap the error and inform the
user that there has been an error in the data entry.

Table 2

Iserror example 2
=IF(ISERROR(D40 -D39),”Error in data entry”,D40-D39)
Share this article :
Facebook
Twitter
LinkedIn

Leave a Reply