Difference between revisions of "Documentation/How Tos/Calc: MINVERSE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
|||
Line 1: | Line 1: | ||
− | {{Documentation/ | + | {{Documentation/CalcFunc ArraysTOC |
− | | | + | |ShowPrevNext=block |
− | + | |PrevPage=Documentation/How_Tos/Calc:_MDETERM_function | |
− | + | |NextPage=Documentation/How_Tos/Calc:_MMULT_function | |
− | + | }}__NOTOC__ | |
− | + | ||
− | + | ||
− | + | ||
− | |PrevPage= Documentation/How_Tos/Calc:_MDETERM_function | + | |
− | | | + | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | }} | + | |
− | + | ||
== MINVERSE == | == MINVERSE == |
Revision as of 15:37, 29 January 2024
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.
See Also