MMULt Worksheet Function

[TC8]

Can anybody help with the MMULT worksheet function please?

Excel's help function is not very helpful for this.

To take the 1st example in Excel's help on MMULT, the result is 2. I cannot figure out which way or by which method the columns and the rows are multiplied.

Any help is greatly appreciated.

Thank you.
Regards

[Bob Phillips]

No, it is not, the correct answer is a 2x2 array of 2,6;14,4

As help says, the result of MMULT is an NxM array, where N is the number of
rows in array1 and M is the number of columns in array2, and has to be
committed as an array formula, that is with Ctrl-Shift-Enter.

The only time you get a single array result is when N=1 and M=1.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"TC8" <[email protected]> wrote in message
news:[email protected]...
>
> Can anybody help with the MMULT worksheet function please?
>
> Excel's help function is not very helpful for this.
>
> To take the 1st example in Excel's help on MMULT, the result is 2. I
> cannot figure out which way or by which method the columns and the rows
> are multiplied.
>
> Any help is greatly appreciated.
>
> Thank you.
> Regards
>
>
> --
> TC8
> ------------------------------------------------------------------------
> TC8's Profile:
http://www.excelforum.com/member.php...o&userid=21176
> View this thread: http://www.excelforum.com/showthread...hreadid=536331
>

[Domenic]

In addition to Bob's contribution, you may want to take a look at the
following link, where it explains how the multiplication takes place...

http://www.purplemath.com/modules/mtrxmult.htm

Hope this helps!

In article <[email protected]>,
TC8 <[email protected]> wrote:

> Can anybody help with the MMULT worksheet function please?
>
> Excel's help function is not very helpful for this.
>
> To take the 1st example in Excel's help on MMULT, the result is 2. I
> cannot figure out which way or by which method the columns and the rows
> are multiplied.
>
> Any help is greatly appreciated.
>
> Thank you.
> Regards