Can Excel's Solver be used to solve a set of two equations?

AI Thread Summary
Using the Solver in Excel to solve a set of two equations involves a step-by-step process. First, ensure you have the Solver add-in enabled in Excel. Next, define the objective cell, which contains the formula you want to optimize. Then, set the variable cells that the Solver will adjust to achieve the desired result. After that, input the constraints that limit the values of the variable cells. Finally, run the Solver to find the solution. For practical examples, users are encouraged to refer to the Solvsamp.xls workbook located in the Office\Samples folder. Sharing specific problems can also facilitate targeted assistance.
TSN79
Messages
422
Reaction score
0
I'm trying to use the solver in Excel to solve a set of two equations, but I can't figure out how it works. Can someone give me a step by step description?
 
Computer science news on Phys.org
Admittedly, I don't use that function. I can usually do it quicker with other methods. That's not to say I won't try something though.

From the help file:
Microsoft Excel includes a workbook, Solvsamp.xls in the Office\Samples folder, that demonstrates the types of problems you can solve.

Did you take a look at that file to see if you could figure out what you need?

Or just post your actual problem you want to solve and we'll see if we can't figure it out too.
 
I found an explanation somewhere else, but thanks anyway FredGarvin!
 
This week, I saw a documentary done by the French called Les sacrifiés de l'IA, which was presented by a Canadian show Enquête. If you understand French I recommend it. Very eye-opening. I found a similar documentary in English called The Human Cost of AI: Data workers in the Global South. There is also an interview with Milagros Miceli (appearing in both documentaries) on Youtube: I also found a powerpoint presentation by the economist Uma Rani (appearing in the French documentary), AI...

Similar threads

Back
Top