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?
|