how can I solve two equation with excel? example: x+y=1 4x-2y=5 x=? y=?
D Dana DeLouis Feb 3, 2007 #2 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)
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)
