Difference between revisions of "ES/Manuales/GuiaAOO/TemasAvanzados/Macros/StarBasic/Apendices/FormulasCalcEspanolIngles"

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




ES.Plantillas.Logo foro es.png
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


Retrieved from "https://wiki.openoffice.org/w/index.php?title=ES/Manuales/GuiaAOO/TemasAvanzados/Macros/StarBasic/Apendices/FormulasCalcEspanolIngles&oldid=235945"
Personal tools