I really need help

%3CLINGO-SUB%20id%3D%22lingo-sub-1856710%22%20slang%3D%22en-US%22%3EI%20really%20need%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1856710%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20I%20have%20a%20maths%20assignment%20that%20requires%20me%20to%20use%20matrices%20on%20excel%2C%20however%20when%20I%20am%20multiplying%20them%20using%20the%20mmult%20formula%20it%20only%20fills%20out%201%20single%20rectangle%20and%20not%20a%20whole%20new%20matrix%2C%20I%20have%20to%20do%20it%20manually%20for%20each%20row%20as%20it%20won't%20let%20me%20do%20the%20whole%20thing%20at%20once%2C%20I%20have%20to%20do%20a%20Leslie%20matrix%20of%20over%20150%20years%20and%20it%20will%20take%20too%20long.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1856710%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1856866%22%20slang%3D%22en-US%22%3ERe%3A%20I%20really%20need%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1856866%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F858621%22%20target%3D%22_blank%22%3E%40BikBoi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20a%20range%20of%20the%20appropriate%20size%20(same%20number%20of%20rows%20as%20the%20first%20matrix%2C%20same%20number%20of%20columns%20as%20the%20second%20matrix).%3C%2FP%3E%0A%3CP%3EEnter%20the%20MMULT%20formula%20and%20confirm%20it%20with%20%3CSTRONG%3ECtrl%2BShift%2BEnter%3C%2FSTRONG%3E%20to%20turn%20it%20into%20an%20array%20formula.%3C%2FP%3E%0A%3CP%3EIf%20you%20just%20press%20Enter%20or%20Tab%2C%20you'll%20just%20enter%20the%20formula%20in%20the%20active%20cell%2C%20and%20it%20won't%20be%20an%20array%20formula.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

So I have a maths assignment that requires me to use matrices on excel, however when I am multiplying them using the mmult formula it only fills out 1 single rectangle and not a whole new matrix, I have to do it manually for each row as it won't let me do the whole thing at once, I have to do a Leslie matrix of over 150 years and it will take too long. 

1 Reply

@BikBoi 

Select a range of the appropriate size (same number of rows as the first matrix, same number of columns as the second matrix).

Enter the MMULT formula and confirm it with Ctrl+Shift+Enter to turn it into an array formula.

If you just press Enter or Tab, you'll just enter the formula in the active cell, and it won't be an array formula.