Algebra in Excel
Is there a way to calculate algebraic equations in Excel?
I have the equation:
50a+100b=60 and
100a+50b=45
I know how to solve these by hand, but is there a way to solve them in
Excel?
First Equation
=============
Put the coefficient of 'a' in A1, the coefficient of 'b' in B1 and the
constant in C1
Second Equation
=============
Put the coefficient of 'a' in A2, the coefficient of 'b' in B3 and the
constant in C2
Solution for 'a'
=============
A4: =(B2*C1-B1*C2)/(A1*B2-A2*B1)
Solution for 'b'
=============
A5: =(C1-A4*A1)/B1
Notice the dependency in A5's calculation on the cell A4 (in case you decide
to move the solution cell for 'b' to some other location).
Rick
|