Name

MINVERSE

Synopsis

You can use MINVERSE to find the inverse of a square matrix. Keep in mind that not all square matrices have inverses.

To Calculate

=MINVERSE(Array)
Array

This required argument must specify an array with equal rows and columns. The values in the array must all be numeric or the function returns an error.

Example

Figure 14-13 illustrates how MINVERSE is used to find the inverse of a matrix. The example also shows how to use MDETERM to find the determinant of a matrix and MMULT to determine the product of two matrices.

Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.