Baseline Formula
=MIN(0.02*A1,40)+MAX(0.05*(A1-2000),0)
Another option...
= Max(0.02*A1, 0.05*A1 - 60)
= = =
Dana DeLouis
MrAcquire wrote:
Here's another formula that would work
=MIN(0.02*A1,40)+MAX(0.05*(A1-2000),0)
"George" wrote:
Excel 2007
I am trying to get a formula to do the following commision;
If A1 is less then or equal to $2,000.00 then B2 would equal 2% of that
amount.
If A1 is greater then $2,000.00 then B2 would equal 2% of the $2,000.00 plus
5% of the amount over the $2,000.00 baseline.
|