Difference between revisions of "Documentation/How Tos/Calc: MINVERSE function"

Revision as of 08:02, 17 July 2018

MINVERSE

Returns the inverse of a matrix.

Syntax:

MINVERSE(array)

returns the inverse of the square matrix array, which may be either an inline array or a range, containing all numbers.

MINVERSE returns an array, and must be entered as an array formula (for example by using Cntrl-Shift-Enter rather than just Enter).

A matrix has an inverse if and only if its determinant is not zero.

Example:

=MINVERSE({4;2|3;2})

when entered as an array formula in cell B3, returns {1;-1|-1.5;2}, so that cells B3, C3, B4, C4 show 1, -1, -1.5, 2 respectively.

=MINVERSE(A1:B2)

when entered as an array formula in cell B3, where cells A1, B1, A2, B2 contain 4, 2, 3, 2 respectively, returns 1, -1, -1.5, 2 in cells B3, C3, B4, C4 respectively.

• MDETERM
• MMULT
• MUNIT

• How To Use Arrays in Calc

• Array functions

• Functions listed alphabetically
• Functions listed by category