Day 95 · Friday, 6 November 2026

From the archive

Intermediate

Order Whole Cases for Next Week's Bake with ROUNDUP and MAX

A supplier sells in full cases, so the shortfall has to be rounded up, never to the nearest case. And when there is no shortfall at all, the subtraction goes negative and ROUNDUP pushes it further below zero, so MAX has to clamp it to 0 before the rounding happens.

Task:

You run the stockroom for a small bakery, and on Friday you place the order for next week's production. The sheet in A2:D7 lists how many kilograms of each ingredient next week's bake needs, how much is already on the shelf, and the size of the case the supplier sells it in. In E2, write a formula that returns how many whole cases to order to cover the shortfall, and 0 when the shelf already holds enough. Copy it down to E7.

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.