From the archive

Day 31

Thursday, 3 September 2026

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.

Recent days

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