Matrix Multiplication and Inverse in Excel

26
166

Video duration: 5:23
How to multiply matrices using MS Excel

Finding the inverse of a matrix using Excel

Using the mmult, mdeterm and minverse commands in excel.

1. hi, i have a question:

I want excel to do the follwoing:

i have a matrix an a result matrix. i want the multiplikator matrix.
so i do:

=MMULT(MINV(F3:H5);I3:I5)

But now i want excel to calculate as long as it has only positiv result.

example with inccorect numbers: 1,2,3;4,5,6;7,8,9 is my 3×3 matrix. the result matrix ist 12,13,14
the result for example could be -2,4,7

i dont want the -2. i need only positive results like 2,7,8.

Do you have an idea?

2. Thank you +Hifas Faiz , you just solved my MSc Aeronautical course work regarding longitudinal state-space modelling by helping me to calculate 4×4 matrix characteristics

3. I only get the first element A x B result 10 and on other values. I follow exactly as per video, highlight 3 x 3 range and mmult formula. I'm missing something – please help. Thanks Guy P