Forum Discussion

Rafa Yummy's avatar
Rafa Yummy
Copper Contributor
Jun 26, 2018

Fix matrixes

Hi, I have searched for this in internet but I haven't found anything interesting about fixing a matrix in a formula. I want to multiply two matrixes, one of them repeteadly, but I can't fix it. Any...
Excel Desktop
Formulas & Functions
Matt Mickle's avatar
Matt Mickle
Bronze Contributor
Jun 28, 2018

Hey Rafa-

 

Hope you're doing well.  Maybe try something like this:

 

Note: When entering the formula you need to highlight the 4 cells you expect the result to reside in then type in the formula and confirm with CTRL + SHIFT + ENTER.

 

In Example 2 highlight the 4 yellow cells and enter the formula then drag down...

 

 

Here are a few more links for reference:

 

https://spu.fem.uniag.sk/cvicenia/ksov/hanova/Econometrics%20I/matrices2.pdf

 

http://www.engineerexcel.com/matrix-multiplication-in-excel/

 

https://support.office.com/en-us/article/mmult-function-40593ed7-a3cd-4b6b-b9a3-e4ad3c7245eb

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jun 28, 2018

    And if not to display the result but use in another formula MMULT could be used, as

    MMULT(B5:C6,E5:F6)

    for Example 1

     

    • Rafa Yummy's avatar
      Rafa Yummy
      Copper Contributor
      Jun 28, 2018

      Thank you, but I fixed it by giving the matrix a name.

Resources