Formulas de Calc Español - Inglés
From Apache OpenOffice Wiki
Nº | Español | Ingles |
---|---|---|
1 | 360DIAS | DAYS360 |
2 | ABS | ABS |
3 | ACOS | ACOS |
4 | ACOSH | ACOSH |
5 | ACOT | ACOT |
6 | ACOTH | ACOTH |
7 | ACTUAL | CURRENT |
8 | AHORA | NOW |
9 | ALEATORIO | RAND |
10 | ALEATORIO.ENTRE | com.sun.star.sheet.addin.Analysis.getRandbetween |
11 | AMORTIZ.LIN | com.sun.star.sheet.addin.Analysis.getAmorlinc |
12 | AMORTIZ.PROGRE | com.sun.star.sheet.addin.Analysis.getAmordegrc |
13 | AÑO | YEAR |
14 | AÑOS | com.sun.star.sheet.addin.DateFunctions.getDiffYears |
15 | ÁRABE | ARABIC |
16 | ÁREAS | AREAS |
17 | ASC | ASC |
18 | ASENO | ASIN |
19 | ASENOH | ASINH |
20 | ATAN | ATAN |
21 | ATAN2 | ATAN2 |
22 | ATANH | ATANH |
23 | B | B |
24 | BAHTTEXT | BAHTTEXT |
25 | BASE | BASE |
26 | BDCONTAR | DCOUNT |
27 | BDCONTARA | DCOUNTA |
28 | BDDESVEST | DSTDEV |
29 | BDDESVESTP | DSTDEVP |
30 | BDEXTRAER | DGET |
31 | BDMÁX | DMAX |
32 | BDMÍN | DMIN |
33 | BDPRODUCTO | DPRODUCT |
34 | BDPROMEDIO | DAVERAGE |
35 | BDSUMA | DSUM |
36 | BDVAR | DVAR |
37 | BDVARP | DVARP |
38 | BESSELI | com.sun.star.sheet.addin.Analysis.getBesseli |
39 | BESSELJ | com.sun.star.sheet.addin.Analysis.getBesselj |
40 | BESSELK | com.sun.star.sheet.addin.Analysis.getBesselk |
41 | BESSELY | com.sun.star.sheet.addin.Analysis.getBessely |
42 | BIN.A.DEC | com.sun.star.sheet.addin.Analysis.getBin2Dec |
43 | BIN.A.HEX | com.sun.star.sheet.addin.Analysis.getBin2Hex |
44 | BIN.A.OCT | com.sun.star.sheet.addin.Analysis.getBin2Oct |
45 | BINOM.CRIT | CRITBINOM |
46 | BUSCAR | LOOKUP |
47 | BUSCARH | HLOOKUP |
48 | BUSCARV | VLOOKUP |
49 | CANTIDAD.RECIBIDA | com.sun.star.sheet.addin.Analysis.getReceived |
50 | CARÁCTER | CHAR |
51 | CELDA | CELL |
52 | CHISQDIST | CHISQDIST |
53 | CHISQINV | CHISQINV |
54 | COCIENTE | com.sun.star.sheet.addin.Analysis.getQuotient |
55 | CÓDIGO | CODE |
56 | COEF.DE.CORREL | CORREL |
57 | COEFICIENTE.ASIMETRIA | SKEW |
58 | COEFICIENTE.R2 | RSQ |
59 | COINCIDIR | MATCH |
60 | COLUMNA | COLUMN |
61 | COLUMNAS | COLUMNS |
62 | COMBINAT | COMBIN |
63 | COMBINATA | COMBINA |
64 | COMPLEJO | com.sun.star.sheet.addin.Analysis.getComplex |
65 | CONCATENAR | CONCATENATE |
66 | CONFIANZA | CONFIDENCE |
67 | CONTAR | COUNT |
68 | CONTAR.BLANCO | COUNTBLANK |
69 | CONTAR.SI | COUNTIF |
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 | CUARTIL | QUARTILE |
80 | CUPON.DIAS | com.sun.star.sheet.addin.Analysis.getCoupdays |
81 | CUPON.DIAS.L1 | com.sun.star.sheet.addin.Analysis.getCoupdaybs |
82 | CUPON.DIAS.L2 | com.sun.star.sheet.addin.Analysis.getCoupdaysnc |
83 | CUPON.FECHA.L1 | com.sun.star.sheet.addin.Analysis.getCouppcd |
84 | CUPON.FECHA.L2 | com.sun.star.sheet.addin.Analysis.getCoupncd |
85 | CUPON.NUM | com.sun.star.sheet.addin.Analysis.getCoupnum |
86 | CURTOSIS | KURT |
87 | DB | DB |
88 | DDB | DDB |
89 | DDE | DDE |
90 | DEC.A.BIN | com.sun.star.sheet.addin.Analysis.getDec2Bin |
91 | DEC.A.HEX | com.sun.star.sheet.addin.Analysis.getDec2Hex |
92 | DEC.A.OCT | com.sun.star.sheet.addin.Analysis.getDec2Oct |
93 | DECIMAL | DECIMAL |
94 | DELTA | com.sun.star.sheet.addin.Analysis.getDelta |
95 | DERECHA | RIGHT |
96 | DESREF | OFFSET |
97 | DESVEST | STDEV |
98 | DESVESTA | STDEVA |
99 | DESVESTP | STDEVP |
100 | DESVESTPA | STDEVPA |
101 | DESVIA2 | DEVSQ |
102 | DESVPROM | AVEDEV |
103 | DÍA | DAY |
104 | DIA.LAB | com.sun.star.sheet.addin.Analysis.getWorkday |
105 | DIAS | DAYS |
106 | DIAS.LAB | com.sun.star.sheet.addin.Analysis.getNetworkdays |
107 | DÍASEM | WEEKDAY |
108 | DÍASENAÑO | com.sun.star.sheet.addin.DateFunctions.getDaysInYear |
109 | DÍASENMES | com.sun.star.sheet.addin.DateFunctions.getDaysInMonth |
110 | DIRECCIÓN | ADDRESS |
111 | DIST.WEIBULL | WEIBULL |
112 | DISTR.BETA | BETADIST |
113 | DISTR.BETA.INV | BETAINV |
114 | DISTR.BINOM | BINOMDIST |
115 | DISTR.CHI | CHIDIST |
116 | DISTR.EXP | EXPONDIST |
117 | DISTR.F | FDIST |
118 | DISTR.F.INV | FINV |
119 | DISTR.GAMMA | GAMMADIST |
120 | DISTR.GAMMA.INV | GAMMAINV |
121 | DISTR.HIPERGEOM | HYPGEOMDIST |
122 | DISTR.LOG.NORM | LOGNORMDIST(;0; |
123 | DISTR.NORM | NORMDIST |
124 | DISTR.NORM.ESTAND | NORMSDIST |
125 | DISTR.NORM.ESTAND.INV | NORMSINV |
126 | DISTR.NORM.INV | NORMINV |
127 | DISTR.T | TDIST |
128 | DISTR.T.INV | TINV |
129 | DOMINGOPASCUA | EASTERSUNDAY |
130 | DURACIÓN | DURATION |
131 | DURACION_ADD | com.sun.star.sheet.addin.Analysis.getDuration |
132 | DURACION.MODIF | com.sun.star.sheet.addin.Analysis.getMduration |
133 | DVS | VDB |
134 | ELEGIR | CHOOSE |
135 | ENCONTRAR | FIND |
136 | ERROR.TÍPICO.XY | STEYX |
137 | ES.IMPAR_ADD | com.sun.star.sheet.addin.Analysis.getIsodd |
138 | ESAÑOBISIESTO | com.sun.star.sheet.addin.DateFunctions.getIsLeapYear |
139 | ESBLANCO | ISBLANK |
140 | ESERR | ISERR |
141 | ESERROR | ISERROR |
142 | ESFÓRMULA | ISFORMULA |
143 | ESIMPAR | ISODD |
144 | ESLOGICO | ISLOGICAL |
145 | ESNOD | ISNA |
146 | ESNOTEXTO | ISNONTEXT |
147 | ESNÚMERO | ISNUMBER |
148 | ESPAR | ISEVEN |
149 | ESPAR_ADD | com.sun.star.sheet.addin.Analysis.getIseven |
150 | ESREF | ISREF |
151 | ESTEXTO | ISTEXT |
152 | ESTILO | STYLE |
153 | ESTIMACIÓN.LINEAL | LINEST |
154 | ESTIMACIÓN.LOGARÍTMICA | LOGEST |
155 | EUROCONVERT | EUROCONVERT |
156 | EXP | EXP |
157 | FACT | FACT |
158 | FACT.DOBLE | com.sun.star.sheet.addin.Analysis.getFactdouble |
159 | FALSO | FALSE |
160 | FECHA | DATE |
161 | FECHA.MES | com.sun.star.sheet.addin.Analysis.getEdate |
162 | FECHANÚMERO | DATEVALUE |
163 | FIJO | FIXED |
164 | FILA | ROW |
165 | FILAS | ROWS |
166 | FIN.MES | com.sun.star.sheet.addin.Analysis.getEomonth |
167 | FISHER | FISHER |
168 | FÓRMULA | FORMULA |
169 | FRAC.AÑO | com.sun.star.sheet.addin.Analysis.getYearfrac |
170 | FRECUENCIA | FREQUENCY |
171 | FUN.ERROR | com.sun.star.sheet.addin.Analysis.getErf |
172 | FUN.ERROR.COMPL | com.sun.star.sheet.addin.Analysis.getErfc |
173 | GAMMA | GAMMA |
174 | GAMMA.LN | GAMMALN |
175 | GAUSS | GAUSS |
176 | GETPIVOTDATA | GETPIVOTDATA |
177 | GRADOS | DEGREES |
178 | HALLAR | SEARCH |
179 | HEX.A.BIN | com.sun.star.sheet.addin.Analysis.getHex2Bin |
180 | HEX.A.DEC | com.sun.star.sheet.addin.Analysis.getHex2Dec |
181 | HEX.A.OCT | com.sun.star.sheet.addin.Analysis.getHex2Oct |
182 | HIPERVÍNCULO | HYPERLINK |
183 | HOJA | SHEET |
184 | HOJAS | SHEETS |
185 | HORA | HOUR |
186 | HORANÚMERO | TIMEVALUE |
187 | HOY | TODAY |
188 | IGUAL | EXACT |
189 | IM.ABS | com.sun.star.sheet.addin.Analysis.getImabs |
190 | IM.ANGULO | com.sun.star.sheet.addin.Analysis.getImargument |
191 | IM.CONJUGADA | com.sun.star.sheet.addin.Analysis.getImconjugate |
192 | IM.COS | com.sun.star.sheet.addin.Analysis.getImcos |
193 | IM.DIV | com.sun.star.sheet.addin.Analysis.getImdiv |
194 | IM.EXP | com.sun.star.sheet.addin.Analysis.getImexp |
195 | IM.LN | com.sun.star.sheet.addin.Analysis.getImln |
196 | IM.LOG10 | com.sun.star.sheet.addin.Analysis.getImlog10 |
197 | IM.LOG2 | com.sun.star.sheet.addin.Analysis.getImlog2 |
198 | IM.POT | com.sun.star.sheet.addin.Analysis.getImpower |
199 | IM.PRODUCT | com.sun.star.sheet.addin.Analysis.getImproduct |
200 | IM.RAIZ2 | com.sun.star.sheet.addin.Analysis.getImsqrt |
201 | IM.REAL | com.sun.star.sheet.addin.Analysis.getImreal |
202 | IM.SENO | com.sun.star.sheet.addin.Analysis.getImsin |
203 | IM.SUM | com.sun.star.sheet.addin.Analysis.getImsum |
204 | IM.SUSTR | com.sun.star.sheet.addin.Analysis.getImsub |
205 | IMAGINARIO | com.sun.star.sheet.addin.Analysis.getImaginary |
206 | ÍNDICE | INDEX |
207 | INDIRECTO | INDIRECT |
208 | INFO | INFO |
209 | INT | INT |
210 | INT.ACUM | com.sun.star.sheet.addin.Analysis.getAccrint |
211 | INT.ACUM.V | com.sun.star.sheet.addin.Analysis.getAccrintm |
212 | INT.EFECTIVO | EFFECTIVE |
213 | INT.EFECTIVO_ADD | com.sun.star.sheet.addin.Analysis.getEffect |
214 | INT.PAGO.DIR | ISPMT |
215 | INT.RENDIMIENTO | ZGZ |
216 | INTERSECCIÓN.EJE | INTERCEPT |
217 | INV.LOG | LOGINV |
218 | IZQUIERDA | LEFT |
219 | JERARQUÍA | RANK |
220 | JIS | JIS |
221 | K.ESIMO.MAYOR | LARGE |
222 | K.ESIMO.MENOR | SMALL |
223 | LARGO | LEN |
224 | LETRA.DE.TES.EQV.A.BONO | com.sun.star.sheet.addin.Analysis.getTbilleq |
225 | LETRA.DE.TES.PRECIO | com.sun.star.sheet.addin.Analysis.getTbillprice |
226 | LETRA.DE.TES.RENDTO | com.sun.star.sheet.addin.Analysis.getTbillyield |
227 | LIMPIAR | CLEAN |
228 | LN | LN |
229 | LOG | LOG(;1 |
230 | LOG10 | LOG10 |
231 | M.C.D | GCD |
232 | M.C.D_ADD | com.sun.star.sheet.addin.Analysis.getGcd |
233 | M.C.M | LCM |
234 | M.C.M_ADD | com.sun.star.sheet.addin.Analysis.getLcm |
235 | MÁX | MAX |
236 | MÁXA | MAXA |
237 | MAYOR.O.IGUAL | com.sun.star.sheet.addin.Analysis.getGestep |
238 | MAYÚSC | UPPER |
239 | MDETERM | MDETERM |
240 | MEDIA.ACOTADA | TRIMMEAN |
241 | MEDIA.ARMO | HARMEAN |
242 | MEDIA.GEOM | GEOMEAN |
243 | MEDIANA | MEDIAN |
244 | MES | MONTH |
245 | MESES | com.sun.star.sheet.addin.DateFunctions.getDiffMonths |
246 | MID | MID |
247 | MÍN | MIN |
248 | MÍNA | MINA |
249 | MINÚSC | LOWER |
250 | MINUTO | MINUTE |
251 | MINVERSA | MINVERSE |
252 | MIRR | MIRR |
253 | MMULT | MMULT |
254 | MODO | MODE |
255 | MONEDA | DOLLAR |
256 | MONEDA.DEC | com.sun.star.sheet.addin.Analysis.getDollarde |
257 | MONEDA.FRAC | com.sun.star.sheet.addin.Analysis.getDollarfr |
258 | MULTINOMIAL | com.sun.star.sheet.addin.Analysis.getMultinomial |
259 | MÚLTIPLO.INFERIOR | FLOOR |
260 | MÚLTIPLO.SUPERIOR | CEILING |
261 | MUNITARIA | MUNIT |
262 | N | N |
263 | NEGBINOMDIST | NEGBINOMDIST |
264 | NO | NOT |
265 | NOD | NA |
266 | NOMPROPIO | PROPER |
267 | NORMALIZACIÓN | STANDARDIZE |
268 | NPER | NPER |
269 | NUM.DE.SEMANA_ADD | com.sun.star.sheet.addin.Analysis.getWeeknum |
270 | O | OR |
271 | OCT.A.BIN | com.sun.star.sheet.addin.Analysis.getOct2Bin |
272 | OCT.A.DEC | com.sun.star.sheet.addin.Analysis.getOct2Dec |
273 | OCT.A.HEX | com.sun.star.sheet.addin.Analysis.getOct2Hex |
274 | PAGO | PMT |
275 | PAGO.INT.ENTRE | CUMIPMT |
276 | PAGO.INT.ENTRE_ADD | com.sun.star.sheet.addin.Analysis.getCumipmt |
277 | PAGO.PRINC.ENTRE | CUMPRINC |
278 | PAGO.PRINC.ENTRE_ADD | com.sun.star.sheet.addin.Analysis.getCumprinc |
279 | PAGOINT | IPMT |
280 | PAGOPRIN | PPMT |
281 | PEARSON | PEARSON |
282 | PENDIENTE | SLOPE |
283 | PERCENTIL | PERCENTILE |
284 | PERMUTACIONES | PERMUT |
285 | PERMUTACIONESA | PERMUTATIONA |
286 | PHI | PHI |
287 | PI | PI |
288 | POISSON | POISSON |
289 | POTENCIA | POWER |
290 | PRECIO | com.sun.star.sheet.addin.Analysis.getPrice |
291 | PRECIO.DESCUENTO | com.sun.star.sheet.addin.Analysis.getPricedisc |
292 | PRECIO.PER.IRREGULAR.1 | com.sun.star.sheet.addin.Analysis.getOddfprice |
293 | PRECIO.PER.IRREGULAR.2 | com.sun.star.sheet.addin.Analysis.getOddlprice |
294 | PRECIO.VENCIMIENTO | com.sun.star.sheet.addin.Analysis.getPricemat |
295 | PROBABILIDAD | PROB |
296 | PRODUCTO | PRODUCT |
297 | PROMEDIO | AVERAGE |
298 | PROMEDIOA | AVERAGEA |
299 | PRONÓSTICO | FORECAST |
300 | PRUEBA.CHI | CHITEST |
301 | PRUEBA.CHI.INV | CHIINV |
302 | PRUEBA.F | FTEST |
303 | PRUEBA.FISHER.INV | FISHERINV |
304 | PRUEBA.T | TTEST |
305 | PRUEBA.Z | ZTEST |
306 | RADIANES | RADIANS |
307 | RAIZ | SQRT |
308 | RAIZ2PI | com.sun.star.sheet.addin.Analysis.getSqrtpi |
309 | RANGO.PERCENTIL | PERCENTRANK |
310 | REDOND.MULT | com.sun.star.sheet.addin.Analysis.getMround |
311 | REDONDEA.IMPAR | ODD |
312 | REDONDEA.PAR | EVEN |
313 | REDONDEAR | ROUND |
314 | REDONDEAR.MAS | ROUNDUP |
315 | REDONDEAR.MENOS | ROUNDDOWN |
316 | REDUCIR | TRIM |
317 | REEMPLAZAR | REPLACE |
318 | RENDTO | com.sun.star.sheet.addin.Analysis.getYield |
319 | RENDTO.DESC | com.sun.star.sheet.addin.Analysis.getYielddisc |
320 | RENDTO.PER.IRREGULAR.1 | com.sun.star.sheet.addin.Analysis.getOddfyield |
321 | RENDTO.PER.IRREGULAR.2 | com.sun.star.sheet.addin.Analysis.getOddlyield |
322 | RENDTO.VENCTO | com.sun.star.sheet.addin.Analysis.getYieldmat |
323 | REPETIR | REPT |
324 | RESIDUO | MOD |
325 | ROMANO | ROMAN |
326 | ROT13 | com.sun.star.sheet.addin.DateFunctions.getRot13 |
327 | SEGUNDO | SECOND |
328 | SEM.DEL.AÑO | WEEKNUM |
329 | SEMANAS | com.sun.star.sheet.addin.DateFunctions.getDiffWeeks |
330 | SEMANASENAÑO | com.sun.star.sheet.addin.DateFunctions.getWeeksInYear |
331 | SENO | SIN |
332 | SENOH | SINH |
333 | SI | IF |
334 | SIGNO | SIGN |
335 | SLN | SLN |
336 | SUBTOTALES | SUBTOTAL |
337 | SUMA | SUM |
338 | SUMA.CUADRADOS | SUMSQ |
339 | SUMA.PRODUCTO | SUMPRODUCT |
340 | SUMA.SERIES | com.sun.star.sheet.addin.Analysis.getSeriessum |
341 | SUMAR.SI | SUMIF |
342 | SUMAX2MASY2 | SUMX2PY2 |
343 | SUMAX2MENOSY2 | SUMX2MY2 |
344 | SUMAXMENOSY2 | SUMXMY2 |
345 | SUSTITUIR | SUBSTITUTE |
346 | SYD | SYD |
347 | T | T |
348 | TAN | TAN |
349 | TANH | TANH |
350 | TASA | RATE |
351 | TASA.DESC | com.sun.star.sheet.addin.Analysis.getDisc |
352 | TASA.INT | com.sun.star.sheet.addin.Analysis.getIntrate |
353 | TASA.NOMINAL | NOMINAL |
354 | TASA.NOMINAL_ADD | com.sun.star.sheet.addin.Analysis.getNominal |
355 | TENDENCIA | TREND |
356 | TEXTO | TEXT |
357 | TIEMPO | TIME |
358 | TIPO | TYPE |
359 | TIPO.DE.ERROR | ERRORTYPE |
360 | TIR | IRR |
361 | TIR.NO.PER | com.sun.star.sheet.addin.Analysis.getXirr |
362 | TRANSPONER | TRANSPOSE |
363 | TRUNCAR | TRUNC |
364 | UNICHAR | UNICHAR |
365 | UNICODE | UNICODE |
366 | VA | PV |
367 | VALOR | VALUE |
368 | VAR | VAR |
369 | VARA | VARA |
370 | VARP | VARP |
371 | VARPA | VARPA |
372 | VERDADERO | TRUE |
373 | VF | FV |
374 | VF.PLAN | com.sun.star.sheet.addin.Analysis.getFvschedule |
375 | VNA | NPV |
376 | VNA.NO.PER | com.sun.star.sheet.addin.Analysis.getXnpv |
377 | 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 |