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?