inverse matrices
I have been looking at the example excel gives and I can not seem to get it
to work
They say and what I did is typed in the numbers
4 -1
2 0
Then I put in my aray =minverse(a2:b3) it comes up with 0
so that matches
then i select A5:b6 then I pressed f2 but when i do ctrl shift and enter
all together it does not do anything. That is where my problem is coming in.
thanks
chey
"James Silverton" wrote:
Hello, Chey!
You wrote on Tue, 30 Jan 2007 12:42:14 -0800:
C "David Biddulph" wrote:
?? Have you looked at the MINVERSE function?
?? --
?? David Biddulph
??
?? "Chey" wrote in message
?? ...
?? does anyone know how to do inverse matrices in excel
?? Mine is 36X36
?? I want to see the inverse of each number 36X36
It's an array calculation and you will have to select a suitable
size matrix to hold the inverse. I take it that it's not the
reciprocal of each element that you want.
James Silverton
Potomac, Maryland
E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not
|