The MINVERSE() function can be tricky to use; the tutor tells how.

Example: find the inverse of matrix A:

Solution:

1. Enter the matrix in Excel or LibreOffice Calc. Let’s imagine, for this example, you use the 3×3 range a1:c3.
2. Select a cell to the right, away from the cells you’ve used. Drag across and down so that you’ve captured a 3×3 area.
3. Click into the formula box and type =minverse(a1:c3) but don’t press enter!
4. Hold down both Ctrl and Shift, then press Enter.

Hopefully you see the result

Source:

www.excelfunctions.net

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.