Discount calculation
 

Hi every one,
I need some help here...
I made an order form for out reps to fill out.
We offer volume discounts.
$0.01 - $499.99 none
$500.00 - $2499.99 2.5%
$2500.00 - or more 5%
H37 has the total of all products ordered.
Can I make a formula to automatically show these discounts in H38 based on
the value in H37?

on cell H38 enter
=HLOOKUP(h37,{0,500,2500;0,0.025,0.05},2)
provided h37 is not negative




"Kerri" wrote in message
...
Hi every one,
I need some help here...
I made an order form for out reps to fill out.
We offer volume discounts.
$0.01 - $499.99 none
$500.00 - $2499.99 2.5%
$2500.00 - or more 5%
H37 has the total of all products ordered.
Can I make a formula to automatically show these discounts in H38 based on
the value in H37?

Thanks so much for the quick response!!
Worked wonderfully!!

"N Harkawat" wrote:

on cell H38 enter
=HLOOKUP(h37,{0,500,2500;0,0.025,0.05},2)
provided h37 is not negative




"Kerri" wrote in message
...
Hi every one,
I need some help here...
I made an order form for out reps to fill out.
We offer volume discounts.
$0.01 - $499.99 none
$500.00 - $2499.99 2.5%
$2500.00 - or more 5%
H37 has the total of all products ordered.
Can I make a formula to automatically show these discounts in H38 based on
the value in H37?