November 26th, 2005, 04:48 PM
posted to microsoft.public.excel.worksheet.functions
|
|
commissions by range
As an alternative, see
http://www.mcgimpsey.com/excel/variablerate.html
In article ,
abryan wrote:
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".
|