Excel can calculate product of matrix?

Occasional Visitor
I was trying to find the product of 2 matrix by using the function MMULT.
For some reason, I'm supposed to get only 1s and 0s
But I'm getting something else that's partially correct and I have no idea what the problem is
3 Replies



It is correct, 

1E-19 means a number which is very small, a 0.0 then a 18 zeros then a 1 .


select your matrix format as number and you are good to go

Could you either share the workbook or the formula you have applied so far, help me to fix it!


Formulas are here