MINVERSE

Formulas / MINVERSE
Calculate the inverse matrix of an array.
MINVERSE(array)
  • array - required, numeric array with the same number of rows and columns
  • range of cells - OPTIONAL, can be given as a range of cells
  • array constant - OPTIONAL, can be an array constant
  • name - OPTIONAL, can be a name for either of the above

Examples

  • =MINVERSE(B7:C8)

    The MINVERSE function takes two arguments for its input: a matrix of numbers and the size of the matrix. This example takes a 2 x 2 matrix in B7:C8 as its input and returns the corresponding 2 x 2 matrix in E7:F8.

  • =MINVERSE(I7:K9)

    The MINVERSE function can also be used to find the inverse of a 3 x 3 matrix. For example, this takes a 3 x 3 matrix in I7:K9 as its input and returns the corresponding 3 x 3 matrix in B7:C8.

  • The MINVERSE function can also be used with multiple matrices. For example, if you have two 2 x 2 matrices in B7:C8 and E7:F8, you can use the MINVERSE function to calculate the inverse of both matrices. The result would be two 2 x 2 matrices, one in B7:C8 and one in E7:F8.

Summary

The MINVERSE function calculates the inverse matrix of a given array of numbers. It requires the input array to be a square matrix with the same number of rows and columns and returns an inverse matrix of the same dimensions.

  • The MINVERSE function takes a square matrix as input and returns its inverse matrix.
  • The input matrix must contain only numbers and have the same number of rows and columns.
  • The output matrix will also have the same number of rows and columns as the input matrix.


Frequently Asked Questions

What is the MINVERSE function?
The MINVERSE function calculates the inverse matrix of a matrix stored in an array.
What happens if the array does not have an equal number of rows and columns?
The MINVERSE function will return an error if the array does not have an equal number of rows and columns.
What happens if the array contains text?
The MINVERSE function will return an error if the array contains text.
What is the MINVERSE function used for?
The MINVERSE function is useful for solving systems of equations.
What is the accuracy of the MINVERSE function?
The MINVERSE function is accurate to approximately 16 digits.
Are there any potential issues with the MINVERSE function?
The MINVERSE function may return a small numeric error if the cancellation is not complete.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.