This lookup formula will do it.
=LOOKUP(SUM(A7:A10),{0,75000,100000,150000},{0,0.3 ,0.8})
=LOOKUP(SUM(A7:A10),{0,75000,100000,150000},{0,0.3 ,0.8})*sum(a7:a10)
Don Guillett
SalesAid Software
"Jenny" wrote in message
...
I want a formula that will calculate like this:
If the total in this cell is between 75,000 and 99,999 then muliply it by
.30. If it's between 100,000 and 149,999 then muliply it by .80. Is this
possible?