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