Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Equation to refer to data value(s) and not the cell?? | Excel Discussion (Misc queries) | |||
variable height variable width stacked bar charts | Charts and Charting in Excel | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
object variable or with block variable not set | Excel Discussion (Misc queries) | |||
Need Help with #N/A in equation | Excel Discussion (Misc queries) |