Difference between revisions of "ES/Manuales/GuiaAOO/TemasAvanzados/Macros/StarBasic/Apendices/FormulasCalcEspanolIngles"
From Apache OpenOffice Wiki
Line 120: | Line 120: | ||
| DMIN | | DMIN | ||
|- | |- | ||
− | |29 | + | | 29 |
| BDPRODUCTO | | BDPRODUCTO | ||
| DPRODUCT | | DPRODUCT | ||
Line 141: | Line 141: | ||
|- | |- | ||
| 34 | | 34 | ||
− | |BESSELI | + | | BESSELI |
− | | | + | | BESSELI |
|- | |- | ||
− | |35 | + | | 35 |
| BESSELJ | | BESSELJ | ||
− | | | + | | BESSELJ |
|- | |- | ||
| 36 | | 36 | ||
| BESSELK | | BESSELK | ||
− | | | + | | BESSELK |
|- | |- | ||
| 37 | | 37 | ||
− | |BESSELY | + | | BESSELY |
− | | | + | | BESSELY |
|- | |- | ||
− | |38 | + | | 38 |
| BIN.A.DEC | | BIN.A.DEC | ||
− | | | + | | BIN2DEC |
|- | |- | ||
| 39 | | 39 | ||
| BIN.A.HEX | | BIN.A.HEX | ||
− | | | + | | BIN2HEX |
|- | |- | ||
| 40 | | 40 | ||
− | |BIN.A.OCT | + | | BIN.A.OCT |
− | | | + | | BIN2OCT |
|- | |- | ||
|41 | |41 | ||
Line 174: | Line 174: | ||
| 42 | | 42 | ||
| BUSCAR | | BUSCAR | ||
− | |LOOKUP | + | | LOOKUP |
|- | |- | ||
| 43 | | 43 | ||
Line 181: | Line 181: | ||
|- | |- | ||
| 44 | | 44 | ||
− | |BUSCARV | + | | BUSCARV |
| VLOOKUP | | VLOOKUP | ||
|- | |- | ||
| 45 | | 45 | ||
| CANTIDAD.RECIBIDA | | CANTIDAD.RECIBIDA | ||
− | | | + | | RECEIVED |
|- | |- | ||
| 46 | | 46 | ||
− | |CARACTER | + | | CARACTER |
| CHAR | | CHAR | ||
|- | |- | ||
Line 197: | Line 197: | ||
|- | |- | ||
| 48 | | 48 | ||
− | |CHISQDIST | + | | CHISQDIST |
| CHISQDIST | | CHISQDIST | ||
|- | |- | ||
| 49 | | 49 | ||
| CHISQINV | | CHISQINV | ||
− | |CHISQINV | + | | CHISQINV |
|- | |- | ||
| 50 | | 50 | ||
| COCIENTE | | COCIENTE | ||
− | | | + | | QUOTIENT |
|- | |- | ||
| 51 | | 51 | ||
− | |CODIGO | + | | CODIGO |
| CODE | | CODE | ||
|- | |- | ||
Line 228: | Line 228: | ||
| MATCH | | MATCH | ||
|- | |- | ||
− | |56 | + | | 56 |
| COLUMNA | | COLUMNA | ||
| COLUMN | | COLUMN | ||
Line 234: | Line 234: | ||
| 57 | | 57 | ||
| COLUMNAS | | COLUMNAS | ||
− | |COLUMNS | + | | COLUMNS |
|- | |- | ||
| 58 | | 58 | ||
| AMORTIZ.PROGRE | | AMORTIZ.PROGRE | ||
− | | | + | | AMORDEGRC |
|- | |- | ||
| 59 | | 59 | ||
− | |AMORTIZ.LIN | + | | AMORTIZ.LIN |
− | | | + | | AMORLINC |
|- | |- | ||
|60 | |60 | ||
| ALEATORIO.ENTRE | | ALEATORIO.ENTRE | ||
− | | | + | | RANDBETWEEN |
|- | |- | ||
| 61 | | 61 | ||
− | |COMBINAT | + | | COMBINAT |
| COMBIN | | COMBIN | ||
|- | |- | ||
Line 256: | Line 256: | ||
| COMBINA | | COMBINA | ||
|- | |- | ||
− | |63 | + | | 63 |
| COMPLEJO | | COMPLEJO | ||
− | | | + | | COMPLEX |
|- | |- | ||
| 64 | | 64 | ||
Line 265: | Line 265: | ||
|- | |- | ||
| 65 | | 65 | ||
− | |CONFIANZA | + | | CONFIANZA |
| CONFIDENCE | | CONFIDENCE | ||
|- | |- | ||
Line 272: | Line 272: | ||
| COUNT | | COUNT | ||
|- | |- | ||
− | |67 | + | | 67 |
| CONTAR.BLANCO | | CONTAR.BLANCO | ||
| COUNTBLANK | | COUNTBLANK | ||
Line 278: | Line 278: | ||
| 68 | | 68 | ||
| CONTAR.SI | | CONTAR.SI | ||
− | |COUNTIF | + | | COUNTIF |
|- | |- | ||
| 69 | | 69 | ||
Line 285: | Line 285: | ||
|- | |- | ||
| 70 | | 70 | ||
− | |CONTARA | + | | CONTARA |
| COUNTA | | COUNTA | ||
|- | |- | ||
Line 294: | Line 294: | ||
|72 | |72 | ||
| CONVERTIR_ADD | | CONVERTIR_ADD | ||
− | |com.sun.star.sheet.addin.Analysis.getConvert | + | | com.sun.star.sheet.addin.Analysis.getConvert |
|- | |- | ||
| 73 | | 73 | ||
− | |COS | + | | COS |
| COS | | COS | ||
|- | |- | ||
Line 305: | Line 305: | ||
|- | |- | ||
| 75 | | 75 | ||
− | |COT | + | | COT |
| COT | | COT | ||
|- | |- | ||
Line 313: | Line 313: | ||
|- | |- | ||
| 77 | | 77 | ||
− | |COVAR | + | | COVAR |
| COVAR | | COVAR | ||
|- | |- | ||
Line 320: | Line 320: | ||
| GROWTH | | GROWTH | ||
|- | |- | ||
− | |79 | + | | 79 |
| CSC | | CSC | ||
| CSC | | CSC | ||
Line 328: | Line 328: | ||
| CSCH | | CSCH | ||
|- | |- | ||
− | |81 | + | | 81 |
| CUARTIL | | CUARTIL | ||
| QUARTILE | | QUARTILE | ||
Line 334: | Line 334: | ||
| 82 | | 82 | ||
| CUPON.DIAS | | CUPON.DIAS | ||
− | | | + | | COUPDAYS |
|- | |- | ||
| 83 | | 83 | ||
− | |CUPON.DIAS.L1 | + | | CUPON.DIAS.L1 |
− | | | + | | COUPDAYBS |
|- | |- | ||
| 84 | | 84 | ||
| CUPON.DIAS.L2 | | CUPON.DIAS.L2 | ||
− | | | + | | COUPDAYSNC |
|- | |- | ||
| 85 | | 85 | ||
− | |CUPON.FECHA.L1 | + | | CUPON.FECHA.L1 |
− | | | + | | COUPPCD |
|- | |- | ||
| 86 | | 86 | ||
| CUPON.FECHA.L2 | | CUPON.FECHA.L2 | ||
− | | | + | | COUPNCD |
|- | |- | ||
| 87 | | 87 | ||
− | |CUPON.NUM | + | | CUPON.NUM |
− | | | + | | COUPNUM |
|- | |- | ||
|88 | |88 | ||
Line 373: | Line 373: | ||
|- | |- | ||
| 92 | | 92 | ||
− | |DEC.A.BIN | + | | DEC.A.BIN |
− | | | + | | DEC2BIN |
|- | |- | ||
|93 | |93 | ||
| DEC.A.HEX | | DEC.A.HEX | ||
− | | | + | | DEC2EX |
|- | |- | ||
| 94 | | 94 | ||
| DEC.A.OCT | | DEC.A.OCT | ||
− | | | + | | DEC2OCT |
|- | |- | ||
| 95 | | 95 | ||
− | |DECIMAL | + | | DECIMAL |
| DECIMAL | | DECIMAL | ||
|- | |- | ||
| 96 | | 96 | ||
| DELTA | | DELTA | ||
− | | | + | | DELTA |
|- | |- | ||
| 97 | | 97 | ||
− | |DERECHA | + | | DERECHA |
| RIGHT | | RIGHT | ||
|- | |- | ||
Line 400: | Line 400: | ||
| RIGHTB | | RIGHTB | ||
|- | |- | ||
− | |99 | + | | 99 |
| DESREF | | DESREF | ||
| OFFSET | | OFFSET | ||
Line 406: | Line 406: | ||
| 100 | | 100 | ||
| DESVEST | | DESVEST | ||
− | |STDEV | + | | STDEV |
|- | |- | ||
| 101 | | 101 | ||
Line 413: | Line 413: | ||
|- | |- | ||
| 102 | | 102 | ||
− | |DESVESTP | + | | DESVESTP |
| STDEVP | | STDEVP | ||
|- | |- | ||
Line 420: | Line 420: | ||
| STDEVPA | | STDEVPA | ||
|- | |- | ||
− | |104 | + | | 104 |
| DESVIA2 | | DESVIA2 | ||
| DEVSQ | | DEVSQ | ||
Line 426: | Line 426: | ||
| 105 | | 105 | ||
| DESVPROM | | DESVPROM | ||
− | |AVEDEV | + | | AVEDEV |
|- | |- | ||
| 106 | | 106 | ||
Line 434: | Line 434: | ||
| 107 | | 107 | ||
| DIA.LAB | | DIA.LAB | ||
− | | | + | | WORKDAY |
|- | |- | ||
| 108 | | 108 | ||
− | |DIAS | + | | DIAS |
| DAYS | | DAYS | ||
|- | |- | ||
| 109 | | 109 | ||
| DIAS.LAB | | DIAS.LAB | ||
− | | | + | | NETWORKDAYS |
|- | |- | ||
| 110 | | 110 | ||
− | |DIAS360 | + | | DIAS360 |
| DAYS360 | | DAYS360 | ||
|- | |- | ||
Line 458: | Line 458: | ||
| 113 | | 113 | ||
| DIASENMES | | DIASENMES | ||
− | |DAYSINMONTH | + | | DAYSINMONTH |
|- | |- | ||
| 114 | | 114 | ||
Line 464: | Line 464: | ||
| ADDRESS | | ADDRESS | ||
|- | |- | ||
− | |115 | + | | 115 |
| DIST.WEIBULL | | DIST.WEIBULL | ||
| WEIBULL | | WEIBULL | ||
Line 470: | Line 470: | ||
| 116 | | 116 | ||
| DISTR.BETA | | DISTR.BETA | ||
− | |BETADIST | + | | BETADIST |
|- | |- | ||
| 117 | | 117 | ||
Line 476: | Line 476: | ||
| BETAINV | | BETAINV | ||
|- | |- | ||
− | |118 | + | | 118 |
| DISTR.BINOM | | DISTR.BINOM | ||
| BINOMDIST | | BINOMDIST | ||
Line 482: | Line 482: | ||
| 119 | | 119 | ||
| DISTR.CHI | | DISTR.CHI | ||
− | |CHIDIST | + | | CHIDIST |
|- | |- | ||
| 120 | | 120 | ||
Line 489: | Line 489: | ||
|- | |- | ||
| 121 | | 121 | ||
− | |DISTR.F | + | | DISTR.F |
| FDIST | | FDIST | ||
|- | |- | ||
Line 496: | Line 496: | ||
| FINV | | FINV | ||
|- | |- | ||
− | |123 | + | | 123 |
| DISTR.GAMMA | | DISTR.GAMMA | ||
| GAMMADIST | | GAMMADIST | ||
|- | |- | ||
| 124 | | 124 | ||
− | |DISTR.GAMMA.INV | + | | DISTR.GAMMA.INV |
| GAMMAINV | | GAMMAINV | ||
|- | |- | ||
| 125 | | 125 | ||
| DISTR.HIPERGEOM | | DISTR.HIPERGEOM | ||
− | |HYPGEOMDIST | + | | HYPGEOMDIST |
|- | |- | ||
| 126 | | 126 | ||
Line 512: | Line 512: | ||
| LOGNORMDIST | | LOGNORMDIST | ||
|- | |- | ||
− | |127 | + | | 127 |
| DISTR.NORM | | DISTR.NORM | ||
| NORMDIST | | NORMDIST | ||
|- | |- | ||
| 128 | | 128 | ||
− | |DISTR.NORM.ESTAND | + | | DISTR.NORM.ESTAND |
| NORMSDIST | | NORMSDIST | ||
|- | |- | ||
| 129 | | 129 | ||
− | |DISTR.NORM.ESTAND.INV | + | | DISTR.NORM.ESTAND.INV |
| NORMSINV | | NORMSINV | ||
|- | |- | ||
| 130 | | 130 | ||
− | |DISTR.NORM.INV | + | | DISTR.NORM.INV |
| NORMINV | | NORMINV | ||
|- | |- | ||
| 131 | | 131 | ||
| DISTR.T | | DISTR.T | ||
− | |TDIST | + | | TDIST |
|- | |- | ||
| 132 | | 132 | ||
Line 537: | Line 537: | ||
|- | |- | ||
| 133 | | 133 | ||
− | |DOMINGOPASCUA | + | | DOMINGOPASCUA |
| EASTERSUNDAY | | EASTERSUNDAY | ||
|- | |- | ||
| 134 | | 134 | ||
| DURACION | | DURACION | ||
− | |DURATION | + | | DURATION |
|- | |- | ||
| 135 | | 135 | ||
| DURACION_ADD | | DURACION_ADD | ||
− | |com.sun.star.sheet.addin.Analysis.getDuration | + | | com.sun.star.sheet.addin.Analysis.getDuration |
|- | |- | ||
| 136 | | 136 | ||
− | |DURACION.MODIF | + | | DURACION.MODIF |
− | | | + | | MDURATION |
|- | |- | ||
| 137 | | 137 | ||
Line 558: | Line 558: | ||
| 138 | | 138 | ||
| ELEGIR | | ELEGIR | ||
− | |CHOOSE | + | | CHOOSE |
|- | |- | ||
| 139 | | 139 | ||
Line 565: | Line 565: | ||
|- | |- | ||
| 140 | | 140 | ||
− | |ERROR.TIPICO.XY | + | | ERROR.TIPICO.XY |
| STEYX | | STEYX | ||
|- | |- | ||
| 141 | | 141 | ||
| ES.IMPAR | | ES.IMPAR | ||
− | |ISODD | + | | ISODD |
|- | |- | ||
| 142 | | 142 | ||
| ES.IMPAR_ADD | | ES.IMPAR_ADD | ||
− | |com.sun.star.sheet.addin.Analysis.getIsodd | + | | com.sun.star.sheet.addin.Analysis.getIsodd |
|- | |- | ||
| 143 | | 143 | ||
− | |ES.PAR | + | | ES.PAR |
| ISEVEN | | ISEVEN | ||
|- | |- | ||
| 144 | | 144 | ||
| ESAÑOBISIESTO | | ESAÑOBISIESTO | ||
− | |ISLEAPYEAR | + | | ISLEAPYEAR |
|- | |- | ||
| 145 | | 145 | ||
Line 589: | Line 589: | ||
|- | |- | ||
| 146 | | 146 | ||
− | |ESERR | + | | ESERR |
| ISERR | | ISERR | ||
|- | |- | ||
Line 596: | Line 596: | ||
| ISERROR | | ISERROR | ||
|- | |- | ||
− | |148 | + | | 148 |
| ESFORMULA | | ESFORMULA | ||
| ISFORMULA | | ISFORMULA | ||
Line 602: | Line 602: | ||
| 149 | | 149 | ||
| ESLOGICO | | ESLOGICO | ||
− | |ISLOGICAL | + | | ISLOGICAL |
|- | |- | ||
| 150 | | 150 | ||
Line 609: | Line 609: | ||
|- | |- | ||
| 151 | | 151 | ||
− | |ESNOTEXTO | + | | ESNOTEXTO |
| ISNONTEXT | | ISNONTEXT | ||
|- | |- | ||
| 152 | | 152 | ||
| ESNUMERO | | ESNUMERO | ||
− | |ISNUMBER | + | | ISNUMBER |
|- | |- | ||
| 153 | | 153 | ||
| ESPAR_ADD | | ESPAR_ADD | ||
− | |com.sun.star.sheet.addin.Analysis.getIseven | + | | com.sun.star.sheet.addin.Analysis.getIseven |
|- | |- | ||
| 154 | | 154 | ||
− | |ESREF | + | | ESREF |
| ISREF | | ISREF | ||
|- | |- | ||
Line 628: | Line 628: | ||
| ISTEXT | | ISTEXT | ||
|- | |- | ||
− | |156 | + | | 156 |
| ESTILO | | ESTILO | ||
| STYLE | | STYLE | ||
Line 634: | Line 634: | ||
| 157 | | 157 | ||
| ESTIMACION.LINEAL | | ESTIMACION.LINEAL | ||
− | |LINEST | + | | LINEST |
|- | |- | ||
| 158 | | 158 | ||
Line 640: | Line 640: | ||
| LOGEST | | LOGEST | ||
|- | |- | ||
− | |159 | + | | 159 |
| EUROCONVERT | | EUROCONVERT | ||
| EUROCONVERT | | EUROCONVERT | ||
Line 646: | Line 646: | ||
| 160 | | 160 | ||
| EXP | | EXP | ||
− | |EXP | + | | EXP |
|- | |- | ||
| 161 | | 161 |
Revision as of 11:33, 19 April 2015
Nº | Español | Ingles |
---|---|---|
1 | ABS | ABS |
2 | ACOS | ACOS |
3 | ACOSH | ACOSH |
4 | ACOT | ACOT |
5 | ACOTH | ACOTH |
6 | ACTUAL | CURRENT |
7 | AHORA | NOW |
8 | ALEATORIO | RAND |
9 | AÑO | YEAR |
10 | AÑOS | YEARS |
11 | ARABE | ARABIC |
12 | AREAS | AREAS |
13 | ASC | ASC |
14 | ASENO | ASIN |
15 | ASENOH | ASINH |
16 | ATAN | ATAN |
17 | ATAN2 | ATAN2 |
18 | ATANH | ATANH |
19 | B | B |
20 | BAHTTEXT | BAHTTEXT |
21 | BASE | BASE |
22 | BDCONTAR | DCOUNT |
23 | BDCONTARA | DCOUNTA |
24 | BDDESVEST | DSTDEV |
25 | BDDESVESTP | DSTDEVP |
26 | BDEXTRAER | DGET |
27 | BDMAX | DMAX |
28 | BDMIN | DMIN |
29 | BDPRODUCTO | DPRODUCT |
30 | BDPROMEDIO | DAVERAGE |
31 | BDSUMA | DSUM |
32 | BDVAR | DVAR |
33 | BDVARP | DVARP |
34 | BESSELI | BESSELI |
35 | BESSELJ | BESSELJ |
36 | BESSELK | BESSELK |
37 | BESSELY | BESSELY |
38 | BIN.A.DEC | BIN2DEC |
39 | BIN.A.HEX | BIN2HEX |
40 | BIN.A.OCT | BIN2OCT |
41 | BINOM.CRIT | CRITBINOM |
42 | BUSCAR | LOOKUP |
43 | BUSCARH | HLOOKUP |
44 | BUSCARV | VLOOKUP |
45 | CANTIDAD.RECIBIDA | RECEIVED |
46 | CARACTER | CHAR |
47 | CELDA | CELL |
48 | CHISQDIST | CHISQDIST |
49 | CHISQINV | CHISQINV |
50 | COCIENTE | QUOTIENT |
51 | CODIGO | CODE |
52 | COEF.DE.CORREL | CORREL |
53 | COEFICIENTE.ASIMETRIA | SKEW |
54 | COEFICIENTE.R2 | RSQ |
55 | COINCIDIR | MATCH |
56 | COLUMNA | COLUMN |
57 | COLUMNAS | COLUMNS |
58 | AMORTIZ.PROGRE | AMORDEGRC |
59 | AMORTIZ.LIN | AMORLINC |
60 | ALEATORIO.ENTRE | RANDBETWEEN |
61 | COMBINAT | COMBIN |
62 | COMBINATA | COMBINA |
63 | COMPLEJO | COMPLEX |
64 | CONCATENAR | CONCATENATE |
65 | CONFIANZA | CONFIDENCE |
66 | CONTAR | COUNT |
67 | CONTAR.BLANCO | COUNTBLANK |
68 | CONTAR.SI | COUNTIF |
69 | CONTAR.SIS | COUNTIFS |
70 | CONTARA | COUNTA |
71 | CONVERTIR | CONVERT |
72 | CONVERTIR_ADD | com.sun.star.sheet.addin.Analysis.getConvert |
73 | COS | COS |
74 | COSH | COSH |
75 | COT | COT |
76 | COTH | COTH |
77 | COVAR | COVAR |
78 | CRECIMIENTO | GROWTH |
79 | CSC | CSC |
80 | CSCH | CSCH |
81 | CUARTIL | QUARTILE |
82 | CUPON.DIAS | COUPDAYS |
83 | CUPON.DIAS.L1 | COUPDAYBS |
84 | CUPON.DIAS.L2 | COUPDAYSNC |
85 | CUPON.FECHA.L1 | COUPPCD |
86 | CUPON.FECHA.L2 | COUPNCD |
87 | CUPON.NUM | COUPNUM |
88 | CURTOSIS | KURT |
89 | DB | DB |
90 | DDB | DDB |
91 | DDE | DDE |
92 | DEC.A.BIN | DEC2BIN |
93 | DEC.A.HEX | DEC2EX |
94 | DEC.A.OCT | DEC2OCT |
95 | DECIMAL | DECIMAL |
96 | DELTA | DELTA |
97 | DERECHA | RIGHT |
98 | DERECHAB | RIGHTB |
99 | DESREF | OFFSET |
100 | DESVEST | STDEV |
101 | DESVESTA | STDEVA |
102 | DESVESTP | STDEVP |
103 | DESVESTPA | STDEVPA |
104 | DESVIA2 | DEVSQ |
105 | DESVPROM | AVEDEV |
106 | DIA | DAY |
107 | DIA.LAB | WORKDAY |
108 | DIAS | DAYS |
109 | DIAS.LAB | NETWORKDAYS |
110 | DIAS360 | DAYS360 |
111 | DIASEM | WEEKDAY |
112 | DIASENAÑO | DAYSINYEAR |
113 | DIASENMES | DAYSINMONTH |
114 | DIRECCION | ADDRESS |
115 | DIST.WEIBULL | WEIBULL |
116 | DISTR.BETA | BETADIST |
117 | DISTR.BETA.INV | BETAINV |
118 | DISTR.BINOM | BINOMDIST |
119 | DISTR.CHI | CHIDIST |
120 | DISTR.EXP | EXPONDIST |
121 | DISTR.F | FDIST |
122 | DISTR.F.INV | FINV |
123 | DISTR.GAMMA | GAMMADIST |
124 | DISTR.GAMMA.INV | GAMMAINV |
125 | DISTR.HIPERGEOM | HYPGEOMDIST |
126 | DISTR.LOG.NORM | LOGNORMDIST |
127 | DISTR.NORM | NORMDIST |
128 | DISTR.NORM.ESTAND | NORMSDIST |
129 | DISTR.NORM.ESTAND.INV | NORMSINV |
130 | DISTR.NORM.INV | NORMINV |
131 | DISTR.T | TDIST |
132 | DISTR.T.INV | TINV |
133 | DOMINGOPASCUA | EASTERSUNDAY |
134 | DURACION | DURATION |
135 | DURACION_ADD | com.sun.star.sheet.addin.Analysis.getDuration |
136 | DURACION.MODIF | MDURATION |
137 | DVS | VDB |
138 | ELEGIR | CHOOSE |
139 | ENCONTRAR | FIND |
140 | ERROR.TIPICO.XY | STEYX |
141 | ES.IMPAR | ISODD |
142 | ES.IMPAR_ADD | com.sun.star.sheet.addin.Analysis.getIsodd |
143 | ES.PAR | ISEVEN |
144 | ESAÑOBISIESTO | ISLEAPYEAR |
145 | ESBLANCO | ISBLANK |
146 | ESERR | ISERR |
147 | ESERROR | ISERROR |
148 | ESFORMULA | ISFORMULA |
149 | ESLOGICO | ISLOGICAL |
150 | ESNOD | ISNA |
151 | ESNOTEXTO | ISNONTEXT |
152 | ESNUMERO | ISNUMBER |
153 | ESPAR_ADD | com.sun.star.sheet.addin.Analysis.getIseven |
154 | ESREF | ISREF |
155 | ESTEXTO | ISTEXT |
156 | ESTILO | STYLE |
157 | ESTIMACION.LINEAL | LINEST |
158 | ESTIMACION.LOGARITMICA | LOGEST |
159 | EUROCONVERT | EUROCONVERT |
160 | EXP | EXP |
161 | FACT | FACT |
162 | FACT.DOBLE | com.sun.star.sheet.addin.Analysis.getFactdouble |
163 | FALSO | FALSE |
164 | FECHA | DATE |
165 | FECHA.MES | com.sun.star.sheet.addin.Analysis.getEdate |
166 | FECHANUMERO | DATEVALUE |
167 | FIJO | FIXED |
168 | FILA | ROW |
169 | FILAS | ROWS |
170 | FIN.MES | com.sun.star.sheet.addin.Analysis.getEomonth |
171 | FISHER | FISHER |
172 | FORMULA | FORMULA |
173 | FRAC.AÑO | com.sun.star.sheet.addin.Analysis.getYearfrac |
174 | FRECUENCIA | FREQUENCY |
175 | FUN.ERROR | com.sun.star.sheet.addin.Analysis.getErf |
176 | FUN.ERROR.COMPL | com.sun.star.sheet.addin.Analysis.getErfc |
177 | GAMMA | GAMMA |
178 | GAMMA.LN | GAMMALN |
179 | GAUSS | GAUSS |
180 | GETPIVOTDATA | GETPIVOTDATA |
181 | GRADOS | DEGREES |
182 | HALLAR | SEARCH |
183 | HEX.A.BIN | com.sun.star.sheet.addin.Analysis.getHex2Bin |
184 | HEX.A.DEC | com.sun.star.sheet.addin.Analysis.getHex2Dec |
185 | HEX.A.OCT | com.sun.star.sheet.addin.Analysis.getHex2Oct |
186 | HIPERVINCULO | HYPERLINK |
187 | HOJA | SHEET |
188 | HOJAS | SHEETS |
189 | HORA | HOUR |
190 | HORANUMERO | TIMEVALUE |
191 | HOY | TODAY |
192 | IGUAL | EXACT |
193 | IM.ABS | com.sun.star.sheet.addin.Analysis.getImabs |
194 | IM.ANGULO | com.sun.star.sheet.addin.Analysis.getImargument |
195 | IM.CONJUGADA | com.sun.star.sheet.addin.Analysis.getImconjugate |
196 | IM.COS | com.sun.star.sheet.addin.Analysis.getImcos |
197 | IM.DIV | com.sun.star.sheet.addin.Analysis.getImdiv |
198 | IM.EXP | com.sun.star.sheet.addin.Analysis.getImexp |
199 | IM.LN | com.sun.star.sheet.addin.Analysis.getImln |
200 | IM.LOG10 | com.sun.star.sheet.addin.Analysis.getImlog10 |
201 | IM.LOG2 | com.sun.star.sheet.addin.Analysis.getImlog2 |
202 | IM.POT | com.sun.star.sheet.addin.Analysis.getImpower |
203 | IM.PRODUCT | com.sun.star.sheet.addin.Analysis.getImproduct |
204 | IM.RAIZ2 | com.sun.star.sheet.addin.Analysis.getImsqrt |
205 | IM.REAL | com.sun.star.sheet.addin.Analysis.getImreal |
206 | IM.SENO | com.sun.star.sheet.addin.Analysis.getImsin |
207 | IM.SUM | com.sun.star.sheet.addin.Analysis.getImsum |
208 | IM.SUSTR | com.sun.star.sheet.addin.Analysis.getImsub |
209 | IMAGINARIO | com.sun.star.sheet.addin.Analysis.getImaginary |
210 | INDICE | INDEX |
211 | INDIRECTO | INDIRECT |
212 | INFO | INFO |
213 | INT | INT |
214 | INT.ACUM | com.sun.star.sheet.addin.Analysis.getAccrint |
215 | INT.ACUM.V | com.sun.star.sheet.addin.Analysis.getAccrintm |
216 | INT.EFECTIVO | EFFECTIVE |
217 | INT.EFECTIVO_ADD | com.sun.star.sheet.addin.Analysis.getEffect |
218 | INT.PAGO.DIR | ISPMT |
219 | INT.RENDIMIENTO | RRI |
220 | INTERSECCION.EJE | INTERCEPT |
221 | INV.LOG | LOGINV |
222 | IZQUIERDA | LEFT |
223 | IZQUIERDAB | LEFTB |
224 | JERARQUIA | RANK |
225 | JIS | JIS |
226 | K.ESIMO.MAYOR | LARGE |
227 | K.ESIMO.MENOR | SMALL |
228 | LARGO | LEN |
229 | LARGOB | LENB |
230 | LETRA.DE.TES.EQV.A.BONO | com.sun.star.sheet.addin.Analysis.getTbilleq |
231 | LETRA.DE.TES.PRECIO | com.sun.star.sheet.addin.Analysis.getTbillprice |
232 | LETRA.DE.TES.RENDTO | com.sun.star.sheet.addin.Analysis.getTbillyield |
233 | LIMPIAR | CLEAN |
234 | LN | LN |
235 | LOG | LOG |
236 | LOG10 | LOG10 |
237 | M.C.D | GCD |
238 | M.C.D_ADD | com.sun.star.sheet.addin.Analysis.getGcd |
239 | M.C.M | LCM |
240 | M.C.M_ADD | com.sun.star.sheet.addin.Analysis.getLcm |
241 | MAX | MAX |
242 | MAXA | MAXA |
243 | MAYOR.O.IGUAL | com.sun.star.sheet.addin.Analysis.getGestep |
244 | MAYUSC | UPPER |
245 | MDETERM | MDETERM |
246 | MEDIA.ACOTADA | TRIMMEAN |
247 | MEDIA.ARMO | HARMEAN |
248 | MEDIA.GEOM | GEOMEAN |
249 | MEDIANA | MEDIAN |
250 | MES | MONTH |
251 | MESES | MONTHS |
252 | MID | MID |
253 | MIDB | MIDB |
254 | MIN | MIN |
255 | MINA | MINA |
256 | MINUSC | LOWER |
257 | MINUTO | MINUTE |
258 | MINVERSA | MINVERSE |
259 | MIRR | MIRR |
260 | MMULT | MMULT |
261 | MODA | MODE |
262 | MONEDA | DOLLAR |
263 | MONEDA.DEC | com.sun.star.sheet.addin.Analysis.getDollarde |
264 | MONEDA.FRAC | com.sun.star.sheet.addin.Analysis.getDollarfr |
265 | MULTINOMIAL | com.sun.star.sheet.addin.Analysis.getMultinomial |
266 | MULTIPLO.INFERIOR | FLOOR |
267 | MULTIPLO.SUPERIOR | CEILING |
268 | MULTIRANGO | MULTIRANGE |
269 | MUNITARIA | MUNIT |
270 | MVALOR | MVALUE |
271 | N | N |
272 | NEG | NEG |
273 | NEGBINOMDIST | NEGBINOMDIST |
274 | NO | NOT |
275 | NOD | NA |
276 | NOMPROPIO | PROPER |
277 | NORMALIZACION | STANDARDIZE |
278 | NPER | NPER |
279 | NUM.DE.SEMANA_ADD | com.sun.star.sheet.addin.Analysis.getWeeknum |
280 | O | OR |
281 | OCT.A.BIN | com.sun.star.sheet.addin.Analysis.getOct2Bin |
282 | OCT.A.DEC | com.sun.star.sheet.addin.Analysis.getOct2Dec |
283 | OCT.A.HEX | com.sun.star.sheet.addin.Analysis.getOct2Hex |
284 | OPERACIÓN.MÚLTIPLE | MULTIPLE.OPERATIONS |
285 | PAGO | PMT |
286 | PAGO.INT.ENTRE | CUMIPMT |
287 | PAGO.INT.ENTRE_ADD | com.sun.star.sheet.addin.Analysis.getCumipmt |
288 | PAGO.PRINC.ENTRE | CUMPRINC |
289 | PAGOINT | IPMT |
290 | PAGOPRIN | PPMT |
291 | PEARSON | PEARSON |
292 | PENDIENTE | SLOPE |
293 | PERCENTIL | PERCENTILE |
294 | PERMUTACIONES | PERMUT |
295 | PERMUTACIONESA | PERMUTATIONA |
296 | PHI | PHI |
297 | PI | PI |
298 | POISSON | POISSON |
POTENCIA | POWER | |
300 | PRECIO | com.sun.star.sheet.addin.Analysis.getPrice |
301 | PRECIO.DESCUENTO | com.sun.star.sheet.addin.Analysis.getPricedisc |
302 | PRECIO.PER.IRREGULAR.1 | com.sun.star.sheet.addin.Analysis.getOddfprice |
303 | PRECIO.PER.IRREGULAR.2 | com.sun.star.sheet.addin.Analysis.getOddlprice |
304 | PRECIO.VENCIMIENTO | com.sun.star.sheet.addin.Analysis.getPricemat |
305 | PROBABILIDAD | PROB |
306 | PRODUCTO | PRODUCT |
307 | PROMEDIO | AVERAGE |
308 | PROMEDIO.SI | AVERAGEIF |
309 | PROMEDIO.SIS | AVERAGEIFS |
310 | PROMEDIOA | AVERAGEA |
311 | PRONOSTICO | FORECAST |
312 | PRUEBA.CHI | CHITEST |
313 | PRUEBA.CHI.INV | CHIINV |
314 | PRUEBA.F | FTEST |
315 | PRUEBA.FISHER.INV | FISHERINV |
PRUEBA.T | TTEST | |
317 | PRUEBA.Z | ZTEST |
318 | RADIANES | RADIANS |
319 | RAIZ | SQRT |
320 | RAIZ2PI | com.sun.star.sheet.addin.Analysis.getSqrtpi |
321 | RANGO.PERCENTIL | PERCENTRANK |
322 | REDOND.MULT | com.sun.star.sheet.addin.Analysis.getMround |
323 | REDONDEA.IMPAR | ODD |
324 | REDONDEA.PAR | EVEN |
325 | REDONDEAR | ROUND |
326 | REDONDEAR.MAS | ROUNDUP |
327 | REDONDEAR.MENOS | ROUNDDOWN |
328 | REDUCIR | TRIM |
329 | REEMPLAZAR | REPLACE |
330 | RENDTO | com.sun.star.sheet.addin.Analysis.getYield |
331 | RENDTO.DESC | com.sun.star.sheet.addin.Analysis.getYielddisc |
332 | RENDTO.PER.IRREGULAR.1 | com.sun.star.sheet.addin.Analysis.getOddfyield |
333 | RENDTO.PER.IRREGULAR.2 | com.sun.star.sheet.addin.Analysis.getOddlyield |
334 | RENDTO.VENCTO | com.sun.star.sheet.addin.Analysis.getYieldmat |
335 | REPETIR | REPT |
336 | RESIDUO | MOD |
337 | ROMANO | ROMAN |
338 | ROT13 | ROT13 |
339 | SEC | SEC |
340 | SECH | SECH |
341 | SEGUNDO | SECOND |
342 | SEM.DEL.AÑO | WEEKNUM |
343 | SEMANAS | WEEKS |
344 | SEMANASENAÑO | WEEKSINYEAR |
345 | SENO | SIN |
346 | SENOH | SINH |
347 | SI | IF |
348 | SIGNO | SIGN |
349 | SLN | SLN |
350 | SUBTOTALES | SUBTOTAL |
351 | SUMA | SUM |
352 | SUMA.CUADRADOS | SUMSQ |
353 | SUMA.PRODUCTO | SUMPRODUCT |
354 | SUMA.SERIES | com.sun.star.sheet.addin.Analysis.getSeriessum |
355 | SUMAR.SI | SUMIF |
356 | SUMAR.SIS | SUMIFS |
357 | SUMAX2MASY2 | SUMX2PY2 |
358 | SUMAX2MENOSY2 | SUMX2MY2 |
359 | SUMAXMENOSY2 | SUMXMY2 |
360 | SUSTITUIR | SUBSTITUTE |
361 | SYD | SYD |
362 | T | T |
363 | TAN | TAN |
364 | TANH | TANH |
365 | TASA | RATE |
366 | TASA.DESC | com.sun.star.sheet.addin.Analysis.getDisc |
367 | TASA.INT | com.sun.star.sheet.addin.Analysis.getIntrate |
368 | TASA.NOMINAL | NOMINAL |
369 | TASA.NOMINAL_ADD | com.sun.star.sheet.addin.Analysis.getNominal |
370 | TENDENCIA | TREND |
371 | TEXTO | TEXT |
372 | TIEMPO | TIME |
373 | TIPO | TYPE |
374 | TIPO.DE.ERROR | ERRORTYPE |
375 | TIR | IRR |
376 | TIR.NO.PER | com.sun.star.sheet.addin.Analysis.getXirr |
377 | TRANSPONER | TRANSPOSE |
378 | TRUNCAR | TRUNC |
379 | UNICHAR | UNICHAR |
380 | UNICODE | UNICODE |
381 | VA | PV |
382 | VALOR | VALUE |
383 | VALOR.NÚMERO | NUMBERVALUE |
384 | VALORPRETENDIDO | GOALSEEK |
385 | VAR | VAR |
386 | VARA | VARA |
387 | VARP | VARP |
388 | VARPA | VARPA |
389 | VERDADERO | TRUE |
390 | VF | FV |
391 | VF.PLAN | com.sun.star.sheet.addin.Analysis.getFvschedule |
392 | VNA | NPV |
393 | VNA.NO.PER | com.sun.star.sheet.addin.Analysis.getXnpv |
394 | XO | XOR |
395 | Y | AND |
Si tienes dudas acerca de lo aquí explicado, tienes algún problema con AOO, o quieres ampliar la información, no dudes en dirigirte al Foro Oficial en español de Apache OpenOffice para Macros y API UNO |