You need to manipulate matrices in your calculations and would like to know what support Excel offers for dealing with matrices.
Excel has several builtin matrix functions for computing matrix inverses and determinants and for multiplying or transposing matrices.
Table 77 summarizes Excel's builtin matrix functions.
Table 77. Excel's builtin matrix functions
Function 
Syntax 
Description 



Returns the determinant of the matrix argument, which must be a square matrix. 


Returns the inverse of the matrix argument, which must be a square matrix. 


Returns the matrix product of the two matrix arguments. The resulting matrix has the same number of rows as the first argument and the same number of columns as the second. 


Returns the transpose of the matrix argument. 
MDETERM
returns a scalar, which means you enter the function as a normal function, by pressing Enter. The other three functions are array functions, which means you first have to select an appropriate number of cells, then type the function and press CtrlShiftEnter to enter the function.
Figure 73 shows how these functions can be used in a spreadsheet.
Figure 73. Matrix functions
To enter a matrix in ...
No credit card required