Day 91 · Monday, 2 November 2026
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.
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.
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.
The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.