Difference between revisions of "OOoES/Traduccion/Calc: Funcion TRANSPONER"
From Apache OpenOffice Wiki
< OOoES
m |
(→TRANSPONER) |
||
Line 45: | Line 45: | ||
|} | |} | ||
+ | |||
+ | '''Ejemplo: =TRANSPONER()''' | ||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | ! | ||
+ | ! A | ||
+ | ! B | ||
+ | |||
+ | |- | ||
+ | !1 | ||
+ | |12 | ||
+ | |121 | ||
+ | |||
+ | |- | ||
+ | !2 | ||
+ | |13 | ||
+ | |14 | ||
+ | |||
+ | |- | ||
+ | !3 | ||
+ | |114 | ||
+ | |15 | ||
+ | |||
+ | |- | ||
+ | !4 | ||
+ | | 115 | ||
+ | |16 | ||
+ | |} | ||
+ | |||
+ | |||
+ | Devuelve: | ||
+ | |||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | ! | ||
+ | ! E | ||
+ | ! F | ||
+ | ! G | ||
+ | ! H | ||
+ | |||
+ | |- | ||
+ | !1 | ||
+ | |12 | ||
+ | |13 | ||
+ | |114 | ||
+ | |115 | ||
+ | |||
+ | |- | ||
+ | !2 | ||
+ | |121 | ||
+ | |14 | ||
+ | |15 | ||
+ | |16 | ||
+ | |||
+ | |} | ||
+ | |||
[[Category:OldES]] | [[Category:OldES]] |
Revision as of 17:15, 7 December 2012
TRANSPONER
Transposición de la matriz. Intercambia las filas y columnas de una matriz.
Sintaxis:
TRANSPONER(Matriz)
- Donde Matriz es la que cuyas filas y columnas desea transponer.
Ejemplo:
A | B | |
---|---|---|
1 | 1 | 2 |
2 | 4 | 3 |
TRANSPONER(A1:B2)
- Devuelve
C | D | |
---|---|---|
21 | 1 | 4 |
22 | 2 | 3 |
Ejemplo: =TRANSPONER()
A | B | |
---|---|---|
1 | 12 | 121 |
2 | 13 | 14 |
3 | 114 | 15 |
4 | 115 | 16 |
Devuelve:
E | F | G | H | |
---|---|---|---|---|
1 | 12 | 13 | 114 | 115 |
2 | 121 | 14 | 15 | 16 |