Jump to content
Search In
  • More options...
Find results that contain...
Find results in...

Excel Solver more variables than equations

Recommended Posts

Posted · Original PosterOP



I have a simpel problem:


I want to use excel solver for more variables than equations. I understand how the solver works. And also I have a quadratic equation in it.

For my example i have 10 variables and 3 equations.


So i set the solver to my data and let it run.


NOPE!! Solver is dumb and can't create a solution.❌ The solution it creates is bullshit and i checked it: It creates not the right solution i set as 'IS'.


Is it me that i don't see my mistake or is it actually impossible to solve this huge amount of variables❓

I know the t-solution-system in which you can manually (by hand) create solutions for more variables than equations.


I tried also simple linear equations in excel:

2 equations with 3 variables - check ✅

2 equations with 6 variables - OOPSIEE ❌



So my trial and error system doesn't works for my original problem: a quadratic equation system with 10 variables and 3 equations.


So downloaded OpenSolver but this tool only supports linear and simple equations. The other models i can't download and install it in there (expect one of you guys can teach me). --> ❌




All in all excel failed hard and i don't trust excel anymore. So i tested R. The big statistic tool!

You can do optimisation with the functions:


optimx() --> newer


So i learned in many hours how this works BUT:


No one ever has done my original example: A simple equation system with more variables than equations.


I searched the entire WWW. Each forum, each help site, each university pdf, ALL!!!!





Now... I'm frustrated as hell and i need external help! Please help me!!

Thank you so much for answering!! 

And please DON'T tell me that it just works!! Ok?! I don't want this type of help!

I also want as much easy programming language as possible. Im a newbie a lot...



Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now