how can I solve two equation with excel?
One way is to select 2 vertical cells, and Array Enter:
=MMULT(MINVERSE({1,1;4,-2}),{1;5})
or as ranges:
=MMULT(MINVERSE(A1:B2),C1:C2)
--
HTH :)
Dana DeLouis
Windows XP & Office 2003
"peyman" wrote in message
...
how can I solve two equation with excel?
example:
x+y=1
4x-2y=5
x=?
y=?
|