Returns the inverse matrix for the matrix stored in an array.
تعمل هذه الدالة في Google Sheets كما تعمل في Excel تمامًا — بالصياغة والوسائط نفسها.
MINVERSE(array)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.
This error occurs if the matrix is singular (determinant is zero) or if the input range is not square.