Day 102 · Friday, 13 November 2026

From the archive

Advanced

Apply Volume Price Breaks with XLOOKUP's Next-Smaller Match

A price-break table lists only the quantity where each discount starts, so most orders fall somewhere between its rows and an exact lookup finds nothing. XLOOKUP's match mode can fall back to the next smaller threshold instead, and that threshold is the start of the band the order belongs to.

Task:

You handle order entry at a packaging wholesaler. Trade customers earn a volume discount that steps up with the number of packs on an order, and the price-break table in F1:G6 says where each step starts: no discount from 1 pack, 5% from 50, 8% from 100, 12% from 250 and 15% from 500. Today's orders are in A2:C7. In D2, use XLOOKUP to find the discount for the pack count in B2 and return the order's net value, packs times list price less that discount, then 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.