I think what you are trying to do is establish the percentage discount given
when taking into account the price and actual selling price. If so this
should do it for you.

=IF(Q7<1,"",100-(Q7/M7%))

The total sale figure doesn't come into it as far as I can see.

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Wanna Learn" wrote:

Hello
In excel 2003 I have the following columns
Price Selling price total sale units sold
2914.00 2409.00 4818.00 2
This is my formula to give the % discount =-1*(Q7/R7-M7)/M7
answer is 17.33% discount
However
There are times that the total sales is a credit(e.g. product was returned)
How do I correct the formula so that when the total sales is a credit I get
blank cell