Explanation
In this example, the IFERROR function is used to trap and suppress the #DIV/0!
error that takes place if there is no value for Orders (column D).
Without IFERROR, the formula C5/D5 would display a #DIV/0!
error in E6 and E9.
The second argument is only used if the first argument throws an error.
When the formula returns a normal result, the result is displayed.
When the formula returns #DIV/0!, anempty stringis returned and nothing is displayed.
IFERROR is an elegant way to trap and manage errors without using more complicated nested IF statements.
