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

Click For Summary
SUMMARY

Excel's Solver can effectively solve a set of two equations by utilizing its optimization features. Users can refer to the sample workbook, Solvsamp.xls, located in the Office\Samples folder, which demonstrates various problem-solving techniques. For those unfamiliar with Solver, posting specific equations can facilitate community assistance in finding solutions. The discussion emphasizes the importance of understanding Solver's functionality for efficient problem-solving in Excel.

PREREQUISITES
  • Basic knowledge of Microsoft Excel functionalities
  • Understanding of mathematical equations and systems of equations
  • Familiarity with Excel's Solver tool and its interface
  • Ability to navigate and utilize sample files in Excel
NEXT STEPS
  • Explore the capabilities of Excel's Solver tool in detail
  • Review the sample workbook Solvsamp.xls for practical examples
  • Learn how to formulate equations suitable for Solver
  • Investigate alternative methods for solving equations in Excel
USEFUL FOR

This discussion is beneficial for Excel users, mathematicians, and data analysts who seek to leverage Solver for solving equations efficiently.

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!
 

Thread 'Looking for a reliable inkjet All-In-One printer for photos and docs'

I am having a hell of a time finding a good all-in-one inkjet printer. I must have gone through 5 Canon, 2 HP, one Brother, one Epson and two 4 X 6 photo printers in the last 7 yrs. all have all sort of problems. I don't even know where to start anymore. my price range is $180-$400, not exactly the cheapest ones. Mainly it's for my wife which is not exactly good in tech. most of the problem is the printers kept changing the way it operate. Must be from auto update. I cannot turn off the...
View full post »

Similar threads

Fixing Annoying Word/Excel Windows Problem
  • · Replies 3 ·
Replies
3
Views
2K
"Allow editing" absent in sent EXCEL file
  • · Replies 13 ·
Replies
13
Views
2K
Undergrad What is the proper format for solving this ODE using an Excel add-in calculator?
  • · Replies 3 ·
Replies
3
Views
2K
Excel and Open Office Calc Freeze Upon Opening
  • · Replies 20 ·
Replies
20
Views
3K
HP 48G equation solver and multiple solutions
  • · Replies 5 ·
Replies
5
Views
7K
An electric circuit problem involving 5 current variables
  • · Replies 28 ·
Replies
28
Views
2K
Excel: Inserting many Horizontal rows in same Cell
  • · Replies 14 ·
Replies
14
Views
2K
Unexpected behavior in Excel when sorting
  • · Replies 9 ·
Replies
9
Views
3K
Calculators TI-89 - how to delete equation on numeric solver?
  • · Replies 8 ·
Replies
8
Views
9K
Help with Creating An Excel Line Graph
  • · Replies 1 ·
Replies
1
Views
1K