# MINVERSE Function – Find Matrix Inverse in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on November 6, 2023

This tutorial demonstrates how to use the MINVERSE Function in Excel to return the inverse matrix of a given array.

## MINVERSE Function

The MINVERSE Function returns the inverse of any array such that it has an equal number of rows and columns.

``=MINVERSE(A2:B3)``

Excel 2019 and Earlier: After entering the formula, instead of pressing ENTER, you must press CTRL + SHIFT + ENTER. This turns the formula into an array. You can identify arrays by the curly brackets surrounding the formula:

``{=MINVERSE(A2:B3)}``

Important: You can not manually type in the curly brackets, this will not work. You must use CTRL + SHIFT + ENTER

Excel 365: In newer versions, you no longer need to use CTRL + SHIFT + ENTER. You can simply press ENTER.

## MINVERSE Function – Non-Square Matrix

The MINVERSE Function will return an error if the array is not a square matrix.

``= MINVERSE(A2:B4)``

## MINVERSE Function – Text or Empty Cell

The MINVERSE Function will also return an error if any member of the array is either empty or contains some text.

``=MINVERSE(A2:B3)``