Your Problem: To Find Inverse Matrix using Excel
The Solution: Use MINVERSE function
The Result:
FOLLOW THE STEP-BY-STEP GUIDE
If you have a Matrix like this one:
Find the inverse !
1. Enter the matrix data into Excel cells
2. Highlight the result cells where you want to place the resulting matrix
3. Keep highlight it then enter this formula =MINVERSE(B3:D5)
4. After you finish with “)” don’t press Enter now! You should holding down CTRL key and SHIFT key simultaneously, then press ENTER. (If you don’t do this step, you will get some error message or the result will appear only in one cell)
5. The result:
