### 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.

File available here: http://www.accessallinone.com/access-2010-no-vba-downloads/
Please select DbVideo31
An MS Access tutorial demonstrating how to make a login form.

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok

Wonderful invers very fast

thank you

Thanks dude

thank you,.. this save my time

this is saving me. thanks

thank you for this knowledge. Did not know excel is this advanced.

Nicely done and well explained.

The curly brackets are called Tit brackets

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?

thanks so much, best videos are the ones that make the point efficiently and in a short time.

AWESOME

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

Thank you so much, I'm doing a DIrect investigation for Year 12 and this saved me!

I just get num error

I am having some issues. Excel is not allowing me to paste the matrix properly, despite hitting control and shift.

very helpful

100%, you are correct. I missed that crucial combined key stroke 'cntrl+shift+enter'! Thanks for your quick reply, it now works. Good work. Guy P

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

Thank you thank you thank you thank you thank you.

help me a lot!!!!!!

Thank you for sharing. It helps to save a lot of trouble while studying my Mathematics

Thanks.

Thank you

@3:00 Got different numbers but overall great video!

Helps me a lot

Thanks!

wow! this concise and understandable.