Matrix Multiplication and Inverse in Excel

26
16




About this tutorial:

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.

26 COMMENTS

  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 

LEAVE A REPLY

Please enter your comment!
Please enter your name here