Online Financial Modelling, Budgeting and Forecasting Course

Handling Error Messages- IFERROR, ISERROR and AGGREGATE

You don’t have access to this lesson

Please purchase this course, or sign in if you’re already enrolled, to access the course content.

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).

IFERROR ISERROR AGGREGATE

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.

0 of 97 lessons complete (0%)
0
    0
    Your Cart
    Your cart is emptyReturn to Shop