Discussion Re: Excel can calculate product of matrix? in Excel
https://techcommunity.microsoft.com/t5/excel/excel-can-calculate-product-of-matrix/m-p/1762746#M77343
Could you either share the workbook or the formula you have applied so far, help me to fix it!Fri, 09 Oct 2020 06:59:37 GMTRajesh-S2020-10-09T06:59:37ZExcel can calculate product of matrix?
https://techcommunity.microsoft.com/t5/excel/excel-can-calculate-product-of-matrix/m-p/1762430#M77330
Hello<BR />I was trying to find the product of 2 matrix by using the function MMULT.<BR />For some reason, I'm supposed to get only 1s and 0s<BR />But I'm getting something else that's partially correct and I have no idea what the problem isFri, 09 Oct 2020 05:08:40 GMThttps://techcommunity.microsoft.com/t5/excel/excel-can-calculate-product-of-matrix/m-p/1762430#M77330Marethryu2020-10-09T05:08:40ZRe: Excel can calculate product of matrix?
https://techcommunity.microsoft.com/t5/excel/excel-can-calculate-product-of-matrix/m-p/1762519#M77334
<P><LI-USER uid="825784"></LI-USER> </P><P> </P><P>It is correct, </P><P>1E-19 means a number which is very small, a 0.0 then a 18 zeros then a 1 .</P><P> </P><P>select your matrix format as number and you are good to go</P>Fri, 09 Oct 2020 06:04:56 GMThttps://techcommunity.microsoft.com/t5/excel/excel-can-calculate-product-of-matrix/m-p/1762519#M77334Ramiz_Assaf2020-10-09T06:04:56ZRe: Excel can calculate product of matrix?
https://techcommunity.microsoft.com/t5/excel/excel-can-calculate-product-of-matrix/m-p/1762746#M77343
Could you either share the workbook or the formula you have applied so far, help me to fix it!Fri, 09 Oct 2020 06:59:37 GMThttps://techcommunity.microsoft.com/t5/excel/excel-can-calculate-product-of-matrix/m-p/1762746#M77343Rajesh-S2020-10-09T06:59:37ZRe: Excel can calculate product of matrix?
https://techcommunity.microsoft.com/t5/excel/excel-can-calculate-product-of-matrix/m-p/1763893#M77386
<P><LI-USER uid="93699"></LI-USER> </P>
<P>Formulas are here</P>
<P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 351px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/225396iD546706F71144074/image-size/large?v=1.0&px=999" role="button" title="image.png" alt="image.png" /></span></P>Fri, 09 Oct 2020 12:44:10 GMThttps://techcommunity.microsoft.com/t5/excel/excel-can-calculate-product-of-matrix/m-p/1763893#M77386Sergei Baklan2020-10-09T12:44:10Z