# Please help with a calculation.

#### Power2006

##### New Member
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

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

#### Richard Schollar

##### MrExcel MVP
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
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

##### MrExcel MVP
Yeah Joe - I got that round the wrong way

#### Power2006

##### New Member
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?

Replies
4
Views
386
Replies
2
Views
96
Replies
10
Views
1K
Replies
17
Views
333
Replies
1
Views
714

Threads
1,171,579
Messages
5,876,278
Members
433,191
Latest member
Rect0425

### 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

### 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