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