Returns the inverse matrix for the matrix stored in an array.
구문
MINVERSE(array)인수
array필수
A numeric array or range of cells with an equal number of rows and columns.
The MINVERSE function calculates the inverse of a square matrix. It requires the input array to contain an equal number of rows and columns, and the determinant of the matrix must not be zero.
=MINVERSE({4,-2;1,0})→{0,1;-0.5,2}Calculates the inverse of a 2x2 matrix.
Select the output range
Select a range of cells with the same dimensions as the input matrix.
Enter the formula
Type =MINVERSE(array) and press Ctrl+Shift+Enter for array formula support in older Excel versions.
This error occurs if the matrix is singular (determinant is zero) or if the input range is not square.