Difference between revisions of "OOoES/Traduccion/Calc: Funcion MINVERSA"
From Apache OpenOffice Wiki
< OOoES
m |
|||
Line 45: | Line 45: | ||
|} | |} | ||
+ | |||
+ | |||
+ | === Ejemplo: === | ||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | ! | ||
+ | ! A | ||
+ | ! B | ||
+ | |||
+ | |- | ||
+ | !1 | ||
+ | | 2 | ||
+ | | 4 | ||
+ | |||
+ | |- | ||
+ | !2 | ||
+ | | 5 | ||
+ | | -9 | ||
+ | |||
+ | |} | ||
+ | |||
+ | :Devuelve | ||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | ! | ||
+ | ! C | ||
+ | ! D | ||
+ | |||
+ | |- | ||
+ | !1 | ||
+ | | O.236842105 | ||
+ | | 0.105263158 | ||
+ | |||
+ | |- | ||
+ | !2 | ||
+ | | 0.131578947 | ||
+ | | -0.052631579 | ||
+ | |||
+ | |} | ||
+ | |||
+ | |||
[[Category:OldES]] | [[Category:OldES]] |
Latest revision as of 16:23, 8 December 2012
Contents
MINVERSA
Devuelve la inversa de una matriz.
Sintaxis:
MDETERM(Matriz)
- Donde Matriz es la matriz que será invertida.
Ejemplo:
A | B | |
---|---|---|
1 | 1 | 2 |
2 | 4 | 3 |
MINVERSA(A1:B2)
- Devuelve
A | B | |
---|---|---|
4 | -0.6 | 0.4 |
5 | 0.8 | -0.2 |
Ejemplo:
A | B | |
---|---|---|
1 | 2 | 4 |
2 | 5 | -9 |
- Devuelve
C | D | |
---|---|---|
1 | O.236842105 | 0.105263158 |
2 | 0.131578947 | -0.052631579 |