|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#1
February 17th, 2009, 03:43 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
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
February 17th, 2009, 04:43 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#3
February 17th, 2009, 05:10 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#4
February 17th, 2009, 10:04 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#5
February 17th, 2009, 10:44 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#6
February 17th, 2009, 11:09 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 news  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
February 17th, 2009, 03:27 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 news 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
February 17th, 2009, 05:37 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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.
|
|
#9
February 17th, 2009, 07:46 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#10
February 17th, 2009, 09:43 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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.
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
