Blame view

src/lib/PHPExcel/Calculation/functionlist.txt 2.79 KB
1ea3b987   Administrator   maby first commit
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
  ABS

  ACCRINT

  ACCRINTM

  ACOS

  ACOSH

  ADDRESS

  AMORDEGRC

  AMORLINC

  AND

  AREAS

  ASC

  ASIN

  ASINH

  ATAN

  ATAN2

  ATANH

  AVEDEV

  AVERAGE

  AVERAGEA

  AVERAGEIF

  AVERAGEIFS

  BAHTTEXT

  BESSELI

  BESSELJ

  BESSELK

  BESSELY

  BETADIST

  BETAINV

  BIN2DEC

  BIN2HEX

  BIN2OCT

  BINOMDIST

  CEILING

  CELL

  CHAR

  CHIDIST

  CHIINV

  CHITEST

  CHOOSE

  CLEAN

  CODE

  COLUMN

  COLUMNS

  COMBIN

  COMPLEX

  CONCATENATE

  CONFIDENCE

  CONVERT

  CORREL

  COS

  COSH

  COUNT

  COUNTA

  COUNTBLANK

  COUNTIF

  COUNTIFS

  COUPDAYBS

  COUPDAYBS

  COUPDAYSNC

  COUPNCD

  COUPNUM

  COUPPCD

  COVAR

  CRITBINOM

  CUBEKPIMEMBER

  CUBEMEMBER

  CUBEMEMBERPROPERTY

  CUBERANKEDMEMBER

  CUBESET

  CUBESETCOUNT

  CUBEVALUE

  CUMIPMT

  CUMPRINC

  DATE

  DATEDIF

  DATEVALUE

  DAVERAGE

  DAY

  DAYS360

  DB

  DCOUNT

  DCOUNTA

  DDB

  DEC2BIN

  DEC2HEX

  DEC2OCT

  DEGREES

  DELTA

  DEVSQ

  DGET

  DISC

  DMAX

  DMIN

  DOLLAR

  DOLLARDE

  DOLLARFR

  DPRODUCT

  DSTDEV

  DSTDEVP

  DSUM

  DURATION

  DVAR

  DVARP

  EDATE

  EFFECT

  EOMONTH

  ERF

  ERFC

  ERROR.TYPE

  EVEN

  EXACT

  EXP

  EXPONDIST

  FACT

  FACTDOUBLE

  FALSE

  FDIST

  FIND

  FINDB

  FINV

  FISHER

  FISHERINV

  FIXED

  FLOOR

  FORECAST

  FREQUENCY

  FTEST

  FV

  FVSCHEDULE

  GAMAMDIST

  GAMMAINV

  GAMMALN

  GCD

  GEOMEAN

  GESTEP

  GETPIVOTDATA

  GROWTH

  HARMEAN

  HEX2BIN

  HEX2OCT

  HLOOKUP

  HOUR

  HYPERLINK

  HYPGEOMDIST

  IF

  IFERROR

  IMABS

  IMAGINARY

  IMARGUMENT

  IMCONJUGATE

  IMCOS

  IMEXP

  IMLN

  IMLOG10

  IMLOG2

  IMPOWER

  IMPRODUCT

  IMREAL

  IMSIN

  IMSQRT

  IMSUB

  IMSUM

  INDEX

  INDIRECT

  INFO

  INT

  INTERCEPT

  INTRATE

  IPMT

  IRR

  ISBLANK

  ISERR

  ISERROR

  ISEVEN

  ISLOGICAL

  ISNA

  ISNONTEXT

  ISNUMBER

  ISODD

  ISPMT

  ISREF

  ISTEXT

  JIS

  KURT

  LARGE

  LCM

  LEFT

  LEFTB

  LEN

  LENB

  LINEST

  LN

  LOG

  LOG10

  LOGEST

  LOGINV

  LOGNORMDIST

  LOOKUP

  LOWER

  MATCH

  MAX

  MAXA

  MDETERM

  MDURATION

  MEDIAN

  MID

  MIDB

  MIN

  MINA

  MINUTE

  MINVERSE

  MIRR

  MMULT

  MOD

  MODE

  MONTH

  MROUND

  MULTINOMIAL

  N

  NA

  NEGBINOMDIST

  NETWORKDAYS

  NOMINAL

  NORMDIST

  NORMINV

  NORMSDIST

  NORMSINV

  NOT

  NOW

  NPER

  NPV

  OCT2BIN

  OCT2DEC

  OCT2HEX

  ODD

  ODDFPRICE

  ODDFYIELD

  ODDLPRICE

  ODDLYIELD

  OFFSET

  OR

  PEARSON

  PERCENTILE

  PERCENTRANK

  PERMUT

  PHONETIC

  PI

  PMT

  POISSON

  POWER

  PPMT

  PRICE

  PRICEDISC

  PRICEMAT

  PROB

  PRODUCT

  PROPER

  PV

  QUARTILE

  QUOTIENT

  RADIANS

  RAND

  RANDBETWEEN

  RANK

  RATE

  RECEIVED

  REPLACE

  REPLACEB

  REPT

  RIGHT

  RIGHTB

  ROMAN

  ROUND

  ROUNDDOWN

  ROUNDUP

  ROW

  ROWS

  RSQ

  RTD

  SEARCH

  SEARCHB

  SECOND

  SERIESSUM

  SIGN

  SIN

  SINH

  SKEW

  SLN

  SLOPE

  SMALL

  SQRT

  SQRTPI

  STANDARDIZE

  STDEV

  STDEVA

  STDEVP

  STDEVPA

  STEYX

  SUBSTITUTE

  SUBTOTAL

  SUM

  SUMIF

  SUMIFS

  SUMPRODUCT

  SUMSQ

  SUMX2MY2

  SUMX2PY2

  SUMXMY2

  SYD

  T

  TAN

  TANH

  TBILLEQ

  TBILLPRICE

  TBILLYIELD

  TDIST

  TEXT

  TIME

  TIMEVALUE

  TINV

  TODAY

  TRANSPOSE

  TREND

  TRIM

  TRIMMEAN

  TRUE

  TRUNC

  TTEST

  TYPE

  UPPER

  USDOLLAR

  VALUE

  VAR

  VARA

  VARP

  VARPA

  VDB

  VERSION

  VLOOKUP

  WEEKDAY

  WEEKNUM

  WEIBULL

  WORKDAY

  XIRR

  XNPV

  YEAR

  YEARFRAC

  YIELD

  YIELDDISC

  YIELDMAT

  ZTEST