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