How do I multiply matrices in Excel?
|
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 ... |
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