# MINVERSE

MINVERSE(array)

Returns the inverse matrix of an array.

 array The array of numbers, with the same number of rows and columns.

 REMARKS
 * For an illustrated example refer to the Matrix Category page.* This function can return multiple values.* This function can create a Dynamic Array Formula.* The "array" can be a cell range, or an array constant, such as {1,2;3;4}.* If the array does not have an equal number of rows and columns, then #VALUE! is returned.* If any of the arguments are not numeric, then #VALUE is returned.* If any cells in array are empty or contain text, then #VALUE! is returned.* The product of a matrix and its inverse is the identity matrix, which is the square array in which the diagonal values are 1, and all other values are 0.* If the square matrix cannot be inverted, then #NUM! is returned.* The determinant for a non invertible matrix is 0.* This function is calculated with an accuracy of approximately 16 digits, which may lead to a small numeric error when the cancellation is not complete.* You can use the MDETERM function to return the matrix determinant of an array.* You can use the MMULT function to return the matrix product of two arrays.* You can use the TRANSPOSE function to returns an array with its orientation changed.* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

 A 1 =MINVERSE({3}) = 0.333 2 =MINVERSE({0.3333}) = 3 3 {=MINVERSE({4,2;1,3}) } = {0.3.-0.2;-0.1,0.4} 4 {=MINVERSE({4,2,3;1,3,4;2,4,6}) } = {0.3,0,-0.2;0.3,3,-2.2;-0.3,-2,1.7} 5 =MINVERSE({10, 20, 30, 40}) = #VALUE!