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

Latest revision as of 16:09, 20 April 2015


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 ALEATORIO.ENTRE RANDBETWEEN
10 AMORTIZ.LIN AMORLINC
11 AMORTIZ.PROGRE AMORDEGRC
12 AÑO YEAR
13 AÑOS YEARS
14 ARABE ARABIC
15 AREAS AREAS
16 ASC ASC
17 ASENO ASIN
18 ASENOH ASINH
19 ATAN ATAN
20 ATAN2 ATAN2
21 ATANH ATANH
22 B B
23 BAHTTEXT BAHTTEXT
24 BASE BASE
25 BDCONTAR DCOUNT
26 BDCONTARA DCOUNTA
27 BDDESVEST DSTDEV
28 BDDESVESTP DSTDEVP
29 BDEXTRAER DGET
30 BDMAX DMAX
31 BDMIN DMIN
32 BDPRODUCTO DPRODUCT
33 BDPROMEDIO DAVERAGE
34 BDSUMA DSUM
35 BDVAR DVAR
36 BDVARP DVARP
37 BESSELI BESSELI
38 BESSELJ BESSELJ
39 BESSELK BESSELK
40 BESSELY BESSELY
41 BIN.A.DEC BIN2DEC
42 BIN.A.HEX BIN2HEX
43 BIN.A.OCT BIN2OCT
44 BINOM.CRIT CRITBINOM
45 BUSCAR LOOKUP
46 BUSCARH HLOOKUP
47 BUSCARV VLOOKUP
48 CANTIDAD.RECIBIDA RECEIVED
49 CARACTER CHAR
50 CELDA CELL
51 CHISQDIST CHISQDIST
52 CHISQINV CHISQINV
53 COCIENTE QUOTIENT
54 CODIGO CODE
55 COEF.DE.CORREL CORREL
56 COEFICIENTE.ASIMETRIA SKEW
57 COEFICIENTE.R2 RSQ
58 COINCIDIR MATCH
59 COLUMNA COLUMN
60 COLUMNAS COLUMNS
61 COMBINAT COMBIN
62 COMBINATA COMBINA
63 COMPLEJO COMPLEX
64 CONCATENAR CONCATENATE
65 CONFIANZA CONFIDENCE
66 CONTAR COUNT
67 CONTAR.BLANCO COUNTBLANK
68 CONTAR.SI COUNTIF
69 CONTAR.SIS COUNTIFS
70 CONTARA COUNTA
71 CONVERTIR CONVERT
72 COS COS
73 COSH COSH
74 COT COT
75 COTH COTH
76 COVAR COVAR
77 CRECIMIENTO GROWTH
78 CSC CSC
79 CSCH CSCH
80 CUARTIL QUARTILE
81 CUPON.DIAS COUPDAYS
82 CUPON.DIAS.L1 COUPDAYBS
83 CUPON.DIAS.L2 COUPDAYSNC
84 CUPON.FECHA.L1 COUPPCD
85 CUPON.FECHA.L2 COUPNCD
86 CUPON.NUM COUPNUM
87 CURTOSIS KURT
88 DB DB
89 DDB DDB
90 DDE DDE
91 DEC.A.BIN DEC2BIN
92 DEC.A.HEX DEC2EX
93 DEC.A.OCT DEC2OCT
94 DECIMAL DECIMAL
95 DELTA DELTA
96 DERECHA RIGHT
97 DERECHAB RIGHTB
98 DESREF OFFSET
99 DESVEST STDEV
100 DESVESTA STDEVA
101 DESVESTP STDEVP
102 DESVESTPA STDEVPA
103 DESVIA2 DEVSQ
104 DESVPROM AVEDEV
105 DIA DAY
106 DIA.LAB WORKDAY
107 DIAS DAYS
108 DIAS.LAB NETWORKDAYS
109 DIAS360 DAYS360
110 DIASEM WEEKDAY
111 DIASENAÑO DAYSINYEAR
112 DIASENMES DAYSINMONTH
113 DIRECCION ADDRESS
114 DIST.WEIBULL WEIBULL
115 DISTR.BETA BETADIST
116 DISTR.BETA.INV BETAINV
117 DISTR.BINOM BINOMDIST
118 DISTR.CHI CHIDIST
119 DISTR.EXP EXPONDIST
120 DISTR.F FDIST
121 DISTR.F.INV FINV
122 DISTR.GAMMA GAMMADIST
123 DISTR.GAMMA.INV GAMMAINV
124 DISTR.HIPERGEOM HYPGEOMDIST
125 DISTR.LOG.NORM LOGNORMDIST
126 DISTR.NORM NORMDIST
127 DISTR.NORM.ESTAND NORMSDIST
128 DISTR.NORM.ESTAND.INV NORMSINV
129 DISTR.NORM.INV NORMINV
130 DISTR.T TDIST
131 DISTR.T.INV TINV
132 DOMINGOPASCUA EASTERSUNDAY
133 DURACION DURATION
134 DURACION.MODIF MDURATION
135 DVS VDB
136 ELEGIR CHOOSE
137 ENCONTRAR FIND
138 ERROR.TIPICO.XY STEYX
139 ES.IMPAR ISODD
140 ES.PAR ISEVEN
141 ESAÑOBISIESTO ISLEAPYEAR
142 ESBLANCO ISBLANK
143 ESERR ISERR
144 ESERROR ISERROR
145 ESFORMULA ISFORMULA
146 ESLOGICO ISLOGICAL
147 ESNOD ISNA
148 ESNOTEXTO ISNONTEXT
149 ESNUMERO ISNUMBER
150 ESREF ISREF
151 ESTEXTO ISTEXT
152 ESTILO STYLE
153 ESTIMACION.LINEAL LINEST
154 ESTIMACION.LOGARITMICA LOGEST
155 EUROCONVERT EUROCONVERT
156 EXP EXP
157 FACT FACT
158 FACT.DOBLE FACTDOUBLE
159 FALSO FALSE
160 FECHA DATE
161 FECHA.MES EDATE
162 FECHANUMERO DATEVALUE
163 FIJO FIXED
164 FILA ROW
165 FILAS ROWS
166 FIN.MES EOMONTH
167 FISHER FISHER
168 FORMULA FORMULA
169 FRAC.AÑO YEARFRAC
170 FRECUENCIA FREQUENCY
171 FUN.ERROR ERF
172 FUN.ERROR.COMPL ERFC
173 GAMMA GAMMA
174 GAMMA.LN GAMMALN
175 GAUSS GAUSS
176 GETPIVOTDATA GETPIVOTDATA
177 GRADOS DEGREES
178 HALLAR SEARCH
179 HEX.A.BIN HEX2BIN
180 HEX.A.DEC HEX2DEC
181 HEX.A.OCT HEX2OCT
182 HIPERVINCULO HYPERLINK
183 HOJA SHEET
184 HOJAS SHEETS
185 HORA HOUR
186 HORANUMERO TIMEVALUE
187 HOY TODAY
188 IGUAL EXACT
189 IM.ABS IMABS
190 IM.ANGULO IMARGUMENT
191 IM.CONJUGADA IMCONJUGATE
192 IM.COS IMCOS
193 IM.DIV IMDIV
194 IM.EXP IMEXP
195 IM.LN IMLN
196 IM.LOG10 IMLOG10
197 IM.LOG2 IMLOG2
198 IM.POT IMPOWER
199 IM.PRODUCT IMPRODUCT
200 IM.RAIZ2 IMSQRT
201 IM.REAL IMREAL
202 IM.SENO IMSIN
203 IM.SUM IMSUM
204 IM.SUSTR IMSUB
205 IMAGINARIO IMAGINARY
206 INDICE INDEX
207 INDIRECTO INDIRECT
208 INFO INFO
209 INT INT
210 INT.ACUM ACCRINT
211 INT.ACUM.V ACCRINTM
212 INT.EFECTIVO EFFECTIVE
213 INT.PAGO.DIR ISPMT
214 INT.RENDIMIENTO RRI
215 INTERSECCION.EJE INTERCEPT
216 INV.LOG LOGINV
217 IZQUIERDA LEFT
218 IZQUIERDAB LEFTB
219 JERARQUIA RANK
220 JIS JIS
221 K.ESIMO.MAYOR LARGE
222 K.ESIMO.MENOR SMALL
223 LARGO LEN
224 LARGOB LENB
225 LETRA.DE.TES.EQV.A.BONO TBILLEQ
226 LETRA.DE.TES.PRECIO TBILLPRICE
227 LETRA.DE.TES.RENDTO TBILLYIELD
228 LIMPIAR CLEAN
229 LN LN
230 LOG LOG
231 LOG10 LOG10
232 M.C.D GCD
233 M.C.M LCM
234 MAX MAX
235 MAXA MAXA
236 MAYOR.O.IGUAL GESTEP
237 MAYUSC UPPER
238 MDETERM MDETERM
239 MEDIA.ACOTADA TRIMMEAN
240 MEDIA.ARMO HARMEAN
241 MEDIA.GEOM GEOMEAN
242 MEDIANA MEDIAN
243 MES MONTH
244 MESES MONTHS
245 MID MID
246 MIDB MIDB
247 MIN MIN
248 MINA MINA
249 MINUSC LOWER
250 MINUTO MINUTE
251 MINVERSA MINVERSE
252 MIRR MIRR
253 MMULT MMULT
254 MODA MODE
255 MONEDA DOLLAR
256 MONEDA.DEC DOLLARDE
257 MONEDA.FRAC DOLLARFR
258 MULTINOMIAL MULTINOMIAL
259 MULTIPLO.INFERIOR FLOOR
260 MULTIPLO.SUPERIOR CEILING
261 MULTIRANGO MULTIRANGE
262 MUNITARIA MUNIT
263 MVALOR MVALUE
264 N N
265 NEG NEG
266 NEGBINOMDIST NEGBINOMDIST
267 NO NOT
268 NOD NA
269 NOMPROPIO PROPER
270 NORMALIZACION STANDARDIZE
271 NPER NPER
272 O OR
273 OCT.A.BIN OCT2BIN
274 OCT.A.DEC OCT2DEC
275 OCT.A.HEX OCT2HEX
276 OPERACION.MULTIPLE MULTIPLE.OPERATIONS
277 PAGO PMT
278 PAGO.INT.ENTRE CUMIPMT
279 PAGO.PRINC.ENTRE CUMPRINC
280 PAGOINT IPMT
281 PAGOPRIN PPMT
282 PEARSON PEARSON
283 PENDIENTE SLOPE
284 PERCENTIL PERCENTILE
285 PERMUTACIONES PERMUT
286 PERMUTACIONESA PERMUTATIONA
287 PHI PHI
288 PI PI
289 POISSON POISSON
290 POTENCIA POWER
291 PRECIO PRICE
292 PRECIO.DESCUENTO PRICEDISC
293 PRECIO.PER.IRREGULAR.1 ODDFPRICE
294 PRECIO.PER.IRREGULAR.2 ODDLPRICE
295 PRECIO.VENCIMIENTO PRICEMAT
296 PROBABILIDAD PROB
297 PRODUCTO PRODUCT
298 PROMEDIO AVERAGE
299 PROMEDIO.SI AVERAGEIF
300 PROMEDIO.SIS AVERAGEIFS
301 PROMEDIOA AVERAGEA
302 PRONOSTICO FORECAST
303 PRUEBA.CHI CHITEST
304 PRUEBA.CHI.INV CHIINV
305 PRUEBA.F FTEST
306 PRUEBA.FISHER.INV FISHERINV
307 PRUEBA.T TTEST
308 PRUEBA.Z ZTEST
309 RADIANES RADIANS
310 RAIZ SQRT
311 RAIZ2PI SQRTPI
312 RANGO.PERCENTIL PERCENTRANK
313 REDOND.MULT MROUND
314 REDONDEA.IMPAR ODD
315 REDONDEA.PAR EVEN
316 REDONDEAR ROUND
317 REDONDEAR.MAS ROUNDUP
318 REDONDEAR.MENOS ROUNDDOWN
319 REDUCIR TRIM
320 REEMPLAZAR REPLACE
321 RENDTO YIELD
322 RENDTO.DESC YIELDDISC
323 RENDTO.PER.IRREGULAR.1 ODDFYIELD
324 RENDTO.PER.IRREGULAR.2 ODDLYIELD
325 RENDTO.VENCTO YIELDMAT
326 REPETIR REPT
327 RESIDUO MOD
328 ROMANO ROMAN
329 ROT13 ROT13
330 SEC SEC
331 SECH SECH
332 SEGUNDO SECOND
333 SEM.DEL.AÑO WEEKNUM
334 SEMANAS WEEKS
335 SEMANASENAÑO WEEKSINYEAR
336 SENO SIN
337 SENOH SINH
338 SI IF
339 SIGNO SIGN
340 SLN SLN
341 SUBTOTALES SUBTOTAL
342 SUMA SUM
343 SUMA.CUADRADOS SUMSQ
344 SUMA.PRODUCTO SUMPRODUCT
345 SUMA.SERIES SERIESSUM
346 SUMAR.SI SUMIF
347 SUMAR.SIS SUMIFS
348 SUMAX2MASY2 SUMX2PY2
349 SUMAX2MENOSY2 SUMX2MY2
350 SUMAXMENOSY2 SUMXMY2
351 SUSTITUIR SUBSTITUTE
352 SYD SYD
353 T T
354 TAN TAN
355 TANH TANH
356 TASA RATE
357 TASA.DESC DISC
358 TASA.INT INTRATE
359 TASA.NOMINAL NOMINAL
360 TENDENCIA TREND
361 TEXTO TEXT
362 TIEMPO TIME
363 TIPO TYPE
364 TIPO.DE.ERROR ERRORTYPE
365 TIR IRR
366 TIR.NO.PER XIRR
367 TRANSPONER TRANSPOSE
368 TRUNCAR TRUNC
369 UNICHAR UNICHAR
370 UNICODE UNICODE
371 VA PV
372 VALOR VALUE
373 VALOR.NÚMERO NUMBERVALUE
374 VALORPRETENDIDO GOALSEEK
375 VAR VAR
376 VARA VARA
377 VARP VARP
378 VARPA VARPA
379 VERDADERO TRUE
380 VF FV
381 VF.PLAN FVSCHEDULE
382 VNA NPV
383 VNA.NO.PER XNPV
384 XO XOR
385 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

Personal tools