Investment Studio > Expressions > Functions > Matrix > MINVERSE
float array minverse(float array[n][n] argument)
Returns the inverse of the square argument array (if it exists).
Not all square matrices have an inverse. A necessary and sufficient condition for the existence of an inverse is a non-zero determinant (see mdeterm). If no inverse can be computed, the result is an error (#N/A).
Tip: while inversion of a coefficient matrix can be used to solve a system of equations, it is more computationally efficient to use the msolve function instead.
Examples
=minverse({{1, 2}, {3, 4}})
equals {{-2, 1}, {1.5, -0.5}}. You can verify that multiplying this result with the argument array yields the 2 x 2 unit matrix {{1, 0}, {0, 1}}.
=minverse({{1, 2, 3}, {4, 5, 6}, {7, 8, 9}})
yields #N/A since no inverse exists for this argument. You can use mdeterm to verify that its determinant = 0, implying a non-invertible matrix.