View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default How do I calculate simultaneous equations?

RL, this may be of some interest to you:
http://en.wikipedia.org/wiki/Quadratic_equation



--
RyGuy


"Niek Otten" wrote:

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?