Discount calculation

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




"Kerri" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
> >
> >
>
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
> >
> >
>
>
>