Using Excel to solve systems of equations.
- Thread starter sleuth
- Start date
sleuth
Livin' Like Thanksgivin'
Originally posted by migtig
Yes it can be done. Click on view and then formular bar. A toolbar pops up
click on the cell that needs to be formatted. then where the toolbar popped up there is a calculator emblem with = sign. In that window you need to type in the formula you need the data the document to calculate such as =A22 or =(A2+D2)*E2
Hmmmm... not sure if we're talking about the same time.
I'm familiar with using excel to do formulas and such.
What I'm looking for is how I might solve a set of equations, i.e. 6 equations with 6 unknowns, much like you might have used to do matrix math in your linear algebra courses? Or with Matlab or your graphics calculator.
Such as
<pre>
[25 22 13 [x [15
11 12 43 times y = 25
13 11 45] z] 35]
</pre>
<br>
where you would solve for X, Y, and Z.
Can this be done in Excel?
Last edited:
C
czygvtwkr
Guest
Yes it can, can do inverses, jacobians etc.
I have files at home that have the formulias built in, ill get them to you tonight.
I have files at home that have the formulias built in, ill get them to you tonight.
Thanks. 
C
czygvtwkr
Guest
Dude how do I get the file to you?
C
czygvtwkr
Guest
Did that work for you?
C
czygvtwkr
Guest
You can easily make one for a 6x6 using the same technique, less than 5 minutes to do it.