Multiplying Inverse Matrices
Posted by jeff on July 03, 2001 7:45 PM
I'm trying to multiply the inverse of a 3x3 matrix and a 3x1 matrix. I begin by highlighting an area for an output 3x1 matrix then I try to calculate using MMULT(MINVERSE("array1"),"array2"). My problem is that I am only getting output (which is the correct answer) in the first cell of my 3x1. What's happening to the output for the other two cells? Please help if you can. Thank you.
Jeff
Posted by Aladin Akyurek on July 03, 2001 9:29 PM
Jeff,
After you typed your formula in a cell, select 3 x1 cells, go to the formula bar, hit control+shift+enter at the same time.
Aladin
========
