View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John
 
Posts: n/a
Default Two unknown variable equation

On Fri, 10 Mar 2006 14:08:59 -0500, "Dana DeLouis"
wrote:

3x + 2y = 16
5x - 3y = -5


I should have added. Another option is:

If you place 3,2,16 in A1:A3
and 5,-3,-5 in B1:B3
then select 2 vertical cells and array enter the following:

=MMULT(MINVERSE(A1:B2),C1:C2)

or select 2 horizontal cells and array enter the following:

=TRANSPOSE(MMULT(MINVERSE(A1:B2),C1:C2))


Thank you for both posts. I very much appreciate it.

One question though, I notice for both examples above the answer in
the cell was 2 while when I clicked on the formula it showed {2,5}. Is
there a way to show both.

Thanks again,
John