Error-Resistant Financial Model
Make a monthly margin and growth model survive months with no revenue and no prior-year data, using IFERROR so averages and counts still work.
What you will practise: Use IFERROR deliberately to give 'no data' months a blank result, and see why a blank result and a zero lead to different averages.
Premium
This is a Premium exercise
Premium members can open this exercise and practise it in the spreadsheet.