Day 31 · Thursday, 3 September 2026

From the archive

Intermediate

Work out shipping cost from a shipping method, without a lookup table

SWITCH matches a value against a short list of options right inside the formula — no helper table needed for three shipping tiers.

Task:

You handle order fulfillment at Larkspur Home Goods, a small online furniture store. Every order ships by one of three methods — Standard, Express or Overnight — each billed at a flat rate per kilogram: $2, $5 and $12. There are only three methods and they rarely change, so nobody wants a lookup table for them. In column D, work out each order's shipping cost directly from the method and weight.

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.