Understand IFERROR Function Excel Add-in complete Reference

Understand IFERROR Function Excel Add-in complete Reference

IFERROR

Is a Excel inbuilt function can be implemented to manage the errors returned by a formula using default values to give a meaningful result.

Syntax

=IFERROR(value, value_if_error)

Example

Take a look at “Result” column where Row-3 and 5 contains #DIV/0! error because we tried to perform division by ZERO. It looks odd within result hence you might wish to replace it with ZERO in-spite of “#DIV/0!“. The IFERROR function will help to make it happen.

Example

Output

Next >> Error trapping in Excel a complete reference

Leave a Reply

Your email address will not be published.