Cleaner Branching With IFS

A single IF handles a yes-or-no choice. But what if you have many outcomes, like turning a score into a letter grade A through F? You would have to nest one IF inside another, again and again.

That nesting gets hard to read, easy to break, and tricky to count the closing parentheses. The IFS function was built to fix exactly this. It lets you list condition-and-result pairs in a clean, flat line.

Here is a grade formula written with nested IF functions. Each IF has another IF as its false branch.

It works, but notice how the parentheses pile up at the end and the logic is hard to scan. Imagine maintaining this with eight branches instead of four.