1#A
2
3    Excel Function      | Category                       | PHPExcel Function
4    --------------------|--------------------------------|-------------------------------------------
5    ABS                 | CATEGORY_MATH_AND_TRIG         | abs
6    ACCRINT             | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::ACCRINT
7    ACCRINTM            | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::ACCRINTM
8    ACOS                | CATEGORY_MATH_AND_TRIG         | acos
9    ACOSH               | CATEGORY_MATH_AND_TRIG         | acosh
10    ADDRESS             | CATEGORY_LOOKUP_AND_REFERENCE  | PHPExcel_Calculation_LookupRef::CELL_ADDRESS
11    AMORDEGRC           | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::AMORDEGRC
12    AMORLINC            | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::AMORLINC
13    AND                 | CATEGORY_LOGICAL               | PHPExcel_Calculation_Logical::LOGICAL_AND
14    AREAS               | CATEGORY_LOOKUP_AND_REFERENCE  | **\*\*\*  Not yet Implemented**
15    ASC                 | CATEGORY_TEXT_AND_DATA         | **\*\*\*  Not yet Implemented**
16    ASIN                | CATEGORY_MATH_AND_TRIG         | asin
17    ASINH               | CATEGORY_MATH_AND_TRIG         | asinh
18    ATAN                | CATEGORY_MATH_AND_TRIG         | atan
19    ATAN2               | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::REVERSE_ATAN2
20    ATANH               | CATEGORY_MATH_AND_TRIG         | atanh
21    AVEDEV              | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::AVEDEV
22    AVERAGE             | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::AVERAGE
23    AVERAGEA            | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::AVERAGEA
24    AVERAGEIF           | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::AVERAGEIF
25    AVERAGEIFS          | CATEGORY_STATISTICAL           | **\*\*\*  Not yet Implemented**
26
27#B
28
29    Excel Function      | Category                       | PHPExcel Function
30    --------------------|--------------------------------|-------------------------------------------
31    BAHTTEXT            | CATEGORY_TEXT_AND_DATA         | **\*\*\*  Not yet Implemented**
32    BESSELI             | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::BESSELI
33    BESSELJ             | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::BESSELJ
34    BESSELK             | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::BESSELK
35    BESSELY             | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::BESSELY
36    BETADIST            | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::BETADIST
37    BETAINV             | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::BETAINV
38    BIN2DEC             | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::BINTODEC
39    BIN2HEX             | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::BINTOHEX
40    BIN2OCT             | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::BINTOOCT
41    BINOMDIST           | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::BINOMDIST
42
43#C
44
45    Excel Function      | Category                       | PHPExcel Function
46    --------------------|--------------------------------|-------------------------------------------
47    CEILING             | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::CEILING
48    CELL                | CATEGORY_INFORMATION           | **\*\*\*  Not yet Implemented**
49    CHAR                | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::CHARACTER
50    CHIDIST             | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::CHIDIST
51    CHIINV              | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::CHIINV
52    CHITEST             | CATEGORY_STATISTICAL           | **\*\*\*  Not yet Implemented**
53    CHOOSE              | CATEGORY_LOOKUP_AND_REFERENCE  | PHPExcel_Calculation_LookupRef::CHOOSE
54    CLEAN               | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::TRIMNONPRINTABLE
55    CODE                | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::ASCIICODE
56    COLUMN              | CATEGORY_LOOKUP_AND_REFERENCE  | PHPExcel_Calculation_LookupRef::COLUMN
57    COLUMNS             | CATEGORY_LOOKUP_AND_REFERENCE  | PHPExcel_Calculation_LookupRef::COLUMNS
58    COMBIN              | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::COMBIN
59    COMPLEX             | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::COMPLEX
60    CONCATENATE         | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::CONCATENATE
61    CONFIDENCE          | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::CONFIDENCE
62    CONVERT             | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::CONVERTUOM
63    CORREL              | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::CORREL
64    COS                 | CATEGORY_MATH_AND_TRIG         | cos
65    COSH                | CATEGORY_MATH_AND_TRIG         | cosh
66    COUNT               | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::COUNT
67    COUNTA              | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::COUNTA
68    COUNTBLANK          | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::COUNTBLANK
69    COUNTIF             | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::COUNTIF
70    COUNTIFS            | CATEGORY_STATISTICAL           | **\*\*\*  Not yet Implemented**
71    COUPDAYBS           | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::COUPDAYBS
72    COUPDAYS            | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::COUPDAYS
73    COUPDAYSNC          | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::COUPDAYSNC
74    COUPNCD             | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::COUPNCD
75    COUPNUM             | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::COUPNUM
76    COUPPCD             | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::COUPPCD
77    COVAR               | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::COVAR
78    CRITBINOM           | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::CRITBINOM
79    CUBEKPIMEMBER       | CATEGORY_CUBE                  | **\*\*\*  Not yet Implemented**
80    CUBEMEMBER          | CATEGORY_CUBE                  | **\*\*\*  Not yet Implemented**
81    CUBEMEMBERPROPERTY  | CATEGORY_CUBE                  | **\*\*\*  Not yet Implemented**
82    CUBERANKEDMEMBER    | CATEGORY_CUBE                  | **\*\*\*  Not yet Implemented**
83    CUBESET             | CATEGORY_CUBE                  | **\*\*\*  Not yet Implemented**
84    CUBESETCOUNT        | CATEGORY_CUBE                  | **\*\*\*  Not yet Implemented**
85    CUBEVALUE           | CATEGORY_CUBE                  | **\*\*\*  Not yet Implemented**
86    CUMIPMT             | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::CUMIPMT
87    CUMPRINC            | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::CUMPRINC
88
89#D
90
91    Excel Function      | Category                       | PHPExcel Function
92    --------------------|--------------------------------|-------------------------------------------
93    DATE                | CATEGORY_DATE_AND_TIME         | PHPExcel_Calculation_DateTime::DATE
94    DATEDIF             | CATEGORY_DATE_AND_TIME         | PHPExcel_Calculation_DateTime::DATEDIF
95    DATEVALUE           | CATEGORY_DATE_AND_TIME         | PHPExcel_Calculation_DateTime::DATEVALUE
96    DAVERAGE            | CATEGORY_DATABASE              | PHPExcel_Calculation_Database::DAVERAGE
97    DAY                 | CATEGORY_DATE_AND_TIME         | PHPExcel_Calculation_DateTime::DAYOFMONTH
98    DAYS360             | CATEGORY_DATE_AND_TIME         | PHPExcel_Calculation_DateTime::DAYS360
99    DB                  | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::DB
100    DCOUNT              | CATEGORY_DATABASE              | PHPExcel_Calculation_Database::DCOUNT
101    DCOUNTA             | CATEGORY_DATABASE              | PHPExcel_Calculation_Database::DCOUNTA
102    DDB                 | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::DDB
103    DEC2BIN             | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::DECTOBIN
104    DEC2HEX             | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::DECTOHEX
105    DEC2OCT             | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::DECTOOCT
106    DEGREES             | CATEGORY_MATH_AND_TRIG         | rad2deg
107    DELTA               | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::DELTA
108    DEVSQ               | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::DEVSQ
109    DGET                | CATEGORY_DATABASE              | PHPExcel_Calculation_Database::DGET
110    DISC                | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::DISC
111    DMAX                | CATEGORY_DATABASE              | PHPExcel_Calculation_Database::DMAX
112    DMIN                | CATEGORY_DATABASE              | PHPExcel_Calculation_Database::DMIN
113    DOLLAR              | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::DOLLAR
114    DOLLARDE            | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::DOLLARDE
115    DOLLARFR            | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::DOLLARFR
116    DPRODUCT            | CATEGORY_DATABASE              | PHPExcel_Calculation_Database::DPRODUCT
117    DSTDEV              | CATEGORY_DATABASE              | PHPExcel_Calculation_Database::DSTDEV
118    DSTDEVP             | CATEGORY_DATABASE              | PHPExcel_Calculation_Database::DSTDEVP
119    DSUM                | CATEGORY_DATABASE              | PHPExcel_Calculation_Database::DSUM
120    DURATION            | CATEGORY_FINANCIAL             | **\*\*\*  Not yet Implemented**
121    DVAR                | CATEGORY_DATABASE              | PHPExcel_Calculation_Database::DVAR
122    DVARP               | CATEGORY_DATABASE              | PHPExcel_Calculation_Database::DVARP
123
124#E
125
126    Excel Function      | Category                       | PHPExcel Function
127    --------------------|--------------------------------|-------------------------------------------
128    EDATE               | CATEGORY_DATE_AND_TIME         | PHPExcel_Calculation_DateTime::EDATE
129    EFFECT              | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::EFFECT
130    EOMONTH             | CATEGORY_DATE_AND_TIME         | PHPExcel_Calculation_DateTime::EOMONTH
131    ERF                 | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::ERF
132    ERFC                | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::ERFC
133    ERROR.TYPE          | CATEGORY_INFORMATION           | PHPExcel_Calculation_Functions::ERROR_TYPE
134    EVEN                | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::EVEN
135    EXACT               | CATEGORY_TEXT_AND_DATA         | **\*\*\*  Not yet Implemented**
136    EXP                 | CATEGORY_MATH_AND_TRIG         | exp
137    EXPONDIST           | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::EXPONDIST
138
139#F
140
141    Excel Function      | Category                       | PHPExcel Function
142    --------------------|--------------------------------|-------------------------------------------
143    FACT                | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::FACT
144    FACTDOUBLE          | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::FACTDOUBLE
145    FALSE               | CATEGORY_LOGICAL               | PHPExcel_Calculation_Logical::FALSE
146    FDIST               | CATEGORY_STATISTICAL           | **\*\*\*  Not yet Implemented**
147    FIND                | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::SEARCHSENSITIVE
148    FINDB               | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::SEARCHSENSITIVE
149    FINV                | CATEGORY_STATISTICAL           | **\*\*\*  Not yet Implemented**
150    FISHER              | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::FISHER
151    FISHERINV           | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::FISHERINV
152    FIXED               | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::FIXEDFORMAT
153    FLOOR               | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::FLOOR
154    FORECAST            | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::FORECAST
155    FREQUENCY           | CATEGORY_STATISTICAL           | **\*\*\*  Not yet Implemented**
156    FTEST               | CATEGORY_STATISTICAL           | **\*\*\*  Not yet Implemented**
157    FV                  | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::FV
158    FVSCHEDULE          | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::FVSCHEDULE
159
160#G
161
162    Excel Function      | Category                       | PHPExcel Function
163    --------------------|--------------------------------|-------------------------------------------
164    GAMMADIST           | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::GAMMADIST
165    GAMMAINV            | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::GAMMAINV
166    GAMMALN             | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::GAMMALN
167    GCD                 | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::GCD
168    GEOMEAN             | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::GEOMEAN
169    GESTEP              | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::GESTEP
170    GETPIVOTDATA        | CATEGORY_LOOKUP_AND_REFERENCE  | **\*\*\*  Not yet Implemented**
171    GROWTH              | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::GROWTH
172
173#H
174
175    Excel Function      | Category                       | PHPExcel Function
176    --------------------|--------------------------------|-------------------------------------------
177    HARMEAN             | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::HARMEAN
178    HEX2BIN             | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::HEXTOBIN
179    HEX2DEC             | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::HEXTODEC
180    HEX2OCT             | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::HEXTOOCT
181    HLOOKUP             | CATEGORY_LOOKUP_AND_REFERENCE  | **\*\*\*  Not yet Implemented**
182    HOUR                | CATEGORY_DATE_AND_TIME         | PHPExcel_Calculation_DateTime::HOUROFDAY
183    HYPERLINK           | CATEGORY_LOOKUP_AND_REFERENCE  | PHPExcel_Calculation_LookupRef::HYPERLINK
184    HYPGEOMDIST         | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::HYPGEOMDIST
185
186#I
187
188    Excel Function      | Category                       | PHPExcel Function
189    --------------------|--------------------------------|-------------------------------------------
190    IF                  | CATEGORY_LOGICAL               | PHPExcel_Calculation_Logical::STATEMENT_IF
191    IFERROR             | CATEGORY_LOGICAL               | PHPExcel_Calculation_Logical::IFERROR
192    IMABS               | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::IMABS
193    IMAGINARY           | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::IMAGINARY
194    IMARGUMENT          | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::IMARGUMENT
195    IMCONJUGATE         | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::IMCONJUGATE
196    IMCOS               | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::IMCOS
197    IMDIV               | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::IMDIV
198    IMEXP               | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::IMEXP
199    IMLN                | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::IMLN
200    IMLOG10             | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::IMLOG10
201    IMLOG2              | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::IMLOG2
202    IMPOWER             | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::IMPOWER
203    IMPRODUCT           | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::IMPRODUCT
204    IMREAL              | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::IMREAL
205    IMSIN               | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::IMSIN
206    IMSQRT              | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::IMSQRT
207    IMSUB               | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::IMSUB
208    IMSUM               | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::IMSUM
209    INDEX               | CATEGORY_LOOKUP_AND_REFERENCE  | PHPExcel_Calculation_LookupRef::INDEX
210    INDIRECT            | CATEGORY_LOOKUP_AND_REFERENCE  | PHPExcel_Calculation_LookupRef::INDIRECT
211    INFO                | CATEGORY_INFORMATION           | **\*\*\*  Not yet Implemented**
212    INT                 | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::INT
213    INTERCEPT           | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::INTERCEPT
214    INTRATE             | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::INTRATE
215    IPMT                | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::IPMT
216    IRR                 | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::IRR
217    ISBLANK             | CATEGORY_INFORMATION           | PHPExcel_Calculation_Functions::IS_BLANK
218    ISERR               | CATEGORY_INFORMATION           | PHPExcel_Calculation_Functions::IS_ERR
219    ISERROR             | CATEGORY_INFORMATION           | PHPExcel_Calculation_Functions::IS_ERROR
220    ISEVEN              | CATEGORY_INFORMATION           | PHPExcel_Calculation_Functions::IS_EVEN
221    ISLOGICAL           | CATEGORY_INFORMATION           | PHPExcel_Calculation_Functions::IS_LOGICAL
222    ISNA                | CATEGORY_INFORMATION           | PHPExcel_Calculation_Functions::IS_NA
223    ISNONTEXT           | CATEGORY_INFORMATION           | PHPExcel_Calculation_Functions::IS_NONTEXT
224    ISNUMBER            | CATEGORY_INFORMATION           | PHPExcel_Calculation_Functions::IS_NUMBER
225    ISODD               | CATEGORY_INFORMATION           | PHPExcel_Calculation_Functions::IS_ODD
226    ISPMT               | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::ISPMT
227    ISREF               | CATEGORY_INFORMATION           | **\*\*\*  Not yet Implemented**
228    ISTEXT              | CATEGORY_INFORMATION           | PHPExcel_Calculation_Functions::IS_TEXT
229
230#J
231
232    Excel Function      | Category                       | PHPExcel Function
233    --------------------|--------------------------------|-------------------------------------------
234    JIS                 | CATEGORY_TEXT_AND_DATA         | **\*\*\*  Not yet Implemented**
235
236#K
237
238    Excel Function      | Category                       | PHPExcel Function
239    --------------------|--------------------------------|-------------------------------------------
240    KURT                | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::KURT
241
242#L
243
244    Excel Function      | Category                       | PHPExcel Function
245    --------------------|--------------------------------|-------------------------------------------
246    LARGE               | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::LARGE
247    LCM                 | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::LCM
248    LEFT                | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::LEFT
249    LEFTB               | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::LEFT
250    LEN                 | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::STRINGLENGTH
251    LENB                | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::STRINGLENGTH
252    LINEST              | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::LINEST
253    LN                  | CATEGORY_MATH_AND_TRIG         | log
254    LOG                 | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::LOG_BASE
255    LOG10               | CATEGORY_MATH_AND_TRIG         | log10
256    LOGEST              | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::LOGEST
257    LOGINV              | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::LOGINV
258    LOGNORMDIST         | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::LOGNORMDIST
259    LOOKUP              | CATEGORY_LOOKUP_AND_REFERENCE  | PHPExcel_Calculation_LookupRef::LOOKUP
260    LOWER               | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::LOWERCASE
261
262#M
263
264    Excel Function      | Category                       | PHPExcel Function
265    --------------------|--------------------------------|-------------------------------------------
266    MATCH               | CATEGORY_LOOKUP_AND_REFERENCE  | PHPExcel_Calculation_LookupRef::MATCH
267    MAX                 | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::MAX
268    MAXA                | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::MAXA
269    MAXIF               | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::MAXIF
270    MDETERM             | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::MDETERM
271    MDURATION           | CATEGORY_FINANCIAL             | **\*\*\*  Not yet Implemented**
272    MEDIAN              | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::MEDIAN
273    MEDIANIF            | CATEGORY_STATISTICAL           | **\*\*\*  Not yet Implemented**
274    MID                 | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::MID
275    MIDB                | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::MID
276    MIN                 | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::MIN
277    MINA                | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::MINA
278    MINIF               | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::MINIF
279    MINUTE              | CATEGORY_DATE_AND_TIME         | PHPExcel_Calculation_DateTime::MINUTEOFHOUR
280    MINVERSE            | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::MINVERSE
281    MIRR                | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::MIRR
282    MMULT               | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::MMULT
283    MOD                 | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::MOD
284    MODE                | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::MODE
285    MONTH               | CATEGORY_DATE_AND_TIME         | PHPExcel_Calculation_DateTime::MONTHOFYEAR
286    MROUND              | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::MROUND
287    MULTINOMIAL         | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::MULTINOMIAL
288
289#N
290
291    Excel Function      | Category                       | PHPExcel Function
292    --------------------|--------------------------------|-------------------------------------------
293    N                   | CATEGORY_INFORMATION           | PHPExcel_Calculation_Functions::N
294    NA                  | CATEGORY_INFORMATION           | PHPExcel_Calculation_Functions::NA
295    NEGBINOMDIST        | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::NEGBINOMDIST
296    NETWORKDAYS         | CATEGORY_DATE_AND_TIME         | PHPExcel_Calculation_DateTime::NETWORKDAYS
297    NOMINAL             | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::NOMINAL
298    NORMDIST            | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::NORMDIST
299    NORMINV             | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::NORMINV
300    NORMSDIST           | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::NORMSDIST
301    NORMSINV            | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::NORMSINV
302    NOT                 | CATEGORY_LOGICAL               | PHPExcel_Calculation_Logical::NOT
303    NOW                 | CATEGORY_DATE_AND_TIME         | PHPExcel_Calculation_DateTime::DATETIMENOW
304    NPER                | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::NPER
305    NPV                 | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::NPV
306
307#O
308
309    Excel Function      | Category                       | PHPExcel Function
310    --------------------|--------------------------------|-------------------------------------------
311    OCT2BIN             | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::OCTTOBIN
312    OCT2DEC             | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::OCTTODEC
313    OCT2HEX             | CATEGORY_ENGINEERING           | PHPExcel_Calculation_Engineering::OCTTOHEX
314    ODD                 | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::ODD
315    ODDFPRICE           | CATEGORY_FINANCIAL             | **\*\*\*  Not yet Implemented**
316    ODDFYIELD           | CATEGORY_FINANCIAL             | **\*\*\*  Not yet Implemented**
317    ODDLPRICE           | CATEGORY_FINANCIAL             | **\*\*\*  Not yet Implemented**
318    ODDLYIELD           | CATEGORY_FINANCIAL             | **\*\*\*  Not yet Implemented**
319    OFFSET              | CATEGORY_LOOKUP_AND_REFERENCE  | PHPExcel_Calculation_LookupRef::OFFSET
320    OR                  | CATEGORY_LOGICAL               | PHPExcel_Calculation_Logical::LOGICAL_OR
321
322#P
323
324    Excel Function      | Category                       | PHPExcel Function
325    --------------------|--------------------------------|-------------------------------------------
326    PEARSON             | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::CORREL
327    PERCENTILE          | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::PERCENTILE
328    PERCENTRANK         | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::PERCENTRANK
329    PERMUT              | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::PERMUT
330    PHONETIC            | CATEGORY_TEXT_AND_DATA         | **\*\*\*  Not yet Implemented**
331    PI                  | CATEGORY_MATH_AND_TRIG         | pi
332    PMT                 | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::PMT
333    POISSON             | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::POISSON
334    POWER               | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::POWER
335    PPMT                | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::PPMT
336    PRICE               | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::PRICE
337    PRICEDISC           | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::PRICEDISC
338    PRICEMAT            | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::PRICEMAT
339    PROB                | CATEGORY_STATISTICAL           | **\*\*\*  Not yet Implemented**
340    PRODUCT             | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::PRODUCT
341    PROPER              | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::PROPERCASE
342    PV                  | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::PV
343
344#Q
345
346    Excel Function      | Category                       | PHPExcel Function
347    --------------------|--------------------------------|-------------------------------------------
348    QUARTILE            | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::QUARTILE
349    QUOTIENT            | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::QUOTIENT
350
351#R
352
353    Excel Function      | Category                       | PHPExcel Function
354    --------------------|--------------------------------|-------------------------------------------
355    RADIANS             | CATEGORY_MATH_AND_TRIG         | deg2rad
356    RAND                | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::RAND
357    RANDBETWEEN         | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::RAND
358    RANK                | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::RANK
359    RATE                | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::RATE
360    RECEIVED            | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::RECEIVED
361    REPLACE             | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::REPLACE
362    REPLACEB            | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::REPLACE
363    REPT                | CATEGORY_TEXT_AND_DATA         | str_repeat
364    RIGHT               | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::RIGHT
365    RIGHTB              | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::RIGHT
366    ROMAN               | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::ROMAN
367    ROUND               | CATEGORY_MATH_AND_TRIG         | round
368    ROUNDDOWN           | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::ROUNDDOWN
369    ROUNDUP             | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::ROUNDUP
370    ROW                 | CATEGORY_LOOKUP_AND_REFERENCE  | PHPExcel_Calculation_LookupRef::ROW
371    ROWS                | CATEGORY_LOOKUP_AND_REFERENCE  | PHPExcel_Calculation_LookupRef::ROWS
372    RSQ                 | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::RSQ
373    RTD                 | CATEGORY_LOOKUP_AND_REFERENCE  | **\*\*\*  Not yet Implemented**
374
375#S
376
377    Excel Function      | Category                       | PHPExcel Function
378    --------------------|--------------------------------|-------------------------------------------
379    SEARCH              | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::SEARCHINSENSITIVE
380    SEARCHB             | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::SEARCHINSENSITIVE
381    SECOND              | CATEGORY_DATE_AND_TIME         | PHPExcel_Calculation_DateTime::SECONDOFMINUTE
382    SERIESSUM           | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::SERIESSUM
383    SIGN                | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::SIGN
384    SIN                 | CATEGORY_MATH_AND_TRIG         | sin
385    SINH                | CATEGORY_MATH_AND_TRIG         | sinh
386    SKEW                | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::SKEW
387    SLN                 | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::SLN
388    SLOPE               | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::SLOPE
389    SMALL               | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::SMALL
390    SQRT                | CATEGORY_MATH_AND_TRIG         | sqrt
391    SQRTPI              | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::SQRTPI
392    STANDARDIZE         | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::STANDARDIZE
393    STDEV               | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::STDEV
394    STDEVA              | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::STDEVA
395    STDEVP              | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::STDEVP
396    STDEVPA             | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::STDEVPA
397    STEYX               | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::STEYX
398    SUBSTITUTE          | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::SUBSTITUTE
399    SUBTOTAL            | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::SUBTOTAL
400    SUM                 | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::SUM
401    SUMIF               | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::SUMIF
402    SUMIFS              | CATEGORY_MATH_AND_TRIG         | **\*\*\*  Not yet Implemented**
403    SUMPRODUCT          | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::SUMPRODUCT
404    SUMSQ               | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::SUMSQ
405    SUMX2MY2            | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::SUMX2MY2
406    SUMX2PY2            | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::SUMX2PY2
407    SUMXMY2             | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::SUMXMY2
408    SYD                 | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::SYD
409
410#T
411
412    Excel Function      | Category                       | PHPExcel Function
413    --------------------|--------------------------------|-------------------------------------------
414    T                   | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::RETURNSTRING
415    TAN                 | CATEGORY_MATH_AND_TRIG         | tan
416    TANH                | CATEGORY_MATH_AND_TRIG         | tanh
417    TBILLEQ             | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::TBILLEQ
418    TBILLPRICE          | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::TBILLPRICE
419    TBILLYIELD          | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::TBILLYIELD
420    TDIST               | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::TDIST
421    TEXT                | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::TEXTFORMAT
422    TIME                | CATEGORY_DATE_AND_TIME         | PHPExcel_Calculation_DateTime::TIME
423    TIMEVALUE           | CATEGORY_DATE_AND_TIME         | PHPExcel_Calculation_DateTime::TIMEVALUE
424    TINV                | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::TINV
425    TODAY               | CATEGORY_DATE_AND_TIME         | PHPExcel_Calculation_DateTime::DATENOW
426    TRANSPOSE           | CATEGORY_LOOKUP_AND_REFERENCE  | PHPExcel_Calculation_LookupRef::TRANSPOSE
427    TREND               | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::TREND
428    TRIM                | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::TRIMSPACES
429    TRIMMEAN            | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::TRIMMEAN
430    TRUE                | CATEGORY_LOGICAL               | PHPExcel_Calculation_Logical::TRUE
431    TRUNC               | CATEGORY_MATH_AND_TRIG         | PHPExcel_Calculation_MathTrig::TRUNC
432    TTEST               | CATEGORY_STATISTICAL           | **\*\*\*  Not yet Implemented**
433    TYPE                | CATEGORY_INFORMATION           | PHPExcel_Calculation_Functions::TYPE
434
435#U
436
437    Excel Function      | Category                       | PHPExcel Function
438    --------------------|--------------------------------|-------------------------------------------
439    UPPER               | CATEGORY_TEXT_AND_DATA         | PHPExcel_Calculation_TextData::UPPERCASE
440    USDOLLAR            | CATEGORY_FINANCIAL             | **\*\*\*  Not yet Implemented**
441
442#V
443
444    Excel Function      | Category                       | PHPExcel Function
445    --------------------|--------------------------------|-------------------------------------------
446    VALUE               | CATEGORY_TEXT_AND_DATA         | **\*\*\*  Not yet Implemented**
447    VAR                 | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::VARFunc
448    VARA                | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::VARA
449    VARP                | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::VARP
450    VARPA               | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::VARPA
451    VDB                 | CATEGORY_FINANCIAL             | **\*\*\*  Not yet Implemented**
452    VERSION             | CATEGORY_INFORMATION           | PHPExcel_Calculation_Functions::VERSION
453    VLOOKUP             | CATEGORY_LOOKUP_AND_REFERENCE  | PHPExcel_Calculation_LookupRef::VLOOKUP
454
455#W
456
457    Excel Function      | Category                       | PHPExcel Function
458    --------------------|--------------------------------|-------------------------------------------
459    WEEKDAY             | CATEGORY_DATE_AND_TIME         | PHPExcel_Calculation_DateTime::DAYOFWEEK
460    WEEKNUM             | CATEGORY_DATE_AND_TIME         | PHPExcel_Calculation_DateTime::WEEKOFYEAR
461    WEIBULL             | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::WEIBULL
462    WORKDAY             | CATEGORY_DATE_AND_TIME         | PHPExcel_Calculation_DateTime::WORKDAY
463
464#X
465
466    Excel Function      | Category                       | PHPExcel Function
467    --------------------|--------------------------------|-------------------------------------------
468    XIRR                | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::XIRR
469    XNPV                | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::XNPV
470
471#Y
472
473    Excel Function      | Category                       | PHPExcel Function
474    --------------------|--------------------------------|-------------------------------------------
475    YEAR                | CATEGORY_DATE_AND_TIME         | PHPExcel_Calculation_DateTime::YEAR
476    YEARFRAC            | CATEGORY_DATE_AND_TIME         | PHPExcel_Calculation_DateTime::YEARFRAC
477    YIELD               | CATEGORY_FINANCIAL             | **\*\*\*  Not yet Implemented**
478    YIELDDISC           | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::YIELDDISC
479    YIELDMAT            | CATEGORY_FINANCIAL             | PHPExcel_Calculation_Financial::YIELDMAT
480
481#Z
482
483    Excel Function      | Category                       | PHPExcel Function
484    --------------------|--------------------------------|-------------------------------------------
485    ZTEST               | CATEGORY_STATISTICAL           | PHPExcel_Calculation_Statistical::ZTEST
486