EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel MINVERSE in Excel
Secondary Sidebar
Excel Functions
  • Maths Function in Excel
    • Calculating Investment Return In Excel
    • Sumif Function Examples
    • MROUND in Excel
    • SUM Cells in Excel
    • MMULT in Excel
    • MINVERSE in Excel
    • Trunc in Excel
    • SUMIF with Text
    • COS Function in Excel
    • RANDBETWEEN in Excel
    • Excel SUMIF with OR
    • Excel DEGREES Function
    • Calculations in Excel
    • Sumif Between Two Dates
    • Calculate Income Tax in Excel
    • PRODUCT Function in Excel
    • How to Sum Multiple Rows in Excel
    • Matrix in Excel
    • ROUND Formula in Excel
    • How to SUM in Excel
    • SUMPRODUCT Formula in Excel
    • Excel Running Total
    • Excel Rounding
    • Excel Exponents
    • Excel SIN Function
    • Excel Square Root Function
    • Excel ROUNDUP Function
    • ROUND Excel Function
    • Excel ROUNDDOWN Function
    • ODD Excel Function
    • SUMPRODUCT Function in Excel
    • AGGREGATE Function in Excel
    • ABS Function in Excel
    • Excel TAN Function
    • COMBIN Function in Excel
    • CEILING Function in Excel
    • INT Excel Function
    • SUBTOTAL Function in Excel
    • LN Function in Excel
    • Excel RAND Function
    • TANH Function in Excel
    • SUMIF Function in Excel
    • SUM Function in Excel
    • POWER Function in Excel
    • EVEN Function in Excel
    • LOG Function in Excel
    • FLOOR Excel Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL ADVANCED Certification
  • Excel for HR Training

MINVERSE in Excel

By Madhuri ThakurMadhuri Thakur

MINVERSE in Excel 1

Excel MINVERSE (Table of Contents)

  • Definition of Inverse Matrix
  • Examples of MINVERSE in Excel

Definition of Excel MINVERSE

The reciprocal of any square matrix is called it is inverse. For a matrix to be invertible, there are two basic conditions to be satisfied:

  • The matrix for which we want to find the inverse needs to be a square matrix. Meaning it should have an equal number of rows and columns.
  • The determinant of the matrix should not be zero. If it is so, the matrix is said to be non-invertible.

Syntax:

Following is the syntax for the MINVERSE function in Excel, which can be used to compute the inverse of a matrix:

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

MINVERSE Syntax

Where,

  • array – This is a mandatory argument that specifies an array of values representing a matrix.

Examples of MINVERSE in Excel

Lets us discuss the MINVERSE in Excel with some examples.

You can download this MINVERSE Excel Template here – MINVERSE Excel Template

Example #1 – Computing Inverse of a 2X2 Matrix

A matrix with two rows and two columns is considered as a 2X2 matrix. Suppose we have a 2X2 matrix as shown below:

MINVERSE in Excel 1-1

Well, if you check, this matrix follows both of the conditions that are mandatory for a matrix to be invertible.

  • Since it has two rows and two columns, it is a square matrix
  • The determinant of a matrix can be computed as “ad-bc”. Here a=2, b=8, c=6 and d=9. Thus ad-bc results in (2*9)-(6*8) = 18-48 = 30 which is non-zero.

Hence, it is clear that the given matrix is invertible. We will store the inverse of this matrix in columns D, and E spread along with the cells D2:E3. See the screenshot below:

MINVERSE in Excel 1-2

Step 1: Select all the cells under the Inverse Matrix section from D2 to E3 as shown below:

MINVERSE in Excel 1-3

Step 2: In the active cell (cell D2), start typing =MINV, and you’ll see all the formulae associated with that keyword. Out of those, select the MINVERSE function by double-clicking on it so that you can find out the inverse of a given 2X2 matrix.

MINVERSE in Excel 1-4

Step 3: The mandatory argument which is needed for this function is an array. Use the original matrix cells containing values as an array for this one (i.e. A2:B3 in our case). Note that this is a mandatory argument for the MINVERSE function. See the screenshot below:

MINVERSE in Excel 1-5

Step 4: As discussed earlier, MINVERSE is compatible with arrays only. Thus, instead of pressing the Enter key, we need to press Ctrl + Shift + Enter button. A sequence of keys which converts the formula into an array formula. Once you hit the button, you can see the inverse of a given matrix in D2:E3 as shown below:

MINVERSE in Excel 1-6

Notice the curly braces within which the entire formula is enclosed. These are indications that the formula is working as an array formula over the given range.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,497 ratings)

Example #2 – Computing Inverse of a 4X4 Matrix

Let us now consider a 4X4 square matrix as shown below, for which we need to compute the inverse.

Inverse of a 4X4 Matrix 2-1

Incidentally, across cells F2 to I5, we will be storing the inverse of our original matrix. Follow the steps below to compute the inverse of the original matrix spread along with cells A2 to D5.

Step 1: Select all the cells for the Inverse matrix varying across F2 to I5 as shown in the screenshot below:

Inverse of a 4X4 Matrix 2-2

Here is an interesting task for you, the Original Matrix is invertible (which means it should satisfy both of the conditions). Could you check if the determinant of this matrix is non-zero? (It definitely is, but check with manual calculations on your own.

Step 2: Inactive cell, i.e. cell F2, initialize the formula for the inverse of a matrix by typing =MINVERSE(

Inverse of a 4X4 Matrix 2-3

Step 3: Use the Original Matrix cells spread across A2: D5 as a mandatory array argument to this formula. Since that is the matrix array for which we wanted to find out the inverse.

Inverse of a 4X4 Matrix 2-4

Step 4: Close the parentheses to complete the formula and Press Ctrl + Shift + Enter key to convert this formula into an array formula. Remember, this formula is developed in a way that is compatible with arrays only.

Inverse of a 4X4 Matrix 2-5

As soon as you Press the keyboard strokes, you’ll see an output as shown below under the Inverse Matrix section.

That is the Inverse matrix of our original matrix spread across A2: D5. Have a look at curly braces, which are an indication that the formula is converted into an array. This is how we can use Excel MINVERSE function to compute the inverse matrix of any square matrix which has a non-zero determinant. This article ends here; let’s wrap some points to be remembered:

Conclusion

  • MINVERSE function in Excel is categorized under the “Math and Trigonometry” section within Formulas.
  • This function helps us find out the inverse of a square matrix with a non-zero determinant value. Note that MINVERSE is an array function and is developed in a way that it can only be compatible with arrays.

Things to Remember

  • A matrix for which you are expecting to compute an inverse matrix needed to be square. Meaning, it should have equals number of rows and columns.
  • If the determinant of the original matrix is zero, you’ll get #NUM! error. Such a matrix is called a Singular Matrix.
  • If some extra cells are selected under the resulting matrix, which is not actually a part of the matrix, you’ll get the #N/A error.
  • The matrix should contain numeric values only. If there are any blank cell or text values under the given matrix, you’ll face #VALUE! error while computing an inverse of the same.
  • Array argument can also be provided as array constants such as {2, 3; 4, 5}. In which the rows and column arguments are separated by semicolon within the curly braces.

Recommended Articles

This is a guide to MINVERSE in Excel. Here we discuss How to use MINVERSE in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. TIME in Excel
  2. Confidence Interval in Excel
  3. Inverse Matrix in Excel
  4. Excel MIN Function
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel for HR Training (8 Courses, 10+ Projects)4.9
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download MINVERSE Excel Template

EDUCBA

Download MINVERSE Excel Template

EDUCBA

डाउनलोड MINVERSE Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more