This is what I am doing, I hope this helps.

Selling Quanity Amount
Price Purchased Purchased
$5.25 2 $10.50
55.00 2 110.00
105.99 4 423.96
38.70 2 77.40

(e15) 621.86
( D16) 5% (e16) 31.09

590.77
7% 41.35


$632.12

I am needing d16 to show 5% if e15 is =500 and <750, and 10% if e15 is
=750, I have e16 formulated = e15*d16
--
cardfan057


"Alan" wrote:

Sandy's solution is far shorter, efficient and more elegant than mine,
Regards,
Alan.
"cardfan057" wrote in message
...
Thanks
--
cardfan057


"Alan" wrote:

=IF(AND(A1=500,A1<750),A1*0.05,IF(A1=750,A1*0.1, 0))
Regards,
Alan.
"cardfan057" wrote in message
...
I am making an invoice that will figure a discount for a certain amount
of
sale, all from the same cell, if the subtotal is < 500 then they will
get
no
discount, if it is 500 they will get a 5%, and if it is 750 they
will
get
a 10% discount, what formula do i use??
--
cardfan057