Day 104 · Sunday, 15 November 2026

From the archive

Beginner

Report Year-on-Year Growth When a Line Is New with IFERROR

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.

Task:

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.

The daily challenge is part of Pro

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.

Every day so far

August 2026

September 2026

October 2026

November 2026

18
SolvedOpenProLatest

Recent days

The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.