Please help with a calculation.

[Power2006]

Can someone help me calculate this. This is probably simple, but for some reason it didn't seem right when I did this.
What I need to do is to find the Amount of Reduction Per one dollar of that specific item. Thanks.

Book1
	A	B	C	D	E	F
1	Total Sales For Last Week
2	Item	Retail Price	Units	Sales	Reductions	Reduction Per 1.00 Dollar
3	Hamburger	$3.00	750	$2,000.00	$500.00
4	Cheesburger	$4.00	1,450	$5,000.00	$1,500.00
5	Hotdog	$2.00	850	$1,400.00	$200.00
Sheet1

 

[Richard Schollar]

Hi

It looks like you're after:

=D3/E3

If that's the sales actually made. If it's sales before reductions then maybe:

=(D3-E3)/E3

Best regards

Richard

 

[jfuredy]

Actually, doesn't he need =E3/D3 since he is looking for "Reduction per dollar?" Or =E3/(D3-E3). This would results in 0.25 to 0.33 reduction per dollar, depending on how you define the dollar.

Joe

 

[Richard Schollar]

Yeah Joe - I got that round the wrong way

 

[Power2006]

This doesn't look right. What you guys just did was reductions per unit though right? So would I do =E3/D3 to get reduction per unit. Then to get reduction per 1 Dollar, i would do =(E3/D3)/B3?? Is that correct?