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

The key part is to select 2 vertical cells and

ARRAY ENTER

the formula. That means you commit the formula by pressing

Ctrl-Shift-Enter

"John" wrote:

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