Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jomamma
 
Posts: n/a
Default How can I do a system of equations?

Such as 2 equations and 2 unknowns.
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

Here's one way. Assume your 2 equations a

2x + 2y = 8
x + 4y = 7

Place the coefficients of x in A1 and A2, coefficients of
y in B1 and B2, and the constants in C1 and C2. It should
look like this:

A B C
1 2 2 8
2 1 4 7

Select D1:D2, enter the formula below:

=MMULT(MINVERSE(A1:B2),C1:C2)

and press ctrl + shift + enter.

HTH
Jason
Atlanta, GA

-----Original Message-----
Such as 2 equations and 2 unknowns.
.

Reply
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
your help system is the worst of any software i've used.unable to. pinkie New Users to Excel 3 February 3rd 05 02:09 PM
Working with array equations OkieViking Excel Discussion (Misc queries) 2 January 23rd 05 08:43 AM
What is the "system date" in Excel? ceedeem Excel Worksheet Functions 1 December 21st 04 08:55 PM
System doesn't load Systray Dave Excel Discussion (Misc queries) 2 December 9th 04 04:10 AM
reward system? bjg Excel Worksheet Functions 1 November 25th 04 03:37 PM


All times are GMT +1. The time now is 01:00 PM.

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"