View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

That means your matrix is not invertable
Check it with MDETERM, if it returns zero
MINVERSE will return #NUM!

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"David D." wrote in message
...
In cells A1 to C3, I'm typing in:

1 4 7
2 5 8
3 6 9

I then select cells A5 to C7 and type
=MINVERSE(A1:C3) , then CTRL-SHIFT-ENTER

and I get
#NUM! #NUM! #NUM!
#NUM! #NUM! #NUM!
#NUM! #NUM! #NUM!

in cells A5 to C7
What am I doing wrong ? Any ideas ?
Thanks in advance.