calculating a discount

[Josh88]

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?

	A	B	C	D	E
1	Item	Purchase Cost	Sale Price	Discount	Final Price
2	#001	$5	$12	15%

<tbody>
</tbody>

thanks!!!

 

[wideboydixon]

=c2*(1-d2)

wbd

 

[Josh88]

thanks wbd..