Reverse Target Qty Using Percentage

[jmynerd]

Hello all, I need some assistance with this formula -

I have a sheet that calculates a gap between two given values, and then represents that gap against one of the values as a percentage.

Example:​

Value 1: 1000
Value 2: 700​

Gap (Value 1 - Value 2): 300​

Gap %: (Gap / Value 2): 43% (rounded up)​

I would like to put a formula into my sheet that will tell me what number Value 2 needs to equal to produce a Gap % of 25%.

Using same Example:​

Value 1: 1000
Value 2: ?​

Gap (Value 1 - Value 2): ?​

Gap %: (Gap / Value 2): 25%​

Is this possible to achieve?

Thanks in advance -

 

[Marcelo Branco]

Try

Value2 = Value1/1.25

M.

 

[jmynerd]

Try

Value2 = Value1/1.25

M.

This works perfectly, THANK YOU!!!!