How Do I Calculate This Percentage?

kennyzales

New Member
Joined
Mar 2, 2018
Messages
2
Could someone please help me with a basic algebra formula that I can calculate it in Excel?
I need to calculate [variable x] - 35% = known integer (for example, $44.85)

So,

I know the cost of my product. Let's call it $19.95

I know the discount I want to offer: 35%

I need to be able to calculate the original cost (start value) given that I always know my 'after discount' price.

The calculation is:

Start Value minus % of Start Value equals End Value

Any help would be greatly appreciated!
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
You mean like this??


Excel 2013/2016
CDE
2cost before discdiscinitial cost
3$26.9335%$19.95
Sheet1
Cell Formulas
RangeFormula
C3=E3*(1+D3)


Where you need to calculate the 26.93?
 
Last edited:
Upvote 0
Original Price = Discounted Price/(1- discount fraction)
in your example Original Price = 19.95/(1-0.35) = 19.95/0.65 = 30.69
 
Upvote 0
Oops, yep...mopp1 is right. It's this:


Excel 2013/2016
CDE
2cost before discdiscinitial cost
3$30.6935%$19.95
Sheet1
Cell Formulas
RangeFormula
C3=E3/(1-D3)
 
Upvote 0
Thank you, mopp1 and jproffer, for your excellent guidance and advice! Your formula works exactly as needed! :)
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,177
Members
453,021
Latest member
Justyna P

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
Back
Top