=MIN(A1,100)*5%+MIN(50,MAX(A1-100,0))*75%+MAX(A1-150,0)*1%
--
HTH
RP
(remove nothere from the email address if mailing direct)
"abryan" wrote in
message ...
Hello, I have read the threads about similar problems on this site, but
nothing seems to work for me so perhaps I am doing something wrong.
I need to calculate commission varying by range:
5% of sales up to 100
75% of sales from 100 to 150
1% of sales above 150
I have tried using the IF function but can't figure out if there is a
way to signify "if less than x AND greater than y, then z".
--
abryan
------------------------------------------------------------------------
abryan's Profile:
http://www.excelforum.com/member.php...o&userid=29118
View this thread: http://www.excelforum.com/showthread...hreadid=488360