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

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,851
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,109,456
Messages
5,528,871
Members
409,842
Latest member
mfernandezcean
Top