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 idea of how could I do it?

Excel Desktop
Formulas & Functions

3 Replies

Sort By
  • 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