MINVERSE(array)

Returns the inverse matrix of an array.

arrayThe 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 an array.
* 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.office.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!


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top