FinanceTier 215 minintermediate

IF/IFS for Expense Approval Tiers

Assign the correct approval tier to an expense claim based on its amount, with every possible amount covered.

What you will learn

• Write nested conditions (IF or IFS) checked in the correct order
• Explain why conditions checked out of order, or missing a final catch-all, can let a case fall through with no result
• Choose IFS as a clearer alternative to deeply nested IF statements

Excel skills

IF, IFS · Logical Functions

The task

Expense claims need an approval tier based on amount: under 5,000 needs no approval, under 20,000 needs Manager approval, under 50,000 needs Director approval, and 50,000 or more needs CFO approval. In C2, write one formula that assigns the correct tier to every claim, with no amount left without a tier.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free