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