Day 104 · Sunday, 15 November 2026
Growth is this year divided by last year, minus one, and that division has nothing to divide by for a product line that did not exist last year. IFERROR catches the #DIV/0! for that one row and puts a label a reader understands in its place, while every real answer, including a fall of 100%, passes through untouched.
You prepare the autumn trading review for a garden centre. Sales for each product line, January to October, are in A2:C7: last year in column B and this year in column C. Grow-your-own kits were launched this spring, so they sold nothing last year, and pond supplies were dropped at the end of last season. In D2, work out each line's growth as a decimal, so a rise of 9% reads 0.09, and show the text "New" instead of an error for a line that had no sales last year. Copy it down to D7.
A new exercise every morning, plus every day that came before it — a back catalogue that grows by one a day, whether or not you were here for it.
The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.