IFERROR function is used when a formula has return error like "#N/A", #VALUE", #NAME" at that time the error will hide by a predefined value.

###
*Syntax of IFERROR Function*

=IFERROR(Value, Value if error)

###
*Arguments** of IFERROR Function*

Value: return values from reference or formula which contains error

Value if error: Predefined value to be shown on behalf of error

###
*Behavior** of IFERROR Function*

Here we have taken an example of the data in which month names and its figures are shown.

Here we have used IFERROR function which shows the value of dividing 55 by a letter JANUARY will return INVALID.

If we use the division function without IFERROR it will return #VALUE error.

#VALUE error will not look good in your sheet so we can have to look a specific name to cover up the error.

## No comments:

## Post a Comment