ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Solution for nonlinear set of equations (https://www.excelbanter.com/excel-discussion-misc-queries/153549-solution-nonlinear-set-equations.html)

Peter M

Solution for nonlinear set of equations
 
I have a set of nonlinear polynomial equations with 3 unknowns. Can SOLVER be
used to solve for the unknowns? Any help is appreciated. I have never used
SOLVER before.
Thanks

MartinW

Solution for nonlinear set of equations
 
Hi Peter,

Maybe one of these may help.
http://j-walk.com/ss///excel/tips/tip101.htm

HTH
Martin


"Peter M" wrote in message
...
I have a set of nonlinear polynomial equations with 3 unknowns. Can SOLVER
be
used to solve for the unknowns? Any help is appreciated. I have never used
SOLVER before.
Thanks




Peter M

Solution for nonlinear set of equations
 
Hi Martin-

Thanks for your reply. Not sure if this would help though. Wgat I need is a
solution to system of 3 simultaneous nonlinear equations.

Peter


"MartinW" wrote:

Hi Peter,

Maybe one of these may help.
http://j-walk.com/ss///excel/tips/tip101.htm

HTH
Martin


"Peter M" wrote in message
...
I have a set of nonlinear polynomial equations with 3 unknowns. Can SOLVER
be
used to solve for the unknowns? Any help is appreciated. I have never used
SOLVER before.
Thanks





Jerry W. Lewis

Solution for nonlinear set of equations
 
If you are trying to determine the coefficients for a polynomial fit, then
the equations are linear in the unknown coefficients. Those polynomial
coefficients are easily calcualted by LINEST, as illustrated in MartinW's
link. Perhaps you would find
http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm
easier to follow?

If you are trying to solve equations that are actually nonlinear in the
unknowns, then you sould say more about what those equations are.

Jerry

"Peter M" wrote:

Hi Martin-

Thanks for your reply. Not sure if this would help though. Wgat I need is a
solution to system of 3 simultaneous nonlinear equations.

Peter


"MartinW" wrote:

Hi Peter,

Maybe one of these may help.
http://j-walk.com/ss///excel/tips/tip101.htm

HTH
Martin


"Peter M" wrote in message
...
I have a set of nonlinear polynomial equations with 3 unknowns. Can SOLVER
be
used to solve for the unknowns? Any help is appreciated. I have never used
SOLVER before.
Thanks






All times are GMT +1. The time now is 12:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com