Formulas de Calc Español - Inglés
From Apache OpenOffice Wiki
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 | COS | COS |
73 | COSH | COSH |
74 | COT | COT |
75 | COTH | COTH |
76 | COVAR | COVAR |
77 | CRECIMIENTO | GROWTH |
78 | CSC | CSC |
79 | CSCH | CSCH |
80 | CUARTIL | QUARTILE |
81 | CUPON.DIAS | COUPDAYS |
82 | CUPON.DIAS.L1 | COUPDAYBS |
83 | CUPON.DIAS.L2 | COUPDAYSNC |
84 | CUPON.FECHA.L1 | COUPPCD |
85 | CUPON.FECHA.L2 | COUPNCD |
86 | CUPON.NUM | COUPNUM |
87 | CURTOSIS | KURT |
88 | DB | DB |
89 | DDB | DDB |
90 | DDE | DDE |
91 | DEC.A.BIN | DEC2BIN |
92 | DEC.A.HEX | DEC2EX |
93 | DEC.A.OCT | DEC2OCT |
94 | DECIMAL | DECIMAL |
95 | DELTA | DELTA |
96 | DERECHA | RIGHT |
97 | DERECHAB | RIGHTB |
98 | DESREF | OFFSET |
99 | DESVEST | STDEV |
100 | DESVESTA | STDEVA |
101 | DESVESTP | STDEVP |
102 | DESVESTPA | STDEVPA |
103 | DESVIA2 | DEVSQ |
104 | DESVPROM | AVEDEV |
105 | DIA | DAY |
106 | DIA.LAB | WORKDAY |
107 | DIAS | DAYS |
108 | 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 |
136 | DURACION.MODIF | MDURATION |
137 | DVS | VDB |
138 | ELEGIR | CHOOSE |
139 | ENCONTRAR | FIND |
140 | ERROR.TIPICO.XY | STEYX |
141 | ES.IMPAR | ISODD |
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 |
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 | FACTDOUBLE |
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 |
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 |
239 | M.C.M | LCM |
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 |
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 | OPERACION.MULTIPLE | MULTIPLE.OPERATIONS |
285 | PAGO | PMT |
286 | PAGO.INT.ENTRE | CUMIPMT |
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 |
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 |