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

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

Thanks
Mike

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.

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

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

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

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

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

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

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.

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

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.

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.