View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default 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=?