Calculate EXACT number to achieve an EXACT percentage

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
8,777
It's just basic algebra. You have this formula:

=(I2+I4)/(I4+O4)

that you want to set equal to G8 by changing the I2 value. This leads to this equation:

(X+I4)/(I4+O4)=G8

Now just solve for X.

(X+I4)=G8*(I4+O4)
X=G8*(I4+O4)-I4

Now take the X off and you have your formula.

=G8*(I4+O4)-I4

and since you want the difference between this value and the I2 value, just subtract that:

=G8*(I4+O4)-I4-I2

QED
 

Forum statistics

Threads
1,077,614
Messages
5,335,253
Members
399,009
Latest member
twcaddell

Some videos you may like

This Week's Hot Topics

Top