Formula Help

[sundial2k]

I would really appreciate someone with a bigger brain than mine to give
me a hand with a formula.

Here is what I have and what I am trying to do:

I am trying to calculate a rebate. I have a total purchases (C28), a
percentage of purchases (C33), and a percentage of sales (C34). There
is a varying rebate determined by the amount of purchases, provided 2
criteria are met.

Here is what I have so far:
=IF(AND(C34>0.06,C33>0.9),(IF(AND(C28>50000,C28<99999),PRODUCT(C28*0.005)))).
This works fine, but only if the purchases are between $50,000 -
$99,000. I can't figure out how to continue the math for the other
levels of purchases.

$50,000.00 - $99,999.99
½%
$100,000.00 - $149,999.99
1%
$150,000.00 - $199,999.99
1½%
$200,000.00 - $249,999.99
2%
$250,000.00 - $299,999.99
2½%
$300,000.00 +
3%

I look forward to your help!

 

[Frank Kabel]

Hi
try
=IF(AND(C34>0.06,C33>0.9),INT(C28/50000)*0.005,0)
if the rebate is applied on the whole amount