Hi guys,
I'm sure this is stupidly simple, but my brain doesn't want to point me in the right direction....
I am selling products, I have my purchase cost, my sale price and I want excel to calculate the price of the product after a given % discount. At the moment, if i type in 15% into the cell, it calculates 15% of the sale price, not 15% off it(C2*D2). I tried going around it by typing 75%, but when applying this to more than 3 products I started getting confused.
Is there a way that my discount % column will show how much of a discount I want to give, and the adjacent cell show the final cost of the product?
<tbody>
</tbody>
thanks!!!
I'm sure this is stupidly simple, but my brain doesn't want to point me in the right direction....
I am selling products, I have my purchase cost, my sale price and I want excel to calculate the price of the product after a given % discount. At the moment, if i type in 15% into the cell, it calculates 15% of the sale price, not 15% off it(C2*D2). I tried going around it by typing 75%, but when applying this to more than 3 products I started getting confused.
Is there a way that my discount % column will show how much of a discount I want to give, and the adjacent cell show the final cost of the product?
A | B | C | D | E | |
1 | Item | Purchase Cost | Sale Price | Discount | Final Price |
2 | #001 | $5 | $12 | 15% |
<tbody>
</tbody>
thanks!!!
Last edited: