Day 91 · Monday, 2 November 2026

From the archive

Intermediate

Grade Suppliers into Scorecard Tiers with IFS

IFS checks its conditions in order and stops at the first one that is TRUE, so a tier ladder only works when the strictest test comes first, and a TRUE at the end is what catches everyone who clears none of the bars.

Task:

You run supplier performance reviews for a food manufacturer's purchasing team. Each supplier is graded on its on-time delivery rate for the quarter: 95% or better is "Preferred", 88% or better is "Approved", 75% or better is "Probation", and anything below 75% is "Suspend". In column C, use a single IFS formula to give each supplier its tier from the on-time percentage in column B. Fill in rows 2 through 7.

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.