Is there a function to solve for an unknown in an equation?

[WA]

For example, the equation is:

P*R - (P*G) = D + (D*G)

In the worksheet, each cell would have a number associated with a variable
and I would like to solve for G.

Thanks,

WA

 

[Eduardo]

Hi,
Install solver add-in in your computer

 

[Gary Brown]

G = ((P * R) - D)/(D + P)

 

[zxcv]

G = ((P * R) - D)/(D + P)
--
Hope this helps.  
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown

Not to answer for the OP but he said the formula was just an example.
It sounds like he is asking if there is a function that can do
algebra. My first thought is "no" but I would be interested in seeing
if there is something that can.

 

[WA]

Correct - I am looking for an equation that can do algebra. The solver plugin
takes a lot of time when there are multiple equations. My apologies for the
vague initial post.

 

[Dana DeLouis]

One workaround...
I'll use Range Names. Break the equation into Left and Right hand sides.
Subtract the two.
Have Goal Seek Set LHS - RHS to zero, by adjusting G.
Not sure what you mean by "multiple equations"

LHS =(P*R_)-(P*G)
RHS =D+(D*G)

=LHS-RHS

Note: Solver and Goal Seek are only good for finding 1 solution.
It won't work as-is if you have a polynomial equation to return multiple
solutions.
= = = = = = =
HTH :>)
Dana DeLouis

 

[Billns]

Correct - I am looking for an equation that can do algebra. The solver plugin
takes a lot of time when there are multiple equations. My apologies for the
vague initial post.

Well, how many equations are there and how often do they change? I would
think doing the algebra to solve for each equation as Gary suggested
would be the easiest way. I'm pretty sure Excel doesn't have a function
that will do this for you. You might also consider using an alternate
math only program instead of Excel.

Bill

 

[Bernard Liengme]

Email be directly (get my email addy from my website)
I will show how to solve multiple equation in one go
Or, have a look at http://people.stfx.ca/bliengme/ExcelTips/Solver.mht
best wishes

 

[Michael.Tarnowski]

Hi Bernard,
what file kind is denoted by the extension .mht? - I can open it with
IE but not with FFox.
Cheers Michael

 

[Bernard Liengme]

It is a web page that hold its own images.
I did not know it was browser specific - thanks for the heads up.
best wishes
Bernard