D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
shubmkcj
/
urbane.createerp.com
/
PHPExcel
/
Documentation
/
markdown
/
Functions
/
Filename :
FunctionListByName.md
back
Copy
#A Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- ABS | CATEGORY_MATH_AND_TRIG | abs ACCRINT | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::ACCRINT ACCRINTM | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::ACCRINTM ACOS | CATEGORY_MATH_AND_TRIG | acos ACOSH | CATEGORY_MATH_AND_TRIG | acosh ADDRESS | CATEGORY_LOOKUP_AND_REFERENCE | PHPExcel_Calculation_LookupRef::CELL_ADDRESS AMORDEGRC | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::AMORDEGRC AMORLINC | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::AMORLINC AND | CATEGORY_LOGICAL | PHPExcel_Calculation_Logical::LOGICAL_AND AREAS | CATEGORY_LOOKUP_AND_REFERENCE | **\*\*\* Not yet Implemented** ASC | CATEGORY_TEXT_AND_DATA | **\*\*\* Not yet Implemented** ASIN | CATEGORY_MATH_AND_TRIG | asin ASINH | CATEGORY_MATH_AND_TRIG | asinh ATAN | CATEGORY_MATH_AND_TRIG | atan ATAN2 | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::REVERSE_ATAN2 ATANH | CATEGORY_MATH_AND_TRIG | atanh AVEDEV | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::AVEDEV AVERAGE | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::AVERAGE AVERAGEA | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::AVERAGEA AVERAGEIF | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::AVERAGEIF AVERAGEIFS | CATEGORY_STATISTICAL | **\*\*\* Not yet Implemented** #B Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- BAHTTEXT | CATEGORY_TEXT_AND_DATA | **\*\*\* Not yet Implemented** BESSELI | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::BESSELI BESSELJ | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::BESSELJ BESSELK | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::BESSELK BESSELY | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::BESSELY BETADIST | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::BETADIST BETAINV | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::BETAINV BIN2DEC | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::BINTODEC BIN2HEX | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::BINTOHEX BIN2OCT | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::BINTOOCT BINOMDIST | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::BINOMDIST #C Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- CEILING | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::CEILING CELL | CATEGORY_INFORMATION | **\*\*\* Not yet Implemented** CHAR | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::CHARACTER CHIDIST | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::CHIDIST CHIINV | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::CHIINV CHITEST | CATEGORY_STATISTICAL | **\*\*\* Not yet Implemented** CHOOSE | CATEGORY_LOOKUP_AND_REFERENCE | PHPExcel_Calculation_LookupRef::CHOOSE CLEAN | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::TRIMNONPRINTABLE CODE | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::ASCIICODE COLUMN | CATEGORY_LOOKUP_AND_REFERENCE | PHPExcel_Calculation_LookupRef::COLUMN COLUMNS | CATEGORY_LOOKUP_AND_REFERENCE | PHPExcel_Calculation_LookupRef::COLUMNS COMBIN | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::COMBIN COMPLEX | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::COMPLEX CONCATENATE | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::CONCATENATE CONFIDENCE | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::CONFIDENCE CONVERT | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::CONVERTUOM CORREL | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::CORREL COS | CATEGORY_MATH_AND_TRIG | cos COSH | CATEGORY_MATH_AND_TRIG | cosh COUNT | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::COUNT COUNTA | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::COUNTA COUNTBLANK | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::COUNTBLANK COUNTIF | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::COUNTIF COUNTIFS | CATEGORY_STATISTICAL | **\*\*\* Not yet Implemented** COUPDAYBS | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::COUPDAYBS COUPDAYS | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::COUPDAYS COUPDAYSNC | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::COUPDAYSNC COUPNCD | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::COUPNCD COUPNUM | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::COUPNUM COUPPCD | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::COUPPCD COVAR | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::COVAR CRITBINOM | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::CRITBINOM CUBEKPIMEMBER | CATEGORY_CUBE | **\*\*\* Not yet Implemented** CUBEMEMBER | CATEGORY_CUBE | **\*\*\* Not yet Implemented** CUBEMEMBERPROPERTY | CATEGORY_CUBE | **\*\*\* Not yet Implemented** CUBERANKEDMEMBER | CATEGORY_CUBE | **\*\*\* Not yet Implemented** CUBESET | CATEGORY_CUBE | **\*\*\* Not yet Implemented** CUBESETCOUNT | CATEGORY_CUBE | **\*\*\* Not yet Implemented** CUBEVALUE | CATEGORY_CUBE | **\*\*\* Not yet Implemented** CUMIPMT | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::CUMIPMT CUMPRINC | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::CUMPRINC #D Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- DATE | CATEGORY_DATE_AND_TIME | PHPExcel_Calculation_DateTime::DATE DATEDIF | CATEGORY_DATE_AND_TIME | PHPExcel_Calculation_DateTime::DATEDIF DATEVALUE | CATEGORY_DATE_AND_TIME | PHPExcel_Calculation_DateTime::DATEVALUE DAVERAGE | CATEGORY_DATABASE | PHPExcel_Calculation_Database::DAVERAGE DAY | CATEGORY_DATE_AND_TIME | PHPExcel_Calculation_DateTime::DAYOFMONTH DAYS360 | CATEGORY_DATE_AND_TIME | PHPExcel_Calculation_DateTime::DAYS360 DB | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::DB DCOUNT | CATEGORY_DATABASE | PHPExcel_Calculation_Database::DCOUNT DCOUNTA | CATEGORY_DATABASE | PHPExcel_Calculation_Database::DCOUNTA DDB | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::DDB DEC2BIN | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::DECTOBIN DEC2HEX | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::DECTOHEX DEC2OCT | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::DECTOOCT DEGREES | CATEGORY_MATH_AND_TRIG | rad2deg DELTA | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::DELTA DEVSQ | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::DEVSQ DGET | CATEGORY_DATABASE | PHPExcel_Calculation_Database::DGET DISC | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::DISC DMAX | CATEGORY_DATABASE | PHPExcel_Calculation_Database::DMAX DMIN | CATEGORY_DATABASE | PHPExcel_Calculation_Database::DMIN DOLLAR | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::DOLLAR DOLLARDE | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::DOLLARDE DOLLARFR | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::DOLLARFR DPRODUCT | CATEGORY_DATABASE | PHPExcel_Calculation_Database::DPRODUCT DSTDEV | CATEGORY_DATABASE | PHPExcel_Calculation_Database::DSTDEV DSTDEVP | CATEGORY_DATABASE | PHPExcel_Calculation_Database::DSTDEVP DSUM | CATEGORY_DATABASE | PHPExcel_Calculation_Database::DSUM DURATION | CATEGORY_FINANCIAL | **\*\*\* Not yet Implemented** DVAR | CATEGORY_DATABASE | PHPExcel_Calculation_Database::DVAR DVARP | CATEGORY_DATABASE | PHPExcel_Calculation_Database::DVARP #E Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- EDATE | CATEGORY_DATE_AND_TIME | PHPExcel_Calculation_DateTime::EDATE EFFECT | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::EFFECT EOMONTH | CATEGORY_DATE_AND_TIME | PHPExcel_Calculation_DateTime::EOMONTH ERF | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::ERF ERFC | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::ERFC ERROR.TYPE | CATEGORY_INFORMATION | PHPExcel_Calculation_Functions::ERROR_TYPE EVEN | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::EVEN EXACT | CATEGORY_TEXT_AND_DATA | **\*\*\* Not yet Implemented** EXP | CATEGORY_MATH_AND_TRIG | exp EXPONDIST | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::EXPONDIST #F Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- FACT | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::FACT FACTDOUBLE | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::FACTDOUBLE FALSE | CATEGORY_LOGICAL | PHPExcel_Calculation_Logical::FALSE FDIST | CATEGORY_STATISTICAL | **\*\*\* Not yet Implemented** FIND | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::SEARCHSENSITIVE FINDB | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::SEARCHSENSITIVE FINV | CATEGORY_STATISTICAL | **\*\*\* Not yet Implemented** FISHER | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::FISHER FISHERINV | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::FISHERINV FIXED | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::FIXEDFORMAT FLOOR | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::FLOOR FORECAST | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::FORECAST FREQUENCY | CATEGORY_STATISTICAL | **\*\*\* Not yet Implemented** FTEST | CATEGORY_STATISTICAL | **\*\*\* Not yet Implemented** FV | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::FV FVSCHEDULE | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::FVSCHEDULE #G Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- GAMMADIST | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::GAMMADIST GAMMAINV | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::GAMMAINV GAMMALN | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::GAMMALN GCD | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::GCD GEOMEAN | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::GEOMEAN GESTEP | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::GESTEP GETPIVOTDATA | CATEGORY_LOOKUP_AND_REFERENCE | **\*\*\* Not yet Implemented** GROWTH | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::GROWTH #H Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- HARMEAN | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::HARMEAN HEX2BIN | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::HEXTOBIN HEX2DEC | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::HEXTODEC HEX2OCT | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::HEXTOOCT HLOOKUP | CATEGORY_LOOKUP_AND_REFERENCE | **\*\*\* Not yet Implemented** HOUR | CATEGORY_DATE_AND_TIME | PHPExcel_Calculation_DateTime::HOUROFDAY HYPERLINK | CATEGORY_LOOKUP_AND_REFERENCE | PHPExcel_Calculation_LookupRef::HYPERLINK HYPGEOMDIST | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::HYPGEOMDIST #I Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- IF | CATEGORY_LOGICAL | PHPExcel_Calculation_Logical::STATEMENT_IF IFERROR | CATEGORY_LOGICAL | PHPExcel_Calculation_Logical::IFERROR IMABS | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::IMABS IMAGINARY | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::IMAGINARY IMARGUMENT | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::IMARGUMENT IMCONJUGATE | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::IMCONJUGATE IMCOS | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::IMCOS IMDIV | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::IMDIV IMEXP | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::IMEXP IMLN | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::IMLN IMLOG10 | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::IMLOG10 IMLOG2 | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::IMLOG2 IMPOWER | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::IMPOWER IMPRODUCT | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::IMPRODUCT IMREAL | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::IMREAL IMSIN | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::IMSIN IMSQRT | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::IMSQRT IMSUB | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::IMSUB IMSUM | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::IMSUM INDEX | CATEGORY_LOOKUP_AND_REFERENCE | PHPExcel_Calculation_LookupRef::INDEX INDIRECT | CATEGORY_LOOKUP_AND_REFERENCE | PHPExcel_Calculation_LookupRef::INDIRECT INFO | CATEGORY_INFORMATION | **\*\*\* Not yet Implemented** INT | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::INT INTERCEPT | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::INTERCEPT INTRATE | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::INTRATE IPMT | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::IPMT IRR | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::IRR ISBLANK | CATEGORY_INFORMATION | PHPExcel_Calculation_Functions::IS_BLANK ISERR | CATEGORY_INFORMATION | PHPExcel_Calculation_Functions::IS_ERR ISERROR | CATEGORY_INFORMATION | PHPExcel_Calculation_Functions::IS_ERROR ISEVEN | CATEGORY_INFORMATION | PHPExcel_Calculation_Functions::IS_EVEN ISLOGICAL | CATEGORY_INFORMATION | PHPExcel_Calculation_Functions::IS_LOGICAL ISNA | CATEGORY_INFORMATION | PHPExcel_Calculation_Functions::IS_NA ISNONTEXT | CATEGORY_INFORMATION | PHPExcel_Calculation_Functions::IS_NONTEXT ISNUMBER | CATEGORY_INFORMATION | PHPExcel_Calculation_Functions::IS_NUMBER ISODD | CATEGORY_INFORMATION | PHPExcel_Calculation_Functions::IS_ODD ISPMT | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::ISPMT ISREF | CATEGORY_INFORMATION | **\*\*\* Not yet Implemented** ISTEXT | CATEGORY_INFORMATION | PHPExcel_Calculation_Functions::IS_TEXT #J Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- JIS | CATEGORY_TEXT_AND_DATA | **\*\*\* Not yet Implemented** #K Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- KURT | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::KURT #L Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- LARGE | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::LARGE LCM | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::LCM LEFT | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::LEFT LEFTB | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::LEFT LEN | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::STRINGLENGTH LENB | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::STRINGLENGTH LINEST | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::LINEST LN | CATEGORY_MATH_AND_TRIG | log LOG | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::LOG_BASE LOG10 | CATEGORY_MATH_AND_TRIG | log10 LOGEST | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::LOGEST LOGINV | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::LOGINV LOGNORMDIST | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::LOGNORMDIST LOOKUP | CATEGORY_LOOKUP_AND_REFERENCE | PHPExcel_Calculation_LookupRef::LOOKUP LOWER | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::LOWERCASE #M Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- MATCH | CATEGORY_LOOKUP_AND_REFERENCE | PHPExcel_Calculation_LookupRef::MATCH MAX | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::MAX MAXA | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::MAXA MAXIF | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::MAXIF MDETERM | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::MDETERM MDURATION | CATEGORY_FINANCIAL | **\*\*\* Not yet Implemented** MEDIAN | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::MEDIAN MEDIANIF | CATEGORY_STATISTICAL | **\*\*\* Not yet Implemented** MID | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::MID MIDB | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::MID MIN | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::MIN MINA | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::MINA MINIF | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::MINIF MINUTE | CATEGORY_DATE_AND_TIME | PHPExcel_Calculation_DateTime::MINUTEOFHOUR MINVERSE | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::MINVERSE MIRR | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::MIRR MMULT | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::MMULT MOD | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::MOD MODE | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::MODE MONTH | CATEGORY_DATE_AND_TIME | PHPExcel_Calculation_DateTime::MONTHOFYEAR MROUND | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::MROUND MULTINOMIAL | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::MULTINOMIAL #N Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- N | CATEGORY_INFORMATION | PHPExcel_Calculation_Functions::N NA | CATEGORY_INFORMATION | PHPExcel_Calculation_Functions::NA NEGBINOMDIST | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::NEGBINOMDIST NETWORKDAYS | CATEGORY_DATE_AND_TIME | PHPExcel_Calculation_DateTime::NETWORKDAYS NOMINAL | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::NOMINAL NORMDIST | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::NORMDIST NORMINV | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::NORMINV NORMSDIST | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::NORMSDIST NORMSINV | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::NORMSINV NOT | CATEGORY_LOGICAL | PHPExcel_Calculation_Logical::NOT NOW | CATEGORY_DATE_AND_TIME | PHPExcel_Calculation_DateTime::DATETIMENOW NPER | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::NPER NPV | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::NPV #O Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- OCT2BIN | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::OCTTOBIN OCT2DEC | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::OCTTODEC OCT2HEX | CATEGORY_ENGINEERING | PHPExcel_Calculation_Engineering::OCTTOHEX ODD | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::ODD ODDFPRICE | CATEGORY_FINANCIAL | **\*\*\* Not yet Implemented** ODDFYIELD | CATEGORY_FINANCIAL | **\*\*\* Not yet Implemented** ODDLPRICE | CATEGORY_FINANCIAL | **\*\*\* Not yet Implemented** ODDLYIELD | CATEGORY_FINANCIAL | **\*\*\* Not yet Implemented** OFFSET | CATEGORY_LOOKUP_AND_REFERENCE | PHPExcel_Calculation_LookupRef::OFFSET OR | CATEGORY_LOGICAL | PHPExcel_Calculation_Logical::LOGICAL_OR #P Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- PEARSON | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::CORREL PERCENTILE | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::PERCENTILE PERCENTRANK | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::PERCENTRANK PERMUT | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::PERMUT PHONETIC | CATEGORY_TEXT_AND_DATA | **\*\*\* Not yet Implemented** PI | CATEGORY_MATH_AND_TRIG | pi PMT | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::PMT POISSON | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::POISSON POWER | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::POWER PPMT | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::PPMT PRICE | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::PRICE PRICEDISC | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::PRICEDISC PRICEMAT | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::PRICEMAT PROB | CATEGORY_STATISTICAL | **\*\*\* Not yet Implemented** PRODUCT | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::PRODUCT PROPER | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::PROPERCASE PV | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::PV #Q Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- QUARTILE | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::QUARTILE QUOTIENT | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::QUOTIENT #R Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- RADIANS | CATEGORY_MATH_AND_TRIG | deg2rad RAND | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::RAND RANDBETWEEN | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::RAND RANK | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::RANK RATE | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::RATE RECEIVED | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::RECEIVED REPLACE | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::REPLACE REPLACEB | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::REPLACE REPT | CATEGORY_TEXT_AND_DATA | str_repeat RIGHT | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::RIGHT RIGHTB | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::RIGHT ROMAN | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::ROMAN ROUND | CATEGORY_MATH_AND_TRIG | round ROUNDDOWN | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::ROUNDDOWN ROUNDUP | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::ROUNDUP ROW | CATEGORY_LOOKUP_AND_REFERENCE | PHPExcel_Calculation_LookupRef::ROW ROWS | CATEGORY_LOOKUP_AND_REFERENCE | PHPExcel_Calculation_LookupRef::ROWS RSQ | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::RSQ RTD | CATEGORY_LOOKUP_AND_REFERENCE | **\*\*\* Not yet Implemented** #S Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- SEARCH | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::SEARCHINSENSITIVE SEARCHB | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::SEARCHINSENSITIVE SECOND | CATEGORY_DATE_AND_TIME | PHPExcel_Calculation_DateTime::SECONDOFMINUTE SERIESSUM | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::SERIESSUM SIGN | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::SIGN SIN | CATEGORY_MATH_AND_TRIG | sin SINH | CATEGORY_MATH_AND_TRIG | sinh SKEW | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::SKEW SLN | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::SLN SLOPE | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::SLOPE SMALL | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::SMALL SQRT | CATEGORY_MATH_AND_TRIG | sqrt SQRTPI | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::SQRTPI STANDARDIZE | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::STANDARDIZE STDEV | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::STDEV STDEVA | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::STDEVA STDEVP | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::STDEVP STDEVPA | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::STDEVPA STEYX | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::STEYX SUBSTITUTE | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::SUBSTITUTE SUBTOTAL | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::SUBTOTAL SUM | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::SUM SUMIF | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::SUMIF SUMIFS | CATEGORY_MATH_AND_TRIG | **\*\*\* Not yet Implemented** SUMPRODUCT | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::SUMPRODUCT SUMSQ | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::SUMSQ SUMX2MY2 | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::SUMX2MY2 SUMX2PY2 | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::SUMX2PY2 SUMXMY2 | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::SUMXMY2 SYD | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::SYD #T Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- T | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::RETURNSTRING TAN | CATEGORY_MATH_AND_TRIG | tan TANH | CATEGORY_MATH_AND_TRIG | tanh TBILLEQ | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::TBILLEQ TBILLPRICE | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::TBILLPRICE TBILLYIELD | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::TBILLYIELD TDIST | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::TDIST TEXT | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::TEXTFORMAT TIME | CATEGORY_DATE_AND_TIME | PHPExcel_Calculation_DateTime::TIME TIMEVALUE | CATEGORY_DATE_AND_TIME | PHPExcel_Calculation_DateTime::TIMEVALUE TINV | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::TINV TODAY | CATEGORY_DATE_AND_TIME | PHPExcel_Calculation_DateTime::DATENOW TRANSPOSE | CATEGORY_LOOKUP_AND_REFERENCE | PHPExcel_Calculation_LookupRef::TRANSPOSE TREND | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::TREND TRIM | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::TRIMSPACES TRIMMEAN | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::TRIMMEAN TRUE | CATEGORY_LOGICAL | PHPExcel_Calculation_Logical::TRUE TRUNC | CATEGORY_MATH_AND_TRIG | PHPExcel_Calculation_MathTrig::TRUNC TTEST | CATEGORY_STATISTICAL | **\*\*\* Not yet Implemented** TYPE | CATEGORY_INFORMATION | PHPExcel_Calculation_Functions::TYPE #U Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- UPPER | CATEGORY_TEXT_AND_DATA | PHPExcel_Calculation_TextData::UPPERCASE USDOLLAR | CATEGORY_FINANCIAL | **\*\*\* Not yet Implemented** #V Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- VALUE | CATEGORY_TEXT_AND_DATA | **\*\*\* Not yet Implemented** VAR | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::VARFunc VARA | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::VARA VARP | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::VARP VARPA | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::VARPA VDB | CATEGORY_FINANCIAL | **\*\*\* Not yet Implemented** VERSION | CATEGORY_INFORMATION | PHPExcel_Calculation_Functions::VERSION VLOOKUP | CATEGORY_LOOKUP_AND_REFERENCE | PHPExcel_Calculation_LookupRef::VLOOKUP #W Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- WEEKDAY | CATEGORY_DATE_AND_TIME | PHPExcel_Calculation_DateTime::DAYOFWEEK WEEKNUM | CATEGORY_DATE_AND_TIME | PHPExcel_Calculation_DateTime::WEEKOFYEAR WEIBULL | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::WEIBULL WORKDAY | CATEGORY_DATE_AND_TIME | PHPExcel_Calculation_DateTime::WORKDAY #X Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- XIRR | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::XIRR XNPV | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::XNPV #Y Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- YEAR | CATEGORY_DATE_AND_TIME | PHPExcel_Calculation_DateTime::YEAR YEARFRAC | CATEGORY_DATE_AND_TIME | PHPExcel_Calculation_DateTime::YEARFRAC YIELD | CATEGORY_FINANCIAL | **\*\*\* Not yet Implemented** YIELDDISC | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::YIELDDISC YIELDMAT | CATEGORY_FINANCIAL | PHPExcel_Calculation_Financial::YIELDMAT #Z Excel Function | Category | PHPExcel Function --------------------|--------------------------------|------------------------------------------- ZTEST | CATEGORY_STATISTICAL | PHPExcel_Calculation_Statistical::ZTEST