Forum Discussion

jdpyle519's avatar
jdpyle519
Copper Contributor
Jul 24, 2022

Commission Formula Help

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

excel
  • mtarler's avatar
    mtarler
    Silver Contributor
    Jul 24, 2022
    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) )

Resources