View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
Khoshravan Khoshravan is offline
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