Matrix Math (MMULT, MINVERSE) in Microsoft Excel

Matrix multiplication (MMULT) and a matrix inverse (MINVERSE) are used to solve a set of 5 linear equations. Matrix operations in Excel are input as a range with a result calculated by using CTRL-SHIFT-ENTER.

[drmirwaisamiri]

Thank you so much. You can also nest the MINVERSE formula within the MMULT to get it done in one go. =MMULT(MINVERSE(array), array2)
Specifically for the cells in this sheet: =MMULT(MINVERSE(B2:F6), H2:H6)

[MuckRatz]

Thank you so much! i finaly the whole matrix thing clicked in my head. !!!

[gregorybattis]

For your last step you can drastically speed up the process using =sumproduct on a transposition of either the result or the input to double check. The formula is cleaner too.

[hafizgaming]

thanks! i really forgot the step for my IO analysis, luckily i watched yr video :)

[ILUTutorials]

Thanks, I have a Structural Analysis paper after half an hour and I am sure it is going to help me alot

[UnstopableWords]

And finally I have solved, I was trying since yesterday 😅 and now I have solved 7by7 matrix! Thanks!

[marinstudios]

Very useful! Thankyou for sharing. God bless you

[Edward--]

Thank you man ! I had to solve a 30×30 matrix !

[diaryyuyu]

when i don't know about the step for leontrif matrix, i feel luckily to find your video

[justinicy]

How would I be able to interpret where the intersection points are for these equations?

[joshjamesmoule]

really good video. was struggling with this until i saw this video!

[mohdalif]

sir, when i use minverse after i enter the value only at the first box only

[rashiagrawal]

Sir please help with this that if the RHS is the zero matrix then can the equations be solved in excel becoz i am unable to do so

[danielbonilla]

Why would the Ctrl + Shift + Enter not work? is there a workaround to this?

[LucasAmonatiKhingKliemczak]

Do you know how to calculate matrix inverse in a smartphone with excel?

[hannahsantos]

Hi, I am making 19x19 equations. And when i finally click the CTRL+SHIFT+ENTER command the cells will show up #VALUES!! that means error right?

[batra]

Thanks, this video can hellp me finish my work...👍

[olisaiweanya]

Doesn't work for my Trina do a 10 by 10 matrix but keeps showing number error.

[mensgame-tn]

Sir i have a problem, i have EXCEL 2019 and when i type =MMULT nothing shows up

[omar-lbrw]

Massage for arabic version:
اذا محمل النسخة العربية لا تنسى تحط الارقام من يمين الى يسار
مب نفس راعي المقطع..عكسه

وبالتوفيق❤