mxinverse

Syntax:

Return Range  mxinverse(Range matrix1)

Description:

Computes the matrix inverse of matrix1 and places it at the current cell.

Examples:

($a4) = mxinverse($a1:$c3)
Before:
AB CD
1147
2258
33620
4
5
6
After:
AB CD
1147
2258
33620
4-1.575757575757581.151515151515150.0909090909090908
50.4848484848484850.0303030303030304-0.181818181818182
60.0909090909090909-0.1818181818181820.0909090909090909
($a2) = mxinverse($a1:$d4)