Calculating Percent to Recover from Percent Loss

[jdpro]

Hello,

I would like to enter the formula to calculate the percent increase needed to return to the original after a given percent of decrease. For example, a decrease of 50% requires 100% increase on the remaining 50% to return to the starting point. The formula I find online doesn't seem to work when I try to enter it in excel and I'm sure it's something I'm not doing correctly. What I have found is

((1 / (1 – % loss)] – 1) * 100

I would like to make a column of values representing the percentage loss, and then another column representing the percentage gain required to return to breakeven. I want to set this up with percentages only.

Thanks in advance for any help.

 

[kevin9999]

Maybe this?

Book1
	A	B	C	D	E	F
1	Original	Decrease %	% required of remainder to break even
2	100	50.0%	100.0%
3	100	75.0%	300.0%
4	100	25.0%	33.3%
5	100	10.0%	11.1%
6	100	90.0%	900.0%
7	100	0.0%	0.0%
8
Sheet1

Cell Formulas
Range	Formula
C2:C7	C2	=1/(A2-A2*B2)*B2*100

 

[jdpro]

That is cool Kevin9999, thanks! The only change I made was instead of making the column for 100, I used 100 in the formula for A2. Much appreciated!

 

[kevin9999]

Happy to help, and thanks for the feedback