Commission Formula Help

Occasional Visitor

I am losing my mind on how to do a tiered commission formula.  I think I have just been doing to many.

If sales >$1200 it is at a 20% rate and any sales over $1201 are at 28%. 

Example:

   Sales at $1110.90 would net $888.72

   Sales at $1951.57 would net $1501.13

 

 

Thank you in advance

1 Reply
The simple direct approach could be using an IF() so assume the Sales is in A1 then
commission = A1 * IF(A1<=1200, 0.2, 0.28)
net = A1 * (1 - IF( A1<=1200, 0.2, 0.28) )