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