inverse of a matrix

[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?

 

[Harlan Grove]

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.

...

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.

 

[Alan Beban]

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

 

[Chip Pearson]

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 {}.

 

[Bernd Plumhoff]

The other answers were correct but if your matrix is too huge or Excel is
too slow for you, this site may be of help:
http://digilander.libero.it/foxes/SoftwareDownload.htm

Never needed nor tested this code, just stored the address (in case of

Kind regards,
Bernd