Results 1 to 4 of 4
Thread: MMULT Function (2K & XP)

20060209, 09:47 #1
 Join Date
 Feb 2002
 Location
 Reading, Berkshire, England
 Posts
 199
 Thanks
 9
 Thanked 0 Times in 0 Posts
MMULT Function (2K & XP)
Say Array 1 & Array 2 = 4 cells each containing 4 numbers. Using the MMULT Function what do the values in the cells reflect. I am using Ctrl + Shift + Enter to enter the array, but I can't fathom out the results. <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

20060209, 10:10 #2
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
Re: MMULT Function (2K & XP)
It depends on how they are arranged and how you enter the formula.
MMULT multiplies Matrices (arrays) together. It is like several sumproducts done on each one. The HELP in XL gives the formula used. Here is an Explanation of Matrix Multiplication  From MathWorld
If you provided the 2 arrays and the MMULT you used we could describe it with those details.
The final product has the number of rows of the 1st array and the columns of the 2nd array. The columns of the first array must equal the rows of the 2nd array to be able to multiply.
Steve

20060209, 10:15 #3
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 30 Times in 30 Posts
Re: MMULT Function (2K & XP)
MMULT performs matrix (array) multiplication.
In the screenshot below, I2:K4 contains the array formula =MMULT(B2:C4,E2:G3)
Let's look at J2.
This is the cell in the first row and second column of I2:K4.
It is calculated by taking the first row of B2:C4 and the second column of E2:G3 and combining them as follows:
Multiply the corresponding elements and add the result.
In other words, multiply B2 with F2, and multiply C2 with F3, then add the products:
1 * 3 + 2 * 6 = 3 + 12 = 15
To be able to perform matrix multiplication, the number of columns in the first argument must be equal to the number of rows in the second argument, because the elements of these will be multiplied. the resulting matrix has as many rows as the first argument, and as many columns as the second argument.

20060209, 12:23 #4
 Join Date
 Feb 2002
 Location
 Reading, Berkshire, England
 Posts
 199
 Thanks
 9
 Thanked 0 Times in 0 Posts
Re: MMULT Function (2K & XP)
Many Thanks Hans & Steve. You have both made it easier to understand I will try & get my head round it <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>