Difference between revisions of "Documentation/How Tos/Calc: MINVERSE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
m |
||
(9 intermediate revisions by 5 users not shown) | |||
Line 1: | Line 1: | ||
− | __NOTOC__ | + | {{DISPLAYTITLE:MINVERSE function}} |
+ | {{Documentation/CalcFunc ArraysTOC | ||
+ | |ShowPrevNext=block | ||
+ | |PrevPage=Documentation/How_Tos/Calc:_MDETERM_function | ||
+ | |NextPage=Documentation/How_Tos/Calc:_MMULT_function | ||
+ | }}__NOTOC__ | ||
== MINVERSE == | == MINVERSE == | ||
Line 8: | Line 13: | ||
: returns the inverse of the square matrix <tt>'''array'''</tt>, which may be either an inline array or a range, containing all numbers. | : returns the inverse of the square matrix <tt>'''array'''</tt>, which may be either an inline array or a range, containing all numbers. | ||
− | : <tt>'''MINVERSE'''</tt> returns an array, and must be entered as an array formula (for example by using | + | : <tt>'''MINVERSE'''</tt> returns an array, and must be entered as an array formula (for example by using {{key|Cntrl|Shift|Enter}} rather than just {{key|Enter}}). |
: A matrix has an inverse if and only if its determinant is not zero. | : A matrix has an inverse if and only if its determinant is not zero. | ||
Line 19: | Line 24: | ||
: when entered as an array formula in cell B3, where cells A1, B1, A2, B2 contain <tt>'''4'''</tt>, <tt>'''2'''</tt>, <tt>'''3'''</tt>, <tt>'''2'''</tt> respectively, returns <tt>'''1'''</tt>, <tt>'''-1'''</tt>, <tt>'''-1.5'''</tt>, <tt>'''2'''</tt> in cells B3, C3, B4, C4 respectively. | : when entered as an array formula in cell B3, where cells A1, B1, A2, B2 contain <tt>'''4'''</tt>, <tt>'''2'''</tt>, <tt>'''3'''</tt>, <tt>'''2'''</tt> respectively, returns <tt>'''1'''</tt>, <tt>'''-1'''</tt>, <tt>'''-1.5'''</tt>, <tt>'''2'''</tt> in cells B3, C3, B4, C4 respectively. | ||
− | {{ | + | {{SeeAlso|EN| |
− | + | * [[Documentation/How_Tos/Calc: MDETERM function|MDETERM]] | |
− | * [[Documentation/How_Tos/Calc: MDETERM function|MDETERM]] | + | * [[Documentation/How_Tos/Calc: MMULT function|MMULT]] |
− | * [[Documentation/How_Tos/Calc: MMULT function|MMULT]] | + | |
* [[Documentation/How_Tos/Calc: MUNIT function|MUNIT]] | * [[Documentation/How_Tos/Calc: MUNIT function|MUNIT]] | ||
Line 31: | Line 35: | ||
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||
+ | [[Category: Documentation/Reference/Calc/Array functions]] |
Latest revision as of 11:01, 30 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