LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,440
Default How do I calculate simultaneous equations?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Circular References - Simultaneous Equations Andrew Excel Discussion (Misc queries) 8 November 4th 08 01:17 PM
How do I do simultaneous AND and OR filtering ? Motown Mick Excel Discussion (Misc queries) 3 August 21st 07 02:32 AM
simultaneous subtotals johnny vino Excel Discussion (Misc queries) 1 September 22nd 06 10:11 PM
solving for 2 unknowns using 2 simultaneous equations elaturnas Excel Discussion (Misc queries) 1 February 8th 05 07:29 PM
solving for 3 unknowns using 3 simultaneous equations elaturnas Excel Discussion (Misc queries) 0 February 8th 05 04:37 PM


All times are GMT +1. The time now is 12:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"