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

Revision as of 11:33, 19 April 2015 (view source) Jucasaca (Talk | contribs) ← Older edit		Revision as of 16:58, 19 April 2015 (view source) Jucasaca (Talk | contribs) Newer edit →
Line 12:		Line 12:
	| ABS		| ABS
	|-		|-
−	|2	+	| 2
	| ACOS		| ACOS
	| ACOS		| ACOS
Line 20:		Line 20:
	| ACOSH		| ACOSH
	|-		|-
−	|4	+	| 4
	| ACOT		| ACOT
	| ACOT		| ACOT
Line 28:		Line 28:
	| ACOTH		| ACOTH
	|-		|-
−	|6	+	| 6
	| ACTUAL		| ACTUAL
	| CURRENT		| CURRENT
Line 36:		Line 36:
	| NOW		| NOW
	|-		|-
−	|8	+	| 8
	| ALEATORIO		| ALEATORIO
	| RAND		| RAND
Line 44:		Line 44:
	| YEAR		| YEAR
	|-		|-
−	|10	+	| 10
	| AÑOS		| AÑOS
	| YEARS		| YEARS
Line 52:		Line 52:
	| ARABIC		| ARABIC
	|-		|-
−	|12	+	| 12
	| AREAS		| AREAS
	| AREAS		| AREAS
Line 60:		Line 60:
	| ASC		| ASC
	|-		|-
−	|14	+	| 14
	| ASENO		| ASENO
	| ASIN		| ASIN
Line 68:		Line 68:
	| ASINH		| ASINH
	|-		|-
−	|16	+	| 16
	| ATAN		| ATAN
	| ATAN		| ATAN
Line 76:		Line 76:
	| ATAN2		| ATAN2
	|-		|-
−	|18	+	| 18
	| ATANH		| ATANH
	| ATANH		| ATANH
Line 85:		Line 85:
	|-		|-
	| 20		| 20
−	|BAHTTEXT	+	| BAHTTEXT
	| BAHTTEXT		| BAHTTEXT
	|-		|-
Line 92:		Line 92:
	| BASE		| BASE
	|-		|-
−	|22	+	| 22
	| BDCONTAR		| BDCONTAR
	| DCOUNT		| DCOUNT
Line 98:		Line 98:
	| 23		| 23
	| BDCONTARA		| BDCONTARA
−	|DCOUNTA	+	| DCOUNTA
	|-		|-
	| 24		| 24
Line 105:		Line 105:
	|-		|-
	| 25		| 25
−	|BDDESVESTP	+	| BDDESVESTP
	| DSTDEVP		| DSTDEVP
	|-		|-
Line 112:		Line 112:
	| DGET		| DGET
	|-		|-
−	|27	+	| 27
	| BDMAX		| BDMAX
	| DMAX		| DMAX
Line 126:		Line 126:
	| 30		| 30
	| BDPROMEDIO		| BDPROMEDIO
−	|DAVERAGE	+	| DAVERAGE
	|-		|-
	| 31		| 31
Line 133:		Line 133:
	|-		|-
	| 32		| 32
−	|BDVAR	+	| BDVAR
	| DVAR		| DVAR
	|-		|-
Line 168:		Line 168:
	| BIN2OCT		| BIN2OCT
	|-		|-
−	|41	+	| 41
	| BINOM.CRIT		| BINOM.CRIT
	| CRITBINOM		| CRITBINOM
Line 216:		Line 216:
	| CORREL		| CORREL
	|-		|-
−	|53	+	| 53
	| COEFICIENTE.ASIMETRIA		| COEFICIENTE.ASIMETRIA
	| SKEW		| SKEW
	|-		|-
	| 54		| 54
−	|COEFICIENTE.R2	+	| COEFICIENTE.R2
	| RSQ		| RSQ
	|-		|-
Line 244:		Line 244:
	| AMORLINC		| AMORLINC
	|-		|-
−	|60	+	| 60
	| ALEATORIO.ENTRE		| ALEATORIO.ENTRE
	| RANDBETWEEN		| RANDBETWEEN
Line 292:		Line 292:
	| CONVERT		| CONVERT
	|-		|-
−	|72	+	| 72
−	| CONVERTIR_ADD	+
−	| com.sun.star.sheet.addin.Analysis.getConvert	+
−	|-	+
−	| 73	+
	| COS		| COS
	| COS		| COS
	|-		|-
−	| 74	+	| 73
	| COSH		| COSH
	| COSH		| COSH
	|-		|-
−	| 75	+	| 74
	| COT		| COT
	| COT		| COT
	|-		|-
−	| 76	+	| 75
	| COTH		| COTH
	| COTH		| COTH
	|-		|-
−	| 77	+	| 76
	| COVAR		| COVAR
	| COVAR		| COVAR
	|-		|-
−	| 78	+	| 77
	| CRECIMIENTO		| CRECIMIENTO
	| GROWTH		| GROWTH
	|-		|-
−	| 79	+	| 78
	| CSC		| CSC
	| CSC		| CSC
	|-		|-
−	| 80	+	| 79
	| CSCH		| CSCH
	| CSCH		| CSCH
	|-		|-
−	| 81	+	| 80
	| CUARTIL		| CUARTIL
	| QUARTILE		| QUARTILE
	|-		|-
−	| 82	+	| 81
	| CUPON.DIAS		| CUPON.DIAS
	| COUPDAYS		| COUPDAYS
	|-		|-
−	| 83	+	| 82
	| CUPON.DIAS.L1		| CUPON.DIAS.L1
	| COUPDAYBS		| COUPDAYBS
	|-		|-
−	| 84	+	| 83
	| CUPON.DIAS.L2		| CUPON.DIAS.L2
	| COUPDAYSNC		| COUPDAYSNC
	|-		|-
−	| 85	+	| 84
	| 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
	|-		|-
−	| 89	+	| 88
	| DB		| DB
	| DB		| DB
	|-		|-
−	|90	+	| 89
	| DDB		| DDB
	| DDB		| DDB
	|-		|-
−	| 91	+	| 90
	| DDE		| DDE
	| DDE		| DDE
	|-		|-
−	| 92	+	| 91
	| 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
	|-		|-
−	| 95	+	| 94
	| DECIMAL		| DECIMAL
	| DECIMAL		| DECIMAL
	|-		|-
−	| 96	+	| 95
	| DELTA		| DELTA
	| DELTA		| DELTA
	|-		|-
−	| 97	+	| 96
	| DERECHA		| DERECHA
	| RIGHT		| RIGHT
	|-		|-
−	| 98	+	| 97
	| DERECHAB		| DERECHAB
	| RIGHTB		| RIGHTB
	|-		|-
−	| 99	+	| 98
	| DESREF		| DESREF
	| OFFSET		| OFFSET
	|-		|-
−	| 100	+	| 99
	| DESVEST		| DESVEST
	| STDEV		| STDEV
	|-		|-
−	| 101	+	| 100
	| DESVESTA		| DESVESTA
	| STDEVA		| STDEVA
	|-		|-
−	| 102	+	| 101
	| DESVESTP		| DESVESTP
	| STDEVP		| STDEVP
	|-		|-
−	| 103	+	| 102
	| DESVESTPA		| DESVESTPA
	| STDEVPA		| STDEVPA
	|-		|-
−	| 104	+	| 103
	| DESVIA2		| DESVIA2
	| DEVSQ		| DEVSQ
	|-		|-
−	| 105	+	| 104
	| DESVPROM		| DESVPROM
	| AVEDEV		| AVEDEV
	|-		|-
−	| 106	+	| 105
	| DIA		| DIA
	| DAY		| DAY
	|-		|-
−	| 107	+	| 106
	| DIA.LAB		| DIA.LAB
	| WORKDAY		| WORKDAY
	|-		|-
−	| 108	+	| 107
	| DIAS		| DIAS
	| DAYS		| DAYS
	|-		|-
−	| 109	+	| 108
	| DIAS.LAB		| DIAS.LAB
	| NETWORKDAYS		| NETWORKDAYS
Line 543:		Line 539:
	| DURACION		| DURACION
	| DURATION		| DURATION
−	|-
−	| 135
−	| DURACION_ADD
−	| com.sun.star.sheet.addin.Analysis.getDuration
	|-		|-
	| 136		| 136
Line 571:		Line 563:
	| ES.IMPAR		| ES.IMPAR
	| ISODD		| ISODD
−	|-
−	| 142
−	| ES.IMPAR_ADD
−	| com.sun.star.sheet.addin.Analysis.getIsodd
	|-		|-
	| 143		| 143
Line 615:		Line 603:
	| ESNUMERO		| ESNUMERO
	| ISNUMBER		| ISNUMBER
−	|-
−	| 153
−	| ESPAR_ADD
−	| com.sun.star.sheet.addin.Analysis.getIseven
	|-		|-
	| 154		| 154
Line 654:		Line 638:
	| 162		| 162
	| FACT.DOBLE		| FACT.DOBLE
−	| com.sun.star.sheet.addin.Analysis.getFactdouble	+	| FACTDOUBLE
	|-		|-
	|163		|163
Line 871:		Line 855:
	| INT.EFECTIVO		| INT.EFECTIVO
	| EFFECTIVE		| EFFECTIVE
−	|-
−	| 217
−	|INT.EFECTIVO_ADD
−	| com.sun.star.sheet.addin.Analysis.getEffect
	|-		|-
	| 218		| 218
Line 955:		Line 935:
	|M.C.D		|M.C.D
	| GCD		| GCD
−	|-
−	| 238
−	| M.C.D_ADD
−	|com.sun.star.sheet.addin.Analysis.getGcd
	|-		|-
	| 239		| 239
	| M.C.M		| M.C.M
−	|LCM	+	| LCM
−	|-	+
−	| 240	+
−	| M.C.M_ADD	+
−	|com.sun.star.sheet.addin.Analysis.getLcm	+
	|-		|-
	| 241		| 241
	| MAX		| MAX
−	|MAX	+	| MAX
	|-		|-
	| 242		| 242
Line 977:		Line 949:
	|-		|-
	| 243		| 243
−	|MAYOR.O.IGUAL	+	| MAYOR.O.IGUAL
	| com.sun.star.sheet.addin.Analysis.getGestep		| com.sun.star.sheet.addin.Analysis.getGestep
	|-		|-
−	|244	+	| 244
	| MAYUSC		| MAYUSC
	| UPPER		| UPPER
Line 986:		Line 958:
	| 245		| 245
	| MDETERM		| MDETERM
−	|MDETERM	+	| MDETERM
	|-		|-
	| 246		| 246
Line 992:		Line 964:
	| TRIMMEAN		| TRIMMEAN
	|-		|-
−	|247	+	| 247
	| MEDIA.ARMO		| MEDIA.ARMO
	| HARMEAN		| HARMEAN
Line 998:		Line 970:
	| 248		| 248
	| MEDIA.GEOM		| MEDIA.GEOM
−	|GEOMEAN	+	| GEOMEAN
	|-		|-
	| 249		| 249
Line 1,119:		Line 1,091:
	| NPER		| NPER
	| NPER		| NPER
−	|-
−	| 279
−	|NUM.DE.SEMANA_ADD
−	| com.sun.star.sheet.addin.Analysis.getWeeknum
	|-		|-
	| 280		| 280
Line 1,141:		Line 1,109:
	|-		|-
	| 284		| 284
−	| OPERACIÓN.MÚLTIPLE	+	| OPERACION.MULTIPLE
−	|MULTIPLE.OPERATIONS	+	| MULTIPLE.OPERATIONS
	|-		|-
	| 285		| 285
Line 1,151:		Line 1,119:
	| PAGO.INT.ENTRE		| PAGO.INT.ENTRE
	| CUMIPMT		| CUMIPMT
−	|-
−	| 287
−	|PAGO.INT.ENTRE_ADD
−	| com.sun.star.sheet.addin.Analysis.getCumipmt
	|-		|-
	| 288		| 288
Line 1,161:		Line 1,125:
	|-		|-
	| 289		| 289
−	|PAGOINT	+	| PAGOINT
	| IPMT		| IPMT
	|-		|-
Line 1,479:		Line 1,443:
	| TASA.NOMINAL		| TASA.NOMINAL
	| NOMINAL		| NOMINAL
−	|-
−	| 369
−	|TASA.NOMINAL_ADD
−	| com.sun.star.sheet.addin.Analysis.getNominal
	|-		|-
	| 370		| 370

---

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

Si tienes dudas acerca de lo aquí explicado, tienes algún problema con AOO, o quieres ampliar la información, no dudes en dirigirte al Foro Oficial en español de Apache OpenOffice para Macros y API UNO

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

Categories:

• ES
• Manuales
• ES/StarBasic