Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MMULt Worksheet Function
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MMULt Worksheet Function
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MMULt Worksheet Function
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 , TC8 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting Cell Number Format With A Worksheet Function | Excel Worksheet Functions | |||
Paste function is greyed out in the toolbar and I can't use ctl V - worksheet won't allow pasting | Excel Discussion (Misc queries) | |||
Is there a worksheet function that will... | Excel Worksheet Functions | |||
changing font style in a complex worksheet function | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) |