Sandy,
That is really good! Do I have this right? It took a while to realise how it
works,
1-((A1=750)+(A1=500))
converts the TRUE or FALSE results to 1 or 0 thus returning 1 or 2, then the
*5% returns 5% for 1 and 10% for 2 and A1 is multiplied by that?
Regards,
Alan.

"Sandy Mann" wrote in message
...
You don't say what you want if the amount is exactly 500 or 750 but try:

=A1*(1-((A1=750)+(A1=500))*5%)

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"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