Help! Equations with multiple unknown quantities

[ladan]

Hi,

Do you know how to solve equations with multiple unknown quantities in
Excel?

 

[Tom Ogilvy]

What method would you use if you were doing it manually?

 

[Guest]

Equations with multiple unknowns do not solve to descrete values, so Excel is
not necessarily the ideal tool for this. If you want to maximize or minimize
you can try using the solver in the tools menu.

Hope this helps...

 

[Jerry W. Lewis]

If the equations are linear in the unkown, you can write them as
A*b = x
where b is the vector of unkowns, A is a matrix of known coefficients.
The solution is then
=MMULT(MINVERSE(A),x)

Jerry

 

[ladan]

Thank you very much! :

 

[Jerry W. Lewis]

You're welcome. Glad it helped.

jerry