Excel can calculate product of matrix?

Copper Contributor
Hello
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

@Marethryu 

 

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!

@Rajesh_Sinha 

Formulas are here

image.png