Handling Error Messages- IFERROR, ISERROR and AGGREGATE

Please purchase the course before starting the lesson.

Particularly in budgets and forecasts, 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).

IFERROR ISERROR AGGREGATE

Back to: Budgeting and Forecasting with Excel Course > Some more budgeting and forecasting tips and tricks