Excel can calculate product of matrix?

%3CLINGO-SUB%20id%3D%22lingo-sub-1762430%22%20slang%3D%22en-US%22%3EExcel%20can%20calculate%20product%20of%20matrix%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1762430%22%20slang%3D%22en-US%22%3EHello%3CBR%20%2F%3EI%20was%20trying%20to%20find%20the%20product%20of%202%20matrix%20by%20using%20the%20function%20MMULT.%3CBR%20%2F%3EFor%20some%20reason%2C%20I'm%20supposed%20to%20get%20only%201s%20and%200s%3CBR%20%2F%3EBut%20I'm%20getting%20something%20else%20that's%20partially%20correct%20and%20I%20have%20no%20idea%20what%20the%20problem%20is%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1762430%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1762519%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20can%20calculate%20product%20of%20matrix%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1762519%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F825784%22%20target%3D%22_blank%22%3E%40Marethryu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20correct%2C%26nbsp%3B%3C%2FP%3E%3CP%3E1E-19%20means%20a%20number%20which%20is%20very%20small%2C%20a%200.0%20then%20a%2018%20zeros%20then%20a%201%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eselect%20your%20matrix%20format%20as%20number%20and%20you%20are%20good%20to%20go%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1762746%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20can%20calculate%20product%20of%20matrix%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1762746%22%20slang%3D%22en-US%22%3ECould%20you%20either%20share%20the%20workbook%20or%20the%20formula%20you%20have%20applied%20so%20far%2C%20help%20me%20to%20fix%20it!%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

@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

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

@Rajesh-S 

Formulas are here

image.png