how can I solve two equation with excel?
 

how can I solve two equation with excel?
example:
x+y=1
4x-2y=5
x=?
y=?

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