Blame view

src/lib/PHPExcel/Calculation/functionlist.txt 2.45 KB
ef60cd4d   Administrator   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