Create a Sales Commission Calculator

Pay a higher commission rate when sales beat a threshold.

You will learn to

• Combine IF with absolute references to settings cells

How it works

Store the threshold and rates in their own cells, then use IF with absolute references: =IF(B2>=$F$1,B2*$F$3,B2*$F$2).

For tiered plans, nest IF or use IFS to choose the rate, then multiply by sales. Keep the rates in their own cells so the whole team can see and change them.

=IF(B2>=$F$1,B2*$F$3,B2*$F$2)