need help making a formula
Does that mean if the sales were 27,336 -
3% of the first 15,000 + 5% of the next 12,336 ?
If that's the case:
A1 = 27,336
=IF(A1="",0,MIN(A1,15000)*0.03+MAX(A1-15000,0)*0.05)
Commisson = 1066.80
--
Biff
Microsoft Excel MVP
"kath" wrote in message
...
i need to make a formula that will show a commission rate of 5% sales over
15,000 with a 3% sales commission for lesser sales. Could someone please
help me with this.
|