Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Can probably done using Solver. I'm more used to Goal seek, so I rework to one variable
I use cell A2 for x and B2 for y. Reworking 21x+6y=10: x = (10-6y)/21 So the formula in A2 is: =(10-6*B2)/21 In B2 I put 10 (no special reason) In A3 the second equation: =(7*A2-20)^2+(6*B2+10)^2 With A3 selected: ToolsGoal seek, To value: 200, By changing cell: $B$2 I get 0.857143 for x and -1.33333 for y -- Kind regards, Niek Otten Microsoft MVP - Excel "RL" wrote in message ... | 21x+ 6y = 10 | (7x-20)^2+(6y+10)^2=200 | | I only know that the solution are not integers. | | "ryguy7272" wrote: | | Can you provide an example of what you have now and what you want to have | eventually? | | Regards, | Ryan--- | | | -- | RyGuy | | | "RL" wrote: | | How do I calculate simultaneous equations? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Circular References - Simultaneous Equations | Excel Discussion (Misc queries) | |||
How do I do simultaneous AND and OR filtering ? | Excel Discussion (Misc queries) | |||
simultaneous subtotals | Excel Discussion (Misc queries) | |||
solving for 2 unknowns using 2 simultaneous equations | Excel Discussion (Misc queries) | |||
solving for 3 unknowns using 3 simultaneous equations | Excel Discussion (Misc queries) |