Help on Mmult

Chi

New Member
Joined
Sep 30, 2006
Messages
4
Hello,

How can I multiply the following 2 matrices using mmult? I tried, but excel returns #value!

0.1 0.1 0.1 0.1

2.00 5.00 7.00 9.00
5.00 6.00 8.00 9.00
2.00 8.00 4.00 1.00
4.00 5.00 1.00 8.00
4.00 8.00 9.00 1.00

Thanks for any help!!
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,870
Hi Chi
Welcome to the board

That is not a valid operation. As you may recall from algebra, you can only multiply 2 matrixes if the number of columns of the first is equal to the number of rows of the second.

The first matrix has 4 columns and the second 5 rows.

Hope this helps
PGC
 

Watch MrExcel Video

Forum statistics

Threads
1,114,188
Messages
5,546,463
Members
410,741
Latest member
Count25
Top