MINVERSE Function

Summary

MINVERSE returns the inverse of a square matrix. In practice, that matters when you are solving matrix equations or checking whether one matrix really reverses another.

The output is another matrix, not a single value. In current versions of Excel, the result spills automatically into the needed range. In older versions, Microsoft says you need to select the output range first and confirm the formula with Ctrl+Shift+Enter.

MINVERSE is useful when a square matrix needs to be reversed for matrix-based solving and analysis. It is not a common casual worksheet function, but it becomes important in mathematical, engineering, and modeling tasks where matrix relationships are part of the problem structure.

Syntax

=MINVERSE(array)

The input must be a square numeric matrix. Microsoft notes that MINVERSE returns #VALUE! if the array is not square or contains empty cells or text, and #NUM! if the matrix cannot be inverted.

Arguments

• array - Required. A square numeric range or array constant.

MINVERSE vs Other Matrix Functions

MINVERSE is not a starting point by itself. It usually sits in the middle of a matrix workflow, after you test the matrix and before you multiply the result with something else.

Using MINVERSE

A good habit is to check the determinant first. If MDETERM returns 0, there is no inverse, so MINVERSE will return #NUM!. That quick check keeps the workbook easier to debug.

Another useful habit is verifying the result. Multiply the original matrix by its inverse with MMULT. If everything is correct, you should get an identity matrix, which is the same pattern that MUNIT creates. Because matrix math uses floating-point numbers, you may sometimes see tiny leftovers instead of clean zeros, so a light ROUND can help when you want the output to look cleaner.

Example 1 - Invert a 2x2 matrix

This is the easiest way to get used to the function. The source is 2x2, so the result also spills to 2x2.

This is a useful starting example because it makes the shape rule easy to see. The inverse has the same dimensions as the original matrix, so the output area matters right away.

=MINVERSE(B2:C3)

Example 2 - Invert a 3x3 matrix

As long as the matrix is square and invertible, the same formula works on a larger range.

This helps the learner see that the function pattern stays stable as the matrix grows. The important check is still whether the matrix is square and valid for inversion.

=MINVERSE(B2:D4)

Example 3 - Watch for output space

In modern Excel, MINVERSE spills into nearby cells. If something blocks that spill range, you can run into a spill error instead of getting the full result.

This is a practical example because the formula may be correct but still fail visually if the output area is not clear. Matrix functions often need enough empty space to return the full result.

=MINVERSE(B2:C3)

Example 4 - Check first, then invert

When you want a safer workflow, test the determinant before relying on the inverse.

This makes the example more than a separate formula. It shows the recommended workflow: test the matrix first, then run MINVERSE only when the matrix can actually be inverted.

=MDETERM(B2:C3)<>0

Conclusion Recap

MINVERSE is the function you use when you need Excel to return the inverse form of a square matrix. In this lesson, the main idea was that the result is another matrix, so you have to think about shape, output space, and whether the source matrix is actually invertible first.

The examples also showed a good beginner workflow: check the determinant, run MINVERSE, then verify the result with MMULT. That makes the process easier to trust and easier to debug when the matrix has no inverse or the spill area is blocked.

• Main job: MINVERSE returns the inverse of a square matrix.
• Shape rule: The input must be square and numeric.
• Common error: #NUM! means the matrix has no inverse.
• Good habit: Check MDETERM first when the source matrix might be singular.
• Best verification: Multiply the original matrix by the inverse and look for the identity matrix.