Manuals/calci/MINVERSE
MINVERSE(Array)
where,
Array - represents array having equal number of rows and columns.
It returns the inverse matrix having equal number of rows and columns based on given array.
If Array have different number of rows and column, MINVERSE returns the #ERROR.
MINVERSE
Lets see an example in (Column2, Row5)
=MINVERSE(R1C1:R2C2)
MINVERSE returns array[-1.5,1.25,0.5,-0.25].
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 1 | 5 | ||
| Row2 | 2 | 6 | ||
| Row3 | -1.5,1.25,0.5,-0.25 | |||
| Row4 | ||||
| Row5 | ||||
| Row6 |
