Solving for x

S

stew12

i would like to know if it is possible to get excel to work out an unknown
value. I need to know what the value of a certain cell should be in order to
when multiplied by another cell is equal to a third.

like : 'D12 =B4*x-E9=0'

so in other words would it be able to do something like solving for x were
20x-40=0

Many thanks
 
T

Toppers

In your example, x=E9/B4 and if you always want a result of zero, then this
formula will work.

In the more general case of y=mx+c

x=(y-c)/m

0=B4*x-E9
0-(-E9)=B4*x

x=E9/B4

HTH
 
Top