how array functions work mmult,minverse etc
vezerid wrote:
An array function must be entered in a group of cells. Let us say you
have a 2x3 matrix in A1:C2. Another 3x4 matrix in D1:G3. The result is
a 2x4 matrix. Decide where you want this matrix entered, say in A9:D11.
Select A9:D11
Type in the formula bar: =MMULT(A1:C2, D1:G3)
Press Shift+Ctrl+Enter
Excel will place the resulting matrix in these cells. From this point
on, A9:D11 is a formula array and you can not delete part of it, only
the entire array (when in an formula array, Ctrl+/ will select the
entire array).
To edit, select the entire range, click in the formula bar, edit and
Shift+Ctrl+Enter again.
MINVERSE will work in a similar manner. Select the destination and
enter =MINVERSE(range). In this case of course, range must be a square
matrix as should the input.
HTH
Kostis Vezerides
|