View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
PBezucha PBezucha is offline
external usenet poster
 
Posts: 120
Default Algebra in Excel

Why not to exploit useful math features of Excel?
Generally (it applies for arbitraly count of linear equations) and comfy:

arrange your set of coefficients as follows

50 100
100 50

60 100
45 50

50 60
100 45

e.g. in the second and third arrays replace the first and second column with
the coefficients from the right side. Apply Excel function MDeterm for each
of these arrays (called square matrix) as arguments. And now simply divide
the second (-1500) and third (-3750) results of this function by the first
one (-7500) whereby you obtain your values for a (0.2) and b (0.5).

Regards
Petr

"sstexas" wrote:

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?