Home › Practice questions › IFS › Question 3

Excel IFS Practice Question: Work out the commission: 10% of the sales if they are 100000 or more, 5% if…

By Rinkesh Shah, founder of Cellgrids.

The question

Work out the commission: 10% of the sales if they are 100000 or more, 5% if they are 50000 or more, otherwise 0. Put it in C2 to C4.

The data

	A	B	C
1	Rep	Sales	Commission
2	Rahul	120000	?
3	Priya	60000	?
4	Amit	20000	?

The yellow cells are where your answer goes.

Show answer

Expected results:

C2 = 12000
C3 = 3000
C4 = 0

How it works

Explanation: The highest slab must be tested first, because 120000 is also above 50000. IFS stops at the first match.
Syntax: =IFS(B2>=100000,B2*0.1,B2>=50000,B2*0.05,TRUE,0)
120000 gives 10%: 12000. 60000 gives 5%: 3000. 20000 gives 0.

Try it yourself in the live sheet

Type your formula in the highlighted cell and get instant feedback. Free, no Excel install needed.

Try this question in the live sheet →

IFS syntax

=IFS(logical_test1, value1, [logical_test2, value2], ...)

Checks multiple conditions in order and returns the value for the first one that's true. IFS is used to build decision rules directly into a spreadsheet instead of manually judging each row. Full IFS guide.