Particularly in financial models, formula errors like DIV0 can affect your model and in some cases these ‘errors’ are actually not real errors (as in a mistake you made).
As shown below, if last year there was no income and you are working out the change to this year it will correctly give a division by zero error, but this means you can’t use this cell in another formula (note the Average change cell in D16 which is showing an error message even though only 1 of the 4 cells has an error).
What we need is functions that notice when there is an error, and replace it with something else.
To see the full course contents click here.