Forum Discussion
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 a...
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) )
commission = A1 * IF(A1<=1200, 0.2, 0.28)
net = A1 * (1 - IF( A1<=1200, 0.2, 0.28) )
