| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percentage when total sales is a credit
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Apply various percentage with sales between a & b, b & c, etc. | Excel Worksheet Functions | |||
| Enter credit (negative number) in sales template | Excel Discussion (Misc queries) | |||
| formula to calculate sales tax from total sales | Excel Worksheet Functions | |||
| backing sales tax out of a total including sales tax | Excel Worksheet Functions | |||
| percentage of sales | Excel Worksheet Functions | |||
Threaded Mode
