# Help in Calculating Percentage based on \$\$\$

#### AudriGib11

##### New Member
I have the following:

Discount = 0.4
Actual Cost = \$24.96
List Price - \$70.53
Price w/ Discount - 28.21
Sell % after discount - 12%

OK - what I need to know is how much do I need to increase my List Price to make sure that my Selling % after discount is 20%

### Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Try this:
Book2
ABCD
1BEFORE
2Discount0.4
3ActualCost\$24.96
4ListPrice\$70.53
5Pricew/Discount\$28.21
6Sell%afterDiscount12%
7
8TargetSell%20%
9NewListPrice\$78.00
10
11AFTER
12Discount0.4
13ActualCost\$24.96
14ListPrice\$78.00
15Pricew/Discount\$31.20
16Sell%afterDiscount20%
Sheet1

List Price = Cost / ((1-target sell %)*Discount)

Multiply all your actual costs by 3.125 and you'll get 20% net if you discount that price by 40%

Hi Audri,

Take your cost and divide by .8 (or 20% margin).

That will get you your new discounted sell price. Take this discounted price and divide by .4 to get your new list price.

Ron

SCOTT R - YOU ARE A TRUE TRUE TRUE HERO!!!!! You must give me your address so that I can send you a THANK YOU!!!!!!!!

This worked and saved me life!!!!!!! I spent 4 hours trying to figure this out and you did it in 2 min - AWESOME!!!!!!!!!

Replies
10
Views
299
Replies
1
Views
232
Replies
3
Views
214
Replies
6
Views
594
Replies
8
Views
175

1,221,409
Messages
6,159,711
Members
451,587
Latest member
srice33

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

### Which adblocker are you using?

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

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