inverse of a matrix

  • Thread starter Thread starter Charles Barbaz
  • Start date Start date
C

Charles Barbaz

I want to invert a matrix using Excel.
When I try to use the function, minverse, it returns a
single number (the first element of the inverted matrix)
and not the whole array which is the inverse of the
given matrix.

For a small matrix, say a 2x2, it returns a single number
but I can see the other elements in the drop down window.
For a 3x3 matrix, the function returns a single number,
but there is not enough space in the drop down window to
show the other elements of the array.
How do I get the function to return the complete array
of the inverted matrix to my spreadsheet?
 
I want to invert a matrix using Excel.
When I try to use the function, minverse, it returns a
single number (the first element of the inverted matrix)
and not the whole array which is the inverse of the
given matrix.
Click to expand...
...

If you want to see the full results from passing an NxN matrix to MINVERSE, you
must *first* select a range spanning N rows and N columns (e.g., for N=6,
A1:F6), then type in the formula, and hold down [Ctrl] and [Shift] keys before
pressing [Enter]. Online help is very poor for this aspect of MINVERSE's
functionality.
 
As is stated in the On-Line help for MINVERSE,

"Formulas that return arrays must be entered as array formulas."

I.e., enter it into the appropriately sized range with Ctrl+Shift+Enter
instead of just Enter.

Alan Beban
 
Charles,

MINVERSE in an array formula, so you need to enter it into an array of
cells. Select the range of cell in which the inverted matrix is to be
returned, type =MINVERSE(A1:C3) or whatever range, and press
Ctrl+Shift+Enter rather than just Enter. If you do this properly, Excel will
display each formula enclosed in curly braces {}.
 
Back
Top