Math & Trig All versions ◉ 10 views

=MINVERSE()

The MINVERSE function returns the inverse matrix for a matrix stored in an array. Array can be given as a cell range, such as A1:C3; as an array constant, such as {1,2,3;4,5,6;7,8,9}; or as a name for either of these. Inverse matrices, like determinants, are generally used for solving systems of mathematical equations involving several variables. The product of a matrix and its inverse is the identity matrix — the square array in which the diagonal values equal 1, and all other values equal 0.

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016

=MINVERSE(array)

Hover argument names in the table for details.

Output typeNumber

Popularity25 / 100

VolatileNo

Dynamic ArrayNo

📥 Download sample .xlsx — Coming soon ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas

⬇ Download Sample Workbook

A dedicated .xlsx for =MINVERSE() with Persian sample data & live formulas — open in Excel and practice.

Sheet “Sample” — data table + formula in place
Sheet “Guide” — syntax, arguments & tips from this page
Instant & secure (token + rate limit)

📥 Download MINVERSE.xlsx — Coming soon ~ 8–12 KB · No macros

🧠 🧠 Quiz this function

%d questions — syntax, example & errors — test yourself!

Start quiz →

◧ Arguments

Argument	Type	Required	Description
`array`	Range	Required	A numeric array with an equal number of rows and columns.

▣ Examples

2×2 inverse matrix =MINVERSE({4,8;1,7})

✦ Tips

Array can be given as a cell range, such as A1:C3; as an array constant, such as {1,2,3;4,5,6;7,8,9}; or as a name for either of these.
Inverse matrices, like determinants, are generally used for solving systems of mathematical equations involving several variables. The product of a matrix and its inverse is the identity matrix — the square array in which the diagonal values equal 1, and all other values equal 0.
As an example of how a two-row, two-column matrix is calculated, suppose that the range A1:B2 contains the letters a, b, c, and d that represent any four numbers. The following table shows the inverse of the matrix A1:B2.
MINVERSE is calculated with an accuracy of approximately 16 digits, which may lead to a small numeric error when the cancellation is not complete.

⚠ Common Errors

#VALUE! If any cells in array are empty or contain text, MINVERSE returns a #VALUE! error. MINVERSE also returns a #VALUE! error if array does not have an equal number of rows and columns.

Fix: Use a square matrix with a non-zero determinant

#NUM! Some square matrices cannot be inverted and will return the #NUM! error value with MINVERSE.

Fix: بررسی کنید دترمینان ماتریس صفر نباشد؛ ماتریس دیگری انتخاب کنید یا وابستگی خطی سطرها/ستون‌ها را برطرف کنید.

💬 Comments & Q&A 0 approved

🔒 Your comment will be published after review.

Share your thoughts — visible after admin approval

No comments yet — be the first!

=MINVERSE() ☆