First note the empty range where we transpose the matrix. Since the product of matrices is given by multiplying elements of each row of the first matrix with the elements of each column of the second matrix it becomes mandatory to have a number of columns from the first matrix equal to the number of rows from the second matrix. How Excel Handles Matrix Math.
Use the MINVERSE function to return the inverse matrix of A.
Select a range of the same size as the matrix. Finish by pressing CTRL SHIFT ENTER. Excel can perform an array of basic math functions and the articles listed below will show you how to create the necessary formulas to add subtract multiply or divide numbers. Matrix operations are handled in two different fashions in Excel.