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.

[@drmirwaisamiri6015]

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)

[@gregorybattis9588]

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.

[@MuckRatz]

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

[@mohdalif5842]

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

[@apm]

Select the entire region where the result should be and hit Ctrl-Shift-Enter

[@olisaiweanya7527]

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

[@apm]

The matrix may be singular, meaning that there is no solution. Try using a 10x10 matrix that has random numbers to verify that you have the appropriate solution method procedure.

[@olisaiweanya7527]

@@apm oh ok. Will try that.

[@olisaiweanya7527]

@@apm oh yh I think it w as singular. I will rearrange my matrix coefficients to see if I get a result.

[@UnstopableWords]

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

[@ILUTutorials]

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

[@marinstudios398]

Very useful! Thankyou for sharing. God bless you

[@danielbonilla5916]

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

[@apm]

Make sure the target cells are highlighted before hitting that key combination. Newer versions of Excel don’t need that combination.

[@hafizgaming113]

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

[@danielramdaia3302]

is this how to do matrix inversion by row operation on excel?

[@justin2icy]

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

[@apm]

They all intersect at the solution.

[@rashiagrawal178]

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

[@yashmehta4481]

If RHS is a zero vector, solution vector will also be zero vector.

[@Edward-2160-]

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

[@apm]

Nice work!

[@diaryyuyu]

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

[@mensgame-tn1750]

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

[@apm]

Try also typing the opening parenthesis.

[@mensgame-tn1750]

@@apm still the same problem , i only have in the functions menu : MATRICE.UNITAIRE :(

[@mensgame-tn1750]

@@apm I Don't know why but MMULT = PRODUITMAT and MINVERSE = INVERSEMAT and it works ! Thank you for your time

[@apm]

Is it a language issue? Is your computer language set to something other than English?

[@AyoLukeM]

THIS VIDEO SAVED ME

[@ShivamVerma-gq2sm]

Thankyou. This was very helpful !

[@batra04]

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

[@fisheatbrocoli3696]

Can i solve this using matlab?

[@apm]

Yes, here is the Matlab version of this material: apmonitor.com/che263/index.php/Main/MatlabSolveEquations The course has Excel, Matlab, and Python material.

[@fisheatbrocoli3696]

@@apm thank you

[@hannahsantos2914]

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?

[@apm]

Yes, that either means that the matrix inverse isn't possible (singular matrix) or else the dimensions aren't correct. Make sure you have the inverse of the matrix (19x19) that you solve first. Then you multiply the matrix inverse by the right hand side that should be 19x1. The result should also be 19x1 so make sure that many cells are selected before you hit CTRL+SHIFT+ENTER. Here is an online condition number calculator although I haven't tried it personally. calculator.vhex.net/calculator/linear-algebra/condition-number-of-a-matrix

[@hannahsantos2914]

THANK YOU SO MUCH FOR YOUR RESPONSE! :)

[@varcihoracio6294]

@@apm i had the same problem and its solved. thank you Sir!

[@syarifahmardhiah5103]

I'm doing 124 x 124 matrix and similar problem coming out. The link is unavailable currently. Is there any other solution for my problem?

[@omar-lb4rw]

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

[@joshjamesmoule]

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

[@apm]

Excel isn't the easiest tool for Matrix math either. Check out my other tutorials on Matlab and Python at apmonitor.com/che263

[@bellayunus6429]

THANK U SO MUCH !!

[@LucasAmonatiKhingKliemczak]

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

[@apm]

That seems like a tricky one because you don't necessarily have the keystroke combinations to select CTRL-SHIFT-ENTER. Maybe try a program other than Excel or else get a BlueTooth or USB keyboard that will connect to your smartphone.

[@sukirtee1863]

Thank you so much

[@nadyaalin6922]

Aaaa Thanks bgttttt 😍😍😍😍😍

[@kristineclairesurilla3565]

Wow

[@V1VAMORE3]

you're awesome! ty!

[@koashaygyi]

Thank you.

[@KmJahid-yc5hr]

thanks a lot Sir

[@alexeisaular3470]

Easy as pie 😎

[@guzmanmaciasjoseantonio5039]

tHANK U

[@isnaeiniadamkurniawan9674]

THANKS BROO

[@kristineforioquisel6261]

Can you help me

[@kristineforioquisel6261]

what's on the top of =minverse, i can't see it clearly

[@apm]

MMULT and MINVERSE are used together to find the solution. You may need to turn up your resolution.

[@laughtherapey]

I wasted two hours tryna fix this problem. WTF

[@apm]

Well, I hope this helped.