PageRenderTime 20ms CodeModel.GetById 12ms app.highlight 3ms RepoModel.GetById 1ms app.codeStats 1ms

/PHPExcel/Calculation/functionlist.txt

https://bitbucket.org/nfredricks/wp-employee-time
Plain Text | 351 lines | 351 code | 0 blank | 0 comment | 0 complexity | a44608185f9bc21f28dd0173739f023b MD5 | raw file
  1ABS
  2ACCRINT
  3ACCRINTM
  4ACOS
  5ACOSH
  6ADDRESS
  7AMORDEGRC
  8AMORLINC
  9AND
 10AREAS
 11ASC
 12ASIN
 13ASINH
 14ATAN
 15ATAN2
 16ATANH
 17AVEDEV
 18AVERAGE
 19AVERAGEA
 20AVERAGEIF
 21AVERAGEIFS
 22BAHTTEXT
 23BESSELI
 24BESSELJ
 25BESSELK
 26BESSELY
 27BETADIST
 28BETAINV
 29BIN2DEC
 30BIN2HEX
 31BIN2OCT
 32BINOMDIST
 33CEILING
 34CELL
 35CHAR
 36CHIDIST
 37CHIINV
 38CHITEST
 39CHOOSE
 40CLEAN
 41CODE
 42COLUMN
 43COLUMNS
 44COMBIN
 45COMPLEX
 46CONCATENATE
 47CONFIDENCE
 48CONVERT
 49CORREL
 50COS
 51COSH
 52COUNT
 53COUNTA
 54COUNTBLANK
 55COUNTIF
 56COUNTIFS
 57COUPDAYBS
 58COUPDAYBS
 59COUPDAYSNC
 60COUPNCD
 61COUPNUM
 62COUPPCD
 63COVAR
 64CRITBINOM
 65CUBEKPIMEMBER
 66CUBEMEMBER
 67CUBEMEMBERPROPERTY
 68CUBERANKEDMEMBER
 69CUBESET
 70CUBESETCOUNT
 71CUBEVALUE
 72CUMIPMT
 73CUMPRINC
 74DATE
 75DATEDIF
 76DATEVALUE
 77DAVERAGE
 78DAY
 79DAYS360
 80DB
 81DCOUNT
 82DCOUNTA
 83DDB
 84DEC2BIN
 85DEC2HEX
 86DEC2OCT
 87DEGREES
 88DELTA
 89DEVSQ
 90DGET
 91DISC
 92DMAX
 93DMIN
 94DOLLAR
 95DOLLARDE
 96DOLLARFR
 97DPRODUCT
 98DSTDEV
 99DSTDEVP
100DSUM
101DURATION
102DVAR
103DVARP
104EDATE
105EFFECT
106EOMONTH
107ERF
108ERFC
109ERROR.TYPE
110EVEN
111EXACT
112EXP
113EXPONDIST
114FACT
115FACTDOUBLE
116FALSE
117FDIST
118FIND
119FINDB
120FINV
121FISHER
122FISHERINV
123FIXED
124FLOOR
125FORECAST
126FREQUENCY
127FTEST
128FV
129FVSCHEDULE
130GAMAMDIST
131GAMMAINV
132GAMMALN
133GCD
134GEOMEAN
135GESTEP
136GETPIVOTDATA
137GROWTH
138HARMEAN
139HEX2BIN
140HEX2OCT
141HLOOKUP
142HOUR
143HYPERLINK
144HYPGEOMDIST
145IF
146IFERROR
147IMABS
148IMAGINARY
149IMARGUMENT
150IMCONJUGATE
151IMCOS
152IMEXP
153IMLN
154IMLOG10
155IMLOG2
156IMPOWER
157IMPRODUCT
158IMREAL
159IMSIN
160IMSQRT
161IMSUB
162IMSUM
163INDEX
164INDIRECT
165INFO
166INT
167INTERCEPT
168INTRATE
169IPMT
170IRR
171ISBLANK
172ISERR
173ISERROR
174ISEVEN
175ISLOGICAL
176ISNA
177ISNONTEXT
178ISNUMBER
179ISODD
180ISPMT
181ISREF
182ISTEXT
183JIS
184KURT
185LARGE
186LCM
187LEFT
188LEFTB
189LEN
190LENB
191LINEST
192LN
193LOG
194LOG10
195LOGEST
196LOGINV
197LOGNORMDIST
198LOOKUP
199LOWER
200MATCH
201MAX
202MAXA
203MDETERM
204MDURATION
205MEDIAN
206MID
207MIDB
208MIN
209MINA
210MINUTE
211MINVERSE
212MIRR
213MMULT
214MOD
215MODE
216MONTH
217MROUND
218MULTINOMIAL
219N
220NA
221NEGBINOMDIST
222NETWORKDAYS
223NOMINAL
224NORMDIST
225NORMINV
226NORMSDIST
227NORMSINV
228NOT
229NOW
230NPER
231NPV
232OCT2BIN
233OCT2DEC
234OCT2HEX
235ODD
236ODDFPRICE
237ODDFYIELD
238ODDLPRICE
239ODDLYIELD
240OFFSET
241OR
242PEARSON
243PERCENTILE
244PERCENTRANK
245PERMUT
246PHONETIC
247PI
248PMT
249POISSON
250POWER
251PPMT
252PRICE
253PRICEDISC
254PRICEMAT
255PROB
256PRODUCT
257PROPER
258PV
259QUARTILE
260QUOTIENT
261RADIANS
262RAND
263RANDBETWEEN
264RANK
265RATE
266RECEIVED
267REPLACE
268REPLACEB
269REPT
270RIGHT
271RIGHTB
272ROMAN
273ROUND
274ROUNDDOWN
275ROUNDUP
276ROW
277ROWS
278RSQ
279RTD
280SEARCH
281SEARCHB
282SECOND
283SERIESSUM
284SIGN
285SIN
286SINH
287SKEW
288SLN
289SLOPE
290SMALL
291SQRT
292SQRTPI
293STANDARDIZE
294STDEV
295STDEVA
296STDEVP
297STDEVPA
298STEYX
299SUBSTITUTE
300SUBTOTAL
301SUM
302SUMIF
303SUMIFS
304SUMPRODUCT
305SUMSQ
306SUMX2MY2
307SUMX2PY2
308SUMXMY2
309SYD
310T
311TAN
312TANH
313TBILLEQ
314TBILLPRICE
315TBILLYIELD
316TDIST
317TEXT
318TIME
319TIMEVALUE
320TINV
321TODAY
322TRANSPOSE
323TREND
324TRIM
325TRIMMEAN
326TRUE
327TRUNC
328TTEST
329TYPE
330UPPER
331USDOLLAR
332VALUE
333VAR
334VARA
335VARP
336VARPA
337VDB
338VERSION
339VLOOKUP
340WEEKDAY
341WEEKNUM
342WEIBULL
343WORKDAY
344XIRR
345XNPV
346YEAR
347YEARFRAC
348YIELD
349YIELDDISC
350YIELDMAT
351ZTEST