IFS
Clean multi-way logic.
Why planners need it
Replaces unreadable nested IFs. Perfect for RAG status, banding occupancy, or mapping SL to an action.
Syntax
=IFS(test1, result1, test2, result2, …, TRUE, default)
Worked example
Turn service level into a status:
=IFS(SL>=0.9,"Green", SL>=0.8,"Amber", TRUE,"Red") → Amber at 84%.
Watch out: Tests run top to bottom — order them strictest first. End with
TRUE, default or an unmatched value returns #N/A.