Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,101
Default How to use solver to solve for 2 unknown in a linear equation?

How to use Excel to solve for 2 unknown in linear equation, for eg,

x + Y = 1
3x + 4Y =7

Thanks
Mike
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: How to use solver to solve for 2 unknown in a linear equation?

Hi Mike,

You can definitely use Solver in Excel to solve for two unknowns in a linear equation. Here's how you can do it:
  1. First, enter your equations in Excel. In your example, you have two equations:
    x + y = 1
    3x + 4y = 7

  2. Next, you need to set up Solver. Go to the "Data" tab in Excel and click on "Solver" (if you don't see Solver, you may need to install it first).
  3. In the Solver Parameters dialog box, set the "Set Objective" field to the cell where you want to see the result. In this case, let's say you want to solve for x and y in cells A1 and B1, respectively. So you would set the "Set Objective" field to A1.
  4. In the "By Changing Variable Cells" field, enter the cells that contain the variables you want to solve for. In this case, you want to solve for x and y, so you would enter A1:B1.
  5. In the "Subject to the Constraints" section, you need to enter the constraints for your equations. For the first equation, you would enter:
    A1 + B1 = 1

    For the second equation, you would enter:
    3A1 + 4B1 = 7
  6. Finally, click on "Solve" and Solver will find the values of x and y that satisfy both equations.

That's it! Solver will give you the values of x and y that satisfy both equations. If you have any other questions, feel free to ask.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4,624
Default How to use solver to solve for 2 unknown in a linear equation?

One way:

A1: 1
B1: 1
C1: =A1 + B1
D1: =3*A1 + 4*B1


Set Target Cell = D1
Equal to Value of 7
By changing cells: A1:B1
Subject to the Constraints: $C$1 = 1




In article ,
Mike wrote:

How to use Excel to solve for 2 unknown in linear equation, for eg,

x + Y = 1
3x + 4Y =7

Thanks
Mike

  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 211
Default How to use solver to solve for 2 unknown in a linear equation?

Solver. Does it mean "Goal Seak" in Excel 2003?
XL2003 does not have the "Subject to the Constraints": $C$1 = 1
Where is the "Subject to the Constraints"?
--
R. Khoshravan
Please click "Yes" if it is helpful.


"JE McGimpsey" wrote:

One way:

A1: 1
B1: 1
C1: =A1 + B1
D1: =3*A1 + 4*B1


Set Target Cell = D1
Equal to Value of 7
By changing cells: A1:B1
Subject to the Constraints: $C$1 = 1




In article ,
Mike wrote:

How to use Excel to solve for 2 unknown in linear equation, for eg,

x + Y = 1
3x + 4Y =7

Thanks
Mike


  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,440
Default How to use solver to solve for 2 unknown in a linear equation?

No, Goal Seek is not the same as Solver.
Solver is an add-in. It has to be activated: ToolsAdd-ins, check Solver

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Khoshravan" wrote in message
...
Solver. Does it mean "Goal Seak" in Excel 2003?
XL2003 does not have the "Subject to the Constraints": $C$1 = 1
Where is the "Subject to the Constraints"?
--
R. Khoshravan
Please click "Yes" if it is helpful.


"JE McGimpsey" wrote:

One way:

A1: 1
B1: 1
C1: =A1 + B1
D1: =3*A1 + 4*B1


Set Target Cell = D1
Equal to Value of 7
By changing cells: A1:B1
Subject to the Constraints: $C$1 = 1




In article ,
Mike wrote:

How to use Excel to solve for 2 unknown in linear equation, for eg,

x + Y = 1
3x + 4Y =7

Thanks
Mike





  #6   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 211
Default How to use solver to solve for 2 unknown in a linear equation?

Thanks. After adding will it appear in Tools menu or elsewhere? I added but
it didn't appear in tools menu.
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Niek Otten" wrote:

No, Goal Seek is not the same as Solver.
Solver is an add-in. It has to be activated: ToolsAdd-ins, check Solver

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Khoshravan" wrote in message
...
Solver. Does it mean "Goal Seak" in Excel 2003?
XL2003 does not have the "Subject to the Constraints": $C$1 = 1
Where is the "Subject to the Constraints"?
--
R. Khoshravan
Please click "Yes" if it is helpful.


"JE McGimpsey" wrote:

One way:

A1: 1
B1: 1
C1: =A1 + B1
D1: =3*A1 + 4*B1


Set Target Cell = D1
Equal to Value of 7
By changing cells: A1:B1
Subject to the Constraints: $C$1 = 1




In article ,
Mike wrote:

How to use Excel to solve for 2 unknown in linear equation, for eg,

x + Y = 1
3x + 4Y =7

Thanks
Mike


  #7   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,440
Default How to use solver to solve for 2 unknown in a linear equation?

Yes, it should show in the Tools menu

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Khoshravan" wrote in message
...
Thanks. After adding will it appear in Tools menu or elsewhere? I added
but
it didn't appear in tools menu.
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Niek Otten" wrote:

No, Goal Seek is not the same as Solver.
Solver is an add-in. It has to be activated: ToolsAdd-ins, check Solver

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Khoshravan" wrote in message
...
Solver. Does it mean "Goal Seak" in Excel 2003?
XL2003 does not have the "Subject to the Constraints": $C$1 = 1
Where is the "Subject to the Constraints"?
--
R. Khoshravan
Please click "Yes" if it is helpful.


"JE McGimpsey" wrote:

One way:

A1: 1
B1: 1
C1: =A1 + B1
D1: =3*A1 + 4*B1


Set Target Cell = D1
Equal to Value of 7
By changing cells: A1:B1
Subject to the Constraints: $C$1 = 1




In article ,
Mike wrote:

How to use Excel to solve for 2 unknown in linear equation, for eg,

x + Y = 1
3x + 4Y =7

Thanks
Mike



  #8   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 211
Default How to use solver to solve for 2 unknown in a linear equation?

I installed (Add) the solver and solved the set of 2 equations by the method
mentioned by JE McGimpsey. A very nice solution and I was unaware of
handling of set of eq. by excel.
In an extension to above question, is it possible to solve let say a set of
5 equations with 5 unknowns by the same method of JE McGimpsey ? What is the
limit of solver for handling such set of eq.
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Niek Otten" wrote:

Yes, it should show in the Tools menu

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Khoshravan" wrote in message
...
Thanks. After adding will it appear in Tools menu or elsewhere? I added
but
it didn't appear in tools menu.
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Niek Otten" wrote:

No, Goal Seek is not the same as Solver.
Solver is an add-in. It has to be activated: ToolsAdd-ins, check Solver

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Khoshravan" wrote in message
...
Solver. Does it mean "Goal Seak" in Excel 2003?
XL2003 does not have the "Subject to the Constraints": $C$1 = 1
Where is the "Subject to the Constraints"?
--
R. Khoshravan
Please click "Yes" if it is helpful.


"JE McGimpsey" wrote:

One way:

A1: 1
B1: 1
C1: =A1 + B1
D1: =3*A1 + 4*B1


Set Target Cell = D1
Equal to Value of 7
By changing cells: A1:B1
Subject to the Constraints: $C$1 = 1




In article ,
Mike wrote:

How to use Excel to solve for 2 unknown in linear equation, for eg,

x + Y = 1
3x + 4Y =7

Thanks
Mike




  #9   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4,624
Default How to use solver to solve for 2 unknown in a linear equation?

From XL Help ("Options in the Solver Add Constraint and Change
Constraint dialog boxes"):

For linear problems, there is no limit on the
number of constraints.


In article ,
Khoshravan wrote:

What is the
limit of solver for handling such set of eq.

  #10   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4,393
Default How to use solver to solve for 2 unknown in a linear equation?

Why not clear the target cell and use two constraints:
C1=1
D1=7
It really is the best way - I have a worksheet to demo this if interested
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"JE McGimpsey" wrote in message
...
One way:

A1: 1
B1: 1
C1: =A1 + B1
D1: =3*A1 + 4*B1


Set Target Cell = D1
Equal to Value of 7
By changing cells: A1:B1
Subject to the Constraints: $C$1 = 1




In article ,
Mike wrote:

How to use Excel to solve for 2 unknown in linear equation, for eg,

x + Y = 1
3x + 4Y =7

Thanks
Mike





  #11   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 211
Default How to use solver to solve for 2 unknown in a linear equation?

Thanks
--
R. Khoshravan
Please click "Yes" if it is helpful.


"JE McGimpsey" wrote:

From XL Help ("Options in the Solver Add Constraint and Change
Constraint dialog boxes"):

For linear problems, there is no limit on the
number of constraints.


In article ,
Khoshravan wrote:

What is the
limit of solver for handling such set of eq.


  #12   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default How to use solver to solve for 2 unknown in a linear equation?

Hi,
Attached is an example
"Khoshravan" wrote in message
...
Thanks
--
R. Khoshravan
Please click "Yes" if it is helpful.


"JE McGimpsey" wrote:

From XL Help ("Options in the Solver Add Constraint and Change
Constraint dialog boxes"):

For linear problems, there is no limit on the
number of constraints.


In article ,
Khoshravan wrote:

What is the
limit of solver for handling such set of eq.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
solve 2 linear equations on a graph Moik Charts and Charting in Excel 3 June 30th 08 12:33 PM
Two unknown variable equation John Excel Worksheet Functions 6 March 10th 06 08:51 PM
How do I could solve a equation Joe Satriani Excel Worksheet Functions 2 February 23rd 06 12:38 PM
How to solve problem (equal to 0) with unknown value nj125 Excel Discussion (Misc queries) 0 May 19th 05 03:31 AM
How can I solve for multiple unknown variables in Excel? Marion Excel Discussion (Misc queries) 1 March 6th 05 05:25 PM


All times are GMT +1. The time now is 03:43 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"