Please help with a calculation.

Power2006

New Member
Joined
Jan 17, 2006
Messages
29
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
ABCDEF
1Total Sales For Last Week
2ItemRetail PriceUnitsSalesReductionsReduction Per 1.00 Dollar
3Hamburger$3.00750$2,000.00$500.00
4Cheesburger$4.001,450$5,000.00$1,500.00
5Hotdog$2.00850$1,400.00$200.00
Sheet1
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
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

Board Regular
Joined
Mar 11, 2003
Messages
72
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
 

Power2006

New Member
Joined
Jan 17, 2006
Messages
29
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?
 

Forum statistics

Threads
1,137,330
Messages
5,680,857
Members
419,936
Latest member
rphill48

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top