View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default 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