IntermediateLogical Functions
Apply commission tiers with IFS
Return the right rate from several tiers without nesting.
IFS
10 min25 points
IFS practice exercises
Checks several conditions in order and returns the first match. Below are 1 interactive exercise that put it to work on realistic business data — you write the formula, and get told exactly what went wrong when it does not work.
Syntax
IFS(logical_test1, value1, [logical_test2, value2], ...)
Available from Excel 2019.
Practise IFS
Ordered from most approachable to hardest.
When IFS is the right tool
Checks several conditions in order and returns the first match. It belongs to the logical functions family, and it shows up constantly in real work — which is why it is worth being genuinely fluent rather than merely familiar.
Before this one, it helps to be comfortable with IF. The exercises below assume that ground is covered.
Reading about a function is not the same as being able to write it. The exercises on this page exist because the gap between recognising IFS and producing it from memory, correctly, on data you have not seen before, only closes by doing it.
Related functions
Questions about IFS
How do I practise IFS without Excel installed?
Every exercise on this page runs in your browser. You type the IFS formula into a real spreadsheet grid and get told immediately whether it works — no download, no account.
What does IFS do?
Checks several conditions in order and returns the first match. The syntax is IFS(logical_test1, value1, [logical_test2, value2], ...). The exercises below put it to work on realistic business data rather than abstract examples.
How long does it take to learn IFS?
Most people can write a working IFS formula within twenty minutes of practice. Getting it right under pressure — with edge cases, unsorted data and ranges that must survive being filled down — is what the harder exercises here are for.