Solution for nonlinear set of equations

Peter M · External Since: Mar 04, 2006 Posts: 4

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 · External Since: Apr 24, 2006 Posts: 500

Hi Peter,

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

HTH
Martin

"Peter M" <PeterM.TakeThisOut@discussions.microsoft.com> wrote in message
news:F6B3DB0C-496B-4954-9CD6-FB4953EE6045@microsoft.com...
>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 · External Since: Mar 04, 2006 Posts: 4

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" <PeterM.RemoveThis@discussions.microsoft.com> wrote in message
> news:F6B3DB0C-496B-4954-9CD6-FB4953EE6045@microsoft.com...
> >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 · External Since: Mar 08, 2006 Posts: 336

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" <PeterM DeleteThis @discussions.microsoft.com> wrote in message
> > news:F6B3DB0C-496B-4954-9CD6-FB4953EE6045@microsoft.com...
> > >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
> >
> >
> >