Commission rates with IFS

Premium

Reps earn 10% commission on sales of 10,000 or more, 5% from 5,000 and nothing below that. In C2, multiply the sales in B2 by the rate IFS picks: B2*IFS(B2>=10000,0.1,B2>=5000,0.05,TRUE,0).

C2
ABCDEF
1Rep Sales Commission
2Ann 12000
3Ben 7400
4Cy 3900
5Di 10000
6
7
8

Premium lesson

Unlock IFS and SWITCH and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:Conditional formattingDrop-down lists and data validation

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?