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?
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Item[/TD]
[TD]Purchase Cost[/TD]
[TD]Sale Price[/TD]
[TD]Discount[/TD]
[TD]Final Price[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]#001[/TD]
[TD]$5[/TD]
[TD]$12[/TD]
[TD]15%[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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?
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Item[/TD]
[TD]Purchase Cost[/TD]
[TD]Sale Price[/TD]
[TD]Discount[/TD]
[TD]Final Price[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]#001[/TD]
[TD]$5[/TD]
[TD]$12[/TD]
[TD]15%[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
thanks!!!
Last edited: