ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I multiply matrices in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/16164-how-do-i-multiply-matrices-excel.html)

matrices in excel

How do I multiply matrices in Excel?
 


CLR

Pick a cell and put your "multiplier" in it, then select it and do Copy
and then highlight your matrix and do PasteSpecial and check the Multiply
button

Vaya con Dios,
Chuck, CABGx3


"matrices in excel" <matrices in wrote in
message ...




Bernard Liengme

Let's say you have a 3 by 3 in A1:C3 and another in D1:F3
Select a 3 by 3 range
Type =MMULT(A1:C3,D1:F3) and use CTRL+SHIFT+ENTER to complete the formula

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"matrices in excel" <matrices in wrote in
message ...





All times are GMT +1. The time now is 11:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com