Function list by name compact
Category should be prefixed by CATEGORY_ to match the values in \PhpOffice\PhpSpreadsheet\Calculation\Category
Function should be prefixed by PhpOffice\PhpSpreadsheet\Calculation\
A less compact list can be found here
A
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| ABS | MATH_AND_TRIG | MathTrig\Absolute::evaluate |
| ACCRINT | FINANCIAL | Financial\Securities\AccruedInterest::periodic |
| ACCRINTM | FINANCIAL | Financial\Securities\AccruedInterest::atMaturity |
| ACOS | MATH_AND_TRIG | MathTrig\Trig\Cosine::acos |
| ACOSH | MATH_AND_TRIG | MathTrig\Trig\Cosine::acosh |
| ACOT | MATH_AND_TRIG | MathTrig\Trig\Cotangent::acot |
| ACOTH | MATH_AND_TRIG | MathTrig\Trig\Cotangent::acoth |
| ADDRESS | LOOKUP_AND_REFERENCE | LookupRef\Address::cell |
| AGGREGATE | MATH_AND_TRIG | Not yet Implemented |
| AMORDEGRC | FINANCIAL | Financial\Amortization::AMORDEGRC |
| AMORLINC | FINANCIAL | Financial\Amortization::AMORLINC |
| ANCHORARRAY | MICROSOFT_INTERNAL | Internal\ExcelArrayPseudoFunctions::anchorArray |
| AND | LOGICAL | Logical\Operations::logicalAnd |
| ARABIC | MATH_AND_TRIG | MathTrig\Arabic::evaluate |
| AREAS | LOOKUP_AND_REFERENCE | Not yet Implemented |
| ARRAYTOTEXT | TEXT_AND_DATA | TextData\Text::fromArray |
| ASC | TEXT_AND_DATA | Not yet Implemented |
| ASIN | MATH_AND_TRIG | MathTrig\Trig\Sine::asin |
| ASINH | MATH_AND_TRIG | MathTrig\Trig\Sine::asinh |
| ATAN | MATH_AND_TRIG | MathTrig\Trig\Tangent::atan |
| ATAN2 | MATH_AND_TRIG | MathTrig\Trig\Tangent::atan2 |
| ATANH | MATH_AND_TRIG | MathTrig\Trig\Tangent::atanh |
| AVEDEV | STATISTICAL | Statistical\Averages::averageDeviations |
| AVERAGE | STATISTICAL | Statistical\Averages::average |
| AVERAGEA | STATISTICAL | Statistical\Averages::averageA |
| AVERAGEIF | STATISTICAL | Statistical\Conditional::AVERAGEIF |
| AVERAGEIFS | STATISTICAL | Statistical\Conditional::AVERAGEIFS |
B
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| BAHTTEXT | TEXT_AND_DATA | TextData\Thai::getBahtText |
| BASE | MATH_AND_TRIG | MathTrig\Base::evaluate |
| BESSELI | ENGINEERING | Engineering\BesselI::BESSELI |
| BESSELJ | ENGINEERING | Engineering\BesselJ::BESSELJ |
| BESSELK | ENGINEERING | Engineering\BesselK::BESSELK |
| BESSELY | ENGINEERING | Engineering\BesselY::BESSELY |
| BETA.DIST | STATISTICAL | Not yet Implemented |
| BETA.INV | STATISTICAL | Statistical\Distributions\Beta::inverse |
| BETADIST | STATISTICAL | Statistical\Distributions\Beta::distribution |
| BETAINV | STATISTICAL | Statistical\Distributions\Beta::inverse |
| BIN2DEC | ENGINEERING | Engineering\ConvertBinary::toDecimal |
| BIN2HEX | ENGINEERING | Engineering\ConvertBinary::toHex |
| BIN2OCT | ENGINEERING | Engineering\ConvertBinary::toOctal |
| BINOM.DIST | STATISTICAL | Statistical\Distributions\Binomial::distribution |
| BINOM.DIST.RANGE | STATISTICAL | Statistical\Distributions\Binomial::range |
| BINOM.INV | STATISTICAL | Statistical\Distributions\Binomial::inverse |
| BINOMDIST | STATISTICAL | Statistical\Distributions\Binomial::distribution |
| BITAND | ENGINEERING | Engineering\BitWise::BITAND |
| BITLSHIFT | ENGINEERING | Engineering\BitWise::BITLSHIFT |
| BITOR | ENGINEERING | Engineering\BitWise::BITOR |
| BITRSHIFT | ENGINEERING | Engineering\BitWise::BITRSHIFT |
| BITXOR | ENGINEERING | Engineering\BitWise::BITXOR |
| BYCOL | LOGICAL | Not yet Implemented |
| BYROW | LOGICAL | Not yet Implemented |
C
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| CEILING | MATH_AND_TRIG | MathTrig\Ceiling::ceiling |
| CEILING.MATH | MATH_AND_TRIG | MathTrig\Ceiling::math |
| CEILING.PRECISE | MATH_AND_TRIG | MathTrig\Ceiling::precise |
| CELL | INFORMATION | Not yet Implemented |
| CHAR | TEXT_AND_DATA | TextData\CharacterConvert::character |
| CHIDIST | STATISTICAL | Statistical\Distributions\ChiSquared::distributionRightTail |
| CHIINV | STATISTICAL | Statistical\Distributions\ChiSquared::inverseRightTail |
| CHISQ.DIST | STATISTICAL | Statistical\Distributions\ChiSquared::distributionLeftTail |
| CHISQ.DIST.RT | STATISTICAL | Statistical\Distributions\ChiSquared::distributionRightTail |
| CHISQ.INV | STATISTICAL | Statistical\Distributions\ChiSquared::inverseLeftTail |
| CHISQ.INV.RT | STATISTICAL | Statistical\Distributions\ChiSquared::inverseRightTail |
| CHISQ.TEST | STATISTICAL | Statistical\Distributions\ChiSquared::test |
| CHITEST | STATISTICAL | Statistical\Distributions\ChiSquared::test |
| CHOOSE | LOOKUP_AND_REFERENCE | LookupRef\Selection::CHOOSE |
| CHOOSECOLS | LOOKUP_AND_REFERENCE | LookupRef\ChooseRowsEtc::chooseCols |
| CHOOSEROWS | LOOKUP_AND_REFERENCE | LookupRef\ChooseRowsEtc::chooseRows |
| CLEAN | TEXT_AND_DATA | TextData\Trim::nonPrintable |
| CODE | TEXT_AND_DATA | TextData\CharacterConvert::code |
| COLUMN | LOOKUP_AND_REFERENCE | LookupRef\RowColumnInformation::COLUMN |
| COLUMNS | LOOKUP_AND_REFERENCE | LookupRef\RowColumnInformation::COLUMNS |
| COMBIN | MATH_AND_TRIG | MathTrig\Combinations::withoutRepetition |
| COMBINA | MATH_AND_TRIG | MathTrig\Combinations::withRepetition |
| COMPLEX | ENGINEERING | Engineering\Complex::COMPLEX |
| CONCAT | TEXT_AND_DATA | TextData\Concatenate::CONCATENATE |
| CONCATENATE | TEXT_AND_DATA | TextData\Concatenate::actualCONCATENATE |
| CONFIDENCE | STATISTICAL | Statistical\Confidence::CONFIDENCE |
| CONFIDENCE.NORM | STATISTICAL | Statistical\Confidence::CONFIDENCE |
| CONFIDENCE.T | STATISTICAL | Not yet Implemented |
| CONVERT | ENGINEERING | Engineering\ConvertUOM::CONVERT |
| CORREL | STATISTICAL | Statistical\Trends::CORREL |
| COS | MATH_AND_TRIG | MathTrig\Trig\Cosine::cos |
| COSH | MATH_AND_TRIG | MathTrig\Trig\Cosine::cosh |
| COT | MATH_AND_TRIG | MathTrig\Trig\Cotangent::cot |
| COTH | MATH_AND_TRIG | MathTrig\Trig\Cotangent::coth |
| COUNT | STATISTICAL | Statistical\Counts::COUNT |
| COUNTA | STATISTICAL | Statistical\Counts::COUNTA |
| COUNTBLANK | STATISTICAL | Statistical\Counts::COUNTBLANK |
| COUNTIF | STATISTICAL | Statistical\Conditional::COUNTIF |
| COUNTIFS | STATISTICAL | Statistical\Conditional::COUNTIFS |
| COUPDAYBS | FINANCIAL | Financial\Coupons::COUPDAYBS |
| COUPDAYS | FINANCIAL | Financial\Coupons::COUPDAYS |
| COUPDAYSNC | FINANCIAL | Financial\Coupons::COUPDAYSNC |
| COUPNCD | FINANCIAL | Financial\Coupons::COUPNCD |
| COUPNUM | FINANCIAL | Financial\Coupons::COUPNUM |
| COUPPCD | FINANCIAL | Financial\Coupons::COUPPCD |
| COVAR | STATISTICAL | Statistical\Trends::COVAR |
| COVARIANCE.P | STATISTICAL | Statistical\Trends::COVAR |
| COVARIANCE.S | STATISTICAL | Not yet Implemented |
| CRITBINOM | STATISTICAL | Statistical\Distributions\Binomial::inverse |
| CSC | MATH_AND_TRIG | MathTrig\Trig\Cosecant::csc |
| CSCH | MATH_AND_TRIG | MathTrig\Trig\Cosecant::csch |
| CUBEKPIMEMBER | CUBE | Not yet Implemented |
| CUBEMEMBER | CUBE | Not yet Implemented |
| CUBEMEMBERPROPERTY | CUBE | Not yet Implemented |
| CUBERANKEDMEMBER | CUBE | Not yet Implemented |
| CUBESET | CUBE | Not yet Implemented |
| CUBESETCOUNT | CUBE | Not yet Implemented |
| CUBEVALUE | CUBE | Not yet Implemented |
| CUMIPMT | FINANCIAL | Financial\CashFlow\Constant\Periodic\Cumulative::interest |
| CUMPRINC | FINANCIAL | Financial\CashFlow\Constant\Periodic\Cumulative::principal |
D
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| DATE | DATE_AND_TIME | DateTimeExcel\Date::fromYMD |
| DATEDIF | DATE_AND_TIME | DateTimeExcel\Difference::interval |
| DATESTRING | DATE_AND_TIME | Not yet Implemented |
| DATEVALUE | DATE_AND_TIME | DateTimeExcel\DateValue::fromString |
| DAVERAGE | DATABASE | Database\DAverage::evaluate |
| DAY | DATE_AND_TIME | DateTimeExcel\DateParts::day |
| DAYS | DATE_AND_TIME | DateTimeExcel\Days::between |
| DAYS360 | DATE_AND_TIME | DateTimeExcel\Days360::between |
| DB | FINANCIAL | Financial\Depreciation::DB |
| DBCS | TEXT_AND_DATA | Not yet Implemented |
| DCOUNT | DATABASE | Database\DCount::evaluate |
| DCOUNTA | DATABASE | Database\DCountA::evaluate |
| DDB | FINANCIAL | Financial\Depreciation::DDB |
| DEC2BIN | ENGINEERING | Engineering\ConvertDecimal::toBinary |
| DEC2HEX | ENGINEERING | Engineering\ConvertDecimal::toHex |
| DEC2OCT | ENGINEERING | Engineering\ConvertDecimal::toOctal |
| DECIMAL | MATH_AND_TRIG | Not yet Implemented |
| DEGREES | MATH_AND_TRIG | MathTrig\Angle::toDegrees |
| DELTA | ENGINEERING | Engineering\Compare::DELTA |
| DEVSQ | STATISTICAL | Statistical\Deviations::sumSquares |
| DGET | DATABASE | Database\DGet::evaluate |
| DISC | FINANCIAL | Financial\Securities\Rates::discount |
| DMAX | DATABASE | Database\DMax::evaluate |
| DMIN | DATABASE | Database\DMin::evaluate |
| DOLLAR | TEXT_AND_DATA | TextData\Format::DOLLAR |
| DOLLARDE | FINANCIAL | Financial\Dollar::decimal |
| DOLLARFR | FINANCIAL | Financial\Dollar::fractional |
| DPRODUCT | DATABASE | Database\DProduct::evaluate |
| DROP | LOOKUP_AND_REFERENCE | LookupRef\ChooseRowsEtc::drop |
| DSTDEV | DATABASE | Database\DStDev::evaluate |
| DSTDEVP | DATABASE | Database\DStDevP::evaluate |
| DSUM | DATABASE | Database\DSum::evaluate |
| DURATION | FINANCIAL | Not yet Implemented |
| DVAR | DATABASE | Database\DVar::evaluate |
| DVARP | DATABASE | Database\DVarP::evaluate |
E
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| ECMA.CEILING | MATH_AND_TRIG | Not yet Implemented |
| EDATE | DATE_AND_TIME | DateTimeExcel\Month::adjust |
| EFFECT | FINANCIAL | Financial\InterestRate::effective |
| ENCODEURL | WEB | Web\Service::urlEncode |
| EOMONTH | DATE_AND_TIME | DateTimeExcel\Month::lastDay |
| ERF | ENGINEERING | Engineering\Erf::ERF |
| ERF.PRECISE | ENGINEERING | Engineering\Erf::ERFPRECISE |
| ERFC | ENGINEERING | Engineering\ErfC::ERFC |
| ERFC.PRECISE | ENGINEERING | Engineering\ErfC::ERFC |
| ERROR.TYPE | INFORMATION | Information\ExcelError::type |
| EVEN | MATH_AND_TRIG | MathTrig\Round::even |
| EXACT | TEXT_AND_DATA | TextData\Text::exact |
| EXP | MATH_AND_TRIG | MathTrig\Exp::evaluate |
| EXPAND | LOOKUP_AND_REFERENCE | LookupRef\ChooseRowsEtc::expand |
| EXPON.DIST | STATISTICAL | Statistical\Distributions\Exponential::distribution |
| EXPONDIST | STATISTICAL | Statistical\Distributions\Exponential::distribution |
F
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| F.DIST | STATISTICAL | Statistical\Distributions\F::distribution |
| F.DIST.RT | STATISTICAL | Not yet Implemented |
| F.INV | STATISTICAL | Not yet Implemented |
| F.INV.RT | STATISTICAL | Not yet Implemented |
| F.TEST | STATISTICAL | Not yet Implemented |
| FACT | MATH_AND_TRIG | MathTrig\Factorial::fact |
| FACTDOUBLE | MATH_AND_TRIG | MathTrig\Factorial::factDouble |
| FALSE | LOGICAL | Logical\Boolean::FALSE |
| FDIST | STATISTICAL | Not yet Implemented |
| FILTER | LOOKUP_AND_REFERENCE | LookupRef\Filter::filter |
| FILTERXML | WEB | Not yet Implemented |
| FIND | TEXT_AND_DATA | TextData\Search::sensitive |
| FINDB | TEXT_AND_DATA | TextData\Search::sensitive |
| FINV | STATISTICAL | Not yet Implemented |
| FISHER | STATISTICAL | Statistical\Distributions\Fisher::distribution |
| FISHERINV | STATISTICAL | Statistical\Distributions\Fisher::inverse |
| FIXED | TEXT_AND_DATA | TextData\Format::FIXEDFORMAT |
| FLOOR | MATH_AND_TRIG | MathTrig\Floor::floor |
| FLOOR.MATH | MATH_AND_TRIG | MathTrig\Floor::math |
| FLOOR.PRECISE | MATH_AND_TRIG | MathTrig\Floor::precise |
| FORECAST | STATISTICAL | Statistical\Trends::FORECAST |
| FORECAST.ETS | STATISTICAL | Not yet Implemented |
| FORECAST.ETS.CONFINT | STATISTICAL | Not yet Implemented |
| FORECAST.ETS.SEASONALITY | STATISTICAL | Not yet Implemented |
| FORECAST.ETS.STAT | STATISTICAL | Not yet Implemented |
| FORECAST.LINEAR | STATISTICAL | Statistical\Trends::FORECAST |
| FORMULATEXT | LOOKUP_AND_REFERENCE | LookupRef\Formula::text |
| FREQUENCY | STATISTICAL | Not yet Implemented |
| FTEST | STATISTICAL | Not yet Implemented |
| FV | FINANCIAL | Financial\CashFlow\Constant\Periodic::futureValue |
| FVSCHEDULE | FINANCIAL | Financial\CashFlow\Single::futureValue |
G
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| GAMMA | STATISTICAL | Statistical\Distributions\Gamma::gamma |
| GAMMA.DIST | STATISTICAL | Statistical\Distributions\Gamma::distribution |
| GAMMA.INV | STATISTICAL | Statistical\Distributions\Gamma::inverse |
| GAMMADIST | STATISTICAL | Statistical\Distributions\Gamma::distribution |
| GAMMAINV | STATISTICAL | Statistical\Distributions\Gamma::inverse |
| GAMMALN | STATISTICAL | Statistical\Distributions\Gamma::ln |
| GAMMALN.PRECISE | STATISTICAL | Statistical\Distributions\Gamma::ln |
| GAUSS | STATISTICAL | Statistical\Distributions\StandardNormal::gauss |
| GCD | MATH_AND_TRIG | MathTrig\Gcd::evaluate |
| GEOMEAN | STATISTICAL | Statistical\Averages\Mean::geometric |
| GESTEP | ENGINEERING | Engineering\Compare::GESTEP |
| GETPIVOTDATA | LOOKUP_AND_REFERENCE | Not yet Implemented |
| GROUPBY | LOOKUP_AND_REFERENCE | Not yet Implemented |
| GROWTH | STATISTICAL | Statistical\Trends::GROWTH |
H
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| HARMEAN | STATISTICAL | Statistical\Averages\Mean::harmonic |
| HEX2BIN | ENGINEERING | Engineering\ConvertHex::toBinary |
| HEX2DEC | ENGINEERING | Engineering\ConvertHex::toDecimal |
| HEX2OCT | ENGINEERING | Engineering\ConvertHex::toOctal |
| HLOOKUP | LOOKUP_AND_REFERENCE | LookupRef\HLookup::lookup |
| HOUR | DATE_AND_TIME | DateTimeExcel\TimeParts::hour |
| HSTACK | LOOKUP_AND_REFERENCE | LookupRef\Hstack::hstack |
| HYPERLINK | LOOKUP_AND_REFERENCE | LookupRef\Hyperlink::set |
| HYPGEOM.DIST | STATISTICAL | Not yet Implemented |
| HYPGEOMDIST | STATISTICAL | Statistical\Distributions\HyperGeometric::distribution |
I
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| IF | LOGICAL | Logical\Conditional::statementIf |
| IFERROR | LOGICAL | Logical\Conditional::IFERROR |
| IFNA | LOGICAL | Logical\Conditional::IFNA |
| IFS | LOGICAL | Logical\Conditional::IFS |
| IMABS | ENGINEERING | Engineering\ComplexFunctions::IMABS |
| IMAGINARY | ENGINEERING | Engineering\Complex::IMAGINARY |
| IMARGUMENT | ENGINEERING | Engineering\ComplexFunctions::IMARGUMENT |
| IMCONJUGATE | ENGINEERING | Engineering\ComplexFunctions::IMCONJUGATE |
| IMCOS | ENGINEERING | Engineering\ComplexFunctions::IMCOS |
| IMCOSH | ENGINEERING | Engineering\ComplexFunctions::IMCOSH |
| IMCOT | ENGINEERING | Engineering\ComplexFunctions::IMCOT |
| IMCSC | ENGINEERING | Engineering\ComplexFunctions::IMCSC |
| IMCSCH | ENGINEERING | Engineering\ComplexFunctions::IMCSCH |
| IMDIV | ENGINEERING | Engineering\ComplexOperations::IMDIV |
| IMEXP | ENGINEERING | Engineering\ComplexFunctions::IMEXP |
| IMLN | ENGINEERING | Engineering\ComplexFunctions::IMLN |
| IMLOG10 | ENGINEERING | Engineering\ComplexFunctions::IMLOG10 |
| IMLOG2 | ENGINEERING | Engineering\ComplexFunctions::IMLOG2 |
| IMPOWER | ENGINEERING | Engineering\ComplexFunctions::IMPOWER |
| IMPRODUCT | ENGINEERING | Engineering\ComplexOperations::IMPRODUCT |
| IMREAL | ENGINEERING | Engineering\Complex::IMREAL |
| IMSEC | ENGINEERING | Engineering\ComplexFunctions::IMSEC |
| IMSECH | ENGINEERING | Engineering\ComplexFunctions::IMSECH |
| IMSIN | ENGINEERING | Engineering\ComplexFunctions::IMSIN |
| IMSINH | ENGINEERING | Engineering\ComplexFunctions::IMSINH |
| IMSQRT | ENGINEERING | Engineering\ComplexFunctions::IMSQRT |
| IMSUB | ENGINEERING | Engineering\ComplexOperations::IMSUB |
| IMSUM | ENGINEERING | Engineering\ComplexOperations::IMSUM |
| IMTAN | ENGINEERING | Engineering\ComplexFunctions::IMTAN |
| INDEX | LOOKUP_AND_REFERENCE | LookupRef\Matrix::index |
| INDIRECT | LOOKUP_AND_REFERENCE | LookupRef\Indirect::INDIRECT |
| INFO | INFORMATION | Information\Info::getInfo |
| INT | MATH_AND_TRIG | MathTrig\IntClass::evaluate |
| INTERCEPT | STATISTICAL | Statistical\Trends::INTERCEPT |
| INTRATE | FINANCIAL | Financial\Securities\Rates::interest |
| IPMT | FINANCIAL | Financial\CashFlow\Constant\Periodic\Interest::payment |
| IRR | FINANCIAL | Financial\CashFlow\Variable\Periodic::rate |
| ISBLANK | INFORMATION | Information\Value::isBlank |
| ISERR | INFORMATION | Information\ErrorValue::isErr |
| ISERROR | INFORMATION | Information\ErrorValue::isError |
| ISEVEN | INFORMATION | Information\Value::isEven |
| ISFORMULA | INFORMATION | Information\Value::isFormula |
| ISLOGICAL | INFORMATION | Information\Value::isLogical |
| ISNA | INFORMATION | Information\ErrorValue::isNa |
| ISNONTEXT | INFORMATION | Information\Value::isNonText |
| ISNUMBER | INFORMATION | Information\Value::isNumber |
| ISO.CEILING | MATH_AND_TRIG | Not yet Implemented |
| ISODD | INFORMATION | Information\Value::isOdd |
| ISOMITTED | INFORMATION | Not yet Implemented |
| ISOWEEKNUM | DATE_AND_TIME | DateTimeExcel\Week::isoWeekNumber |
| ISPMT | FINANCIAL | Financial\CashFlow\Constant\Periodic\Interest::schedulePayment |
| ISREF | INFORMATION | Information\Value::isRef |
| ISTEXT | INFORMATION | Information\Value::isText |
| ISTHAIDIGIT | TEXT_AND_DATA | Not yet Implemented |
J
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| JIS | TEXT_AND_DATA | Not yet Implemented |
K
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| KURT | STATISTICAL | Statistical\Deviations::kurtosis |
L
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| LAMBDA | LOGICAL | Not yet Implemented |
| LARGE | STATISTICAL | Statistical\Size::large |
| LCM | MATH_AND_TRIG | MathTrig\Lcm::evaluate |
| LEFT | TEXT_AND_DATA | TextData\Extract::left |
| LEFTB | TEXT_AND_DATA | TextData\Extract::left |
| LEN | TEXT_AND_DATA | TextData\Text::length |
| LENB | TEXT_AND_DATA | TextData\Text::length |
| LET | LOGICAL | Not yet Implemented |
| LINEST | STATISTICAL | Statistical\Trends::LINEST |
| LN | MATH_AND_TRIG | MathTrig\Logarithms::natural |
| LOG | MATH_AND_TRIG | MathTrig\Logarithms::withBase |
| LOG10 | MATH_AND_TRIG | MathTrig\Logarithms::base10 |
| LOGEST | STATISTICAL | Statistical\Trends::LOGEST |
| LOGINV | STATISTICAL | Statistical\Distributions\LogNormal::inverse |
| LOGNORM.DIST | STATISTICAL | Statistical\Distributions\LogNormal::distribution |
| LOGNORM.INV | STATISTICAL | Statistical\Distributions\LogNormal::inverse |
| LOGNORMDIST | STATISTICAL | Statistical\Distributions\LogNormal::cumulative |
| LOOKUP | LOOKUP_AND_REFERENCE | LookupRef\Lookup::lookup |
| LOWER | TEXT_AND_DATA | TextData\CaseConvert::lower |
M
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| MAKEARRAY | LOGICAL | Not yet Implemented |
| MAP | LOGICAL | Not yet Implemented |
| MATCH | LOOKUP_AND_REFERENCE | LookupRef\ExcelMatch::MATCH |
| MAX | STATISTICAL | Statistical\Maximum::max |
| MAXA | STATISTICAL | Statistical\Maximum::maxA |
| MAXIFS | STATISTICAL | Statistical\Conditional::MAXIFS |
| MDETERM | MATH_AND_TRIG | MathTrig\MatrixFunctions::determinant |
| MDURATION | FINANCIAL | Not yet Implemented |
| MEDIAN | STATISTICAL | Statistical\Averages::median |
| MEDIANIF | STATISTICAL | Not yet Implemented |
| MID | TEXT_AND_DATA | TextData\Extract::mid |
| MIDB | TEXT_AND_DATA | TextData\Extract::mid |
| MIN | STATISTICAL | Statistical\Minimum::min |
| MINA | STATISTICAL | Statistical\Minimum::minA |
| MINIFS | STATISTICAL | Statistical\Conditional::MINIFS |
| MINUTE | DATE_AND_TIME | DateTimeExcel\TimeParts::minute |
| MINVERSE | MATH_AND_TRIG | MathTrig\MatrixFunctions::inverse |
| MIRR | FINANCIAL | Financial\CashFlow\Variable\Periodic::modifiedRate |
| MMULT | MATH_AND_TRIG | MathTrig\MatrixFunctions::multiply |
| MOD | MATH_AND_TRIG | MathTrig\Operations::mod |
| MODE | STATISTICAL | Statistical\Averages::mode |
| MODE.MULT | STATISTICAL | Not yet Implemented |
| MODE.SNGL | STATISTICAL | Statistical\Averages::mode |
| MONTH | DATE_AND_TIME | DateTimeExcel\DateParts::month |
| MROUND | MATH_AND_TRIG | MathTrig\Round::multiple |
| MULTINOMIAL | MATH_AND_TRIG | MathTrig\Factorial::multinomial |
| MUNIT | MATH_AND_TRIG | MathTrig\MatrixFunctions::identity |
N
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| N | INFORMATION | Information\Value::asNumber |
| NA | INFORMATION | Information\ExcelError::NA |
| NEGBINOM.DIST | STATISTICAL | Not yet Implemented |
| NEGBINOMDIST | STATISTICAL | Statistical\Distributions\Binomial::negative |
| NETWORKDAYS | DATE_AND_TIME | DateTimeExcel\NetworkDays::count |
| NETWORKDAYS.INTL | DATE_AND_TIME | Not yet Implemented |
| NOMINAL | FINANCIAL | Financial\InterestRate::nominal |
| NORM.DIST | STATISTICAL | Statistical\Distributions\Normal::distribution |
| NORM.INV | STATISTICAL | Statistical\Distributions\Normal::inverse |
| NORM.S.DIST | STATISTICAL | Statistical\Distributions\StandardNormal::distribution |
| NORM.S.INV | STATISTICAL | Statistical\Distributions\StandardNormal::inverse |
| NORMDIST | STATISTICAL | Statistical\Distributions\Normal::distribution |
| NORMINV | STATISTICAL | Statistical\Distributions\Normal::inverse |
| NORMSDIST | STATISTICAL | Statistical\Distributions\StandardNormal::cumulative |
| NORMSINV | STATISTICAL | Statistical\Distributions\StandardNormal::inverse |
| NOT | LOGICAL | Logical\Operations::NOT |
| NOW | DATE_AND_TIME | DateTimeExcel\Current::now |
| NPER | FINANCIAL | Financial\CashFlow\Constant\Periodic::periods |
| NPV | FINANCIAL | Financial\CashFlow\Variable\Periodic::presentValue |
| NUMBERSTRING | TEXT_AND_DATA | Not yet Implemented |
| NUMBERVALUE | TEXT_AND_DATA | TextData\Format::NUMBERVALUE |
O
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| OCT2BIN | ENGINEERING | Engineering\ConvertOctal::toBinary |
| OCT2DEC | ENGINEERING | Engineering\ConvertOctal::toDecimal |
| OCT2HEX | ENGINEERING | Engineering\ConvertOctal::toHex |
| ODD | MATH_AND_TRIG | MathTrig\Round::odd |
| ODDFPRICE | FINANCIAL | Not yet Implemented |
| ODDFYIELD | FINANCIAL | Not yet Implemented |
| ODDLPRICE | FINANCIAL | Not yet Implemented |
| ODDLYIELD | FINANCIAL | Not yet Implemented |
| OFFSET | LOOKUP_AND_REFERENCE | LookupRef\Offset::OFFSET |
| OR | LOGICAL | Logical\Operations::logicalOr |
P
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| PDURATION | FINANCIAL | Financial\CashFlow\Single::periods |
| PEARSON | STATISTICAL | Statistical\Trends::CORREL |
| PERCENTILE | STATISTICAL | Statistical\Percentiles::PERCENTILE |
| PERCENTILE.EXC | STATISTICAL | Not yet Implemented |
| PERCENTILE.INC | STATISTICAL | Statistical\Percentiles::PERCENTILE |
| PERCENTRANK | STATISTICAL | Statistical\Percentiles::PERCENTRANK |
| PERCENTRANK.EXC | STATISTICAL | Not yet Implemented |
| PERCENTRANK.INC | STATISTICAL | Statistical\Percentiles::PERCENTRANK |
| PERMUT | STATISTICAL | Statistical\Permutations::PERMUT |
| PERMUTATIONA | STATISTICAL | Statistical\Permutations::PERMUTATIONA |
| PHI | STATISTICAL | Not yet Implemented |
| PHONETIC | TEXT_AND_DATA | Not yet Implemented |
| PI | MATH_AND_TRIG | pi |
| PMT | FINANCIAL | Financial\CashFlow\Constant\Periodic\Payments::annuity |
| POISSON | STATISTICAL | Statistical\Distributions\Poisson::distribution |
| POISSON.DIST | STATISTICAL | Statistical\Distributions\Poisson::distribution |
| POWER | MATH_AND_TRIG | MathTrig\Operations::power |
| PPMT | FINANCIAL | Financial\CashFlow\Constant\Periodic\Payments::interestPayment |
| PRICE | FINANCIAL | Financial\Securities\Price::price |
| PRICEDISC | FINANCIAL | Financial\Securities\Price::priceDiscounted |
| PRICEMAT | FINANCIAL | Financial\Securities\Price::priceAtMaturity |
| PROB | STATISTICAL | Not yet Implemented |
| PRODUCT | MATH_AND_TRIG | MathTrig\Operations::product |
| PROPER | TEXT_AND_DATA | TextData\CaseConvert::proper |
| PV | FINANCIAL | Financial\CashFlow\Constant\Periodic::presentValue |
Q
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| QUARTILE | STATISTICAL | Statistical\Percentiles::QUARTILE |
| QUARTILE.EXC | STATISTICAL | Not yet Implemented |
| QUARTILE.INC | STATISTICAL | Statistical\Percentiles::QUARTILE |
| QUOTIENT | MATH_AND_TRIG | MathTrig\Operations::quotient |
R
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| RADIANS | MATH_AND_TRIG | MathTrig\Angle::toRadians |
| RAND | MATH_AND_TRIG | MathTrig\Random::rand |
| RANDARRAY | MATH_AND_TRIG | MathTrig\Random::randArray |
| RANDBETWEEN | MATH_AND_TRIG | MathTrig\Random::randBetween |
| RANK | STATISTICAL | Statistical\Percentiles::RANK |
| RANK.AVG | STATISTICAL | Not yet Implemented |
| RANK.EQ | STATISTICAL | Statistical\Percentiles::RANK |
| RATE | FINANCIAL | Financial\CashFlow\Constant\Periodic\Interest::rate |
| RECEIVED | FINANCIAL | Financial\Securities\Price::received |
| REDUCE | LOGICAL | Not yet Implemented |
| REPLACE | TEXT_AND_DATA | TextData\Replace::replace |
| REPLACEB | TEXT_AND_DATA | TextData\Replace::replace |
| REPT | TEXT_AND_DATA | TextData\Concatenate::builtinREPT |
| RIGHT | TEXT_AND_DATA | TextData\Extract::right |
| RIGHTB | TEXT_AND_DATA | TextData\Extract::right |
| ROMAN | MATH_AND_TRIG | MathTrig\Roman::evaluate |
| ROUND | MATH_AND_TRIG | MathTrig\Round::round |
| ROUNDBAHTDOWN | MATH_AND_TRIG | Not yet Implemented |
| ROUNDBAHTUP | MATH_AND_TRIG | Not yet Implemented |
| ROUNDDOWN | MATH_AND_TRIG | MathTrig\Round::down |
| ROUNDUP | MATH_AND_TRIG | MathTrig\Round::up |
| ROW | LOOKUP_AND_REFERENCE | LookupRef\RowColumnInformation::ROW |
| ROWS | LOOKUP_AND_REFERENCE | LookupRef\RowColumnInformation::ROWS |
| RRI | FINANCIAL | Financial\CashFlow\Single::interestRate |
| RSQ | STATISTICAL | Statistical\Trends::RSQ |
| RTD | LOOKUP_AND_REFERENCE | Not yet Implemented |
S
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| SCAN | LOGICAL | Not yet Implemented |
| SEARCH | TEXT_AND_DATA | TextData\Search::insensitive |
| SEARCHB | TEXT_AND_DATA | TextData\Search::insensitive |
| SEC | MATH_AND_TRIG | MathTrig\Trig\Secant::sec |
| SECH | MATH_AND_TRIG | MathTrig\Trig\Secant::sech |
| SECOND | DATE_AND_TIME | DateTimeExcel\TimeParts::second |
| SEQUENCE | MATH_AND_TRIG | MathTrig\MatrixFunctions::sequence |
| SERIESSUM | MATH_AND_TRIG | MathTrig\SeriesSum::evaluate |
| SHEET | INFORMATION | Not yet Implemented |
| SHEETS | INFORMATION | Not yet Implemented |
| SIGN | MATH_AND_TRIG | MathTrig\Sign::evaluate |
| SIN | MATH_AND_TRIG | MathTrig\Trig\Sine::sin |
| SINGLE | MICROSOFT_INTERNAL | Internal\ExcelArrayPseudoFunctions::single |
| SINH | MATH_AND_TRIG | MathTrig\Trig\Sine::sinh |
| SKEW | STATISTICAL | Statistical\Deviations::skew |
| SKEW.P | STATISTICAL | Not yet Implemented |
| SLN | FINANCIAL | Financial\Depreciation::SLN |
| SLOPE | STATISTICAL | Statistical\Trends::SLOPE |
| SMALL | STATISTICAL | Statistical\Size::small |
| SORT | LOOKUP_AND_REFERENCE | LookupRef\Sort::sort |
| SORTBY | LOOKUP_AND_REFERENCE | LookupRef\Sort::sortBy |
| SQRT | MATH_AND_TRIG | MathTrig\Sqrt::sqrt |
| SQRTPI | MATH_AND_TRIG | MathTrig\Sqrt::pi |
| STANDARDIZE | STATISTICAL | Statistical\Standardize::execute |
| STDEV | STATISTICAL | Statistical\StandardDeviations::STDEV |
| STDEV.P | STATISTICAL | Statistical\StandardDeviations::STDEVP |
| STDEV.S | STATISTICAL | Statistical\StandardDeviations::STDEV |
| STDEVA | STATISTICAL | Statistical\StandardDeviations::STDEVA |
| STDEVP | STATISTICAL | Statistical\StandardDeviations::STDEVP |
| STDEVPA | STATISTICAL | Statistical\StandardDeviations::STDEVPA |
| STEYX | STATISTICAL | Statistical\Trends::STEYX |
| SUBSTITUTE | TEXT_AND_DATA | TextData\Replace::substitute |
| SUBTOTAL | MATH_AND_TRIG | MathTrig\Subtotal::evaluate |
| SUM | MATH_AND_TRIG | MathTrig\Sum::sumErroringStrings |
| SUMIF | MATH_AND_TRIG | Statistical\Conditional::SUMIF |
| SUMIFS | MATH_AND_TRIG | Statistical\Conditional::SUMIFS |
| SUMPRODUCT | MATH_AND_TRIG | MathTrig\Sum::product |
| SUMSQ | MATH_AND_TRIG | MathTrig\SumSquares::sumSquare |
| SUMX2MY2 | MATH_AND_TRIG | MathTrig\SumSquares::sumXSquaredMinusYSquared |
| SUMX2PY2 | MATH_AND_TRIG | MathTrig\SumSquares::sumXSquaredPlusYSquared |
| SUMXMY2 | MATH_AND_TRIG | MathTrig\SumSquares::sumXMinusYSquared |
| SWITCH | LOGICAL | Logical\Conditional::statementSwitch |
| SYD | FINANCIAL | Financial\Depreciation::SYD |
T
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| T | TEXT_AND_DATA | TextData\Text::test |
| T.DIST | STATISTICAL | Statistical\Distributions\StudentT::tDotDist |
| T.DIST.2T | STATISTICAL | Statistical\Distributions\StudentT::tDotDistDot2T |
| T.DIST.RT | STATISTICAL | Statistical\Distributions\StudentT::tDotDistDotRT |
| T.INV | STATISTICAL | Statistical\Distributions\StudentT::tDotInv |
| T.INV.2T | STATISTICAL | Statistical\Distributions\StudentT::inverse |
| T.TEST | STATISTICAL | Not yet Implemented |
| TAKE | LOOKUP_AND_REFERENCE | LookupRef\ChooseRowsEtc::take |
| TAN | MATH_AND_TRIG | MathTrig\Trig\Tangent::tan |
| TANH | MATH_AND_TRIG | MathTrig\Trig\Tangent::tanh |
| TBILLEQ | FINANCIAL | Financial\TreasuryBill::bondEquivalentYield |
| TBILLPRICE | FINANCIAL | Financial\TreasuryBill::price |
| TBILLYIELD | FINANCIAL | Financial\TreasuryBill::yield |
| TDIST | STATISTICAL | Statistical\Distributions\StudentT::distribution |
| TEXT | TEXT_AND_DATA | TextData\Format::TEXTFORMAT |
| TEXTAFTER | TEXT_AND_DATA | TextData\Extract::after |
| TEXTBEFORE | TEXT_AND_DATA | TextData\Extract::before |
| TEXTJOIN | TEXT_AND_DATA | TextData\Concatenate::TEXTJOIN |
| TEXTSPLIT | TEXT_AND_DATA | TextData\Text::split |
| THAIDAYOFWEEK | DATE_AND_TIME | Not yet Implemented |
| THAIDIGIT | TEXT_AND_DATA | Not yet Implemented |
| THAIMONTHOFYEAR | DATE_AND_TIME | Not yet Implemented |
| THAINUMSOUND | TEXT_AND_DATA | Not yet Implemented |
| THAINUMSTRING | TEXT_AND_DATA | Not yet Implemented |
| THAISTRINGLENGTH | TEXT_AND_DATA | Not yet Implemented |
| THAIYEAR | DATE_AND_TIME | Not yet Implemented |
| TIME | DATE_AND_TIME | DateTimeExcel\Time::fromHMS |
| TIMEVALUE | DATE_AND_TIME | DateTimeExcel\TimeValue::fromString |
| TINV | STATISTICAL | Statistical\Distributions\StudentT::inverse |
| TOCOL | LOOKUP_AND_REFERENCE | LookupRef\TorowTocol::tocol |
| TODAY | DATE_AND_TIME | DateTimeExcel\Current::today |
| TOROW | LOOKUP_AND_REFERENCE | LookupRef\TorowTocol::torow |
| TRANSPOSE | LOOKUP_AND_REFERENCE | LookupRef\Matrix::transpose |
| TREND | STATISTICAL | Statistical\Trends::TREND |
| TRIM | TEXT_AND_DATA | TextData\Trim::spaces |
| TRIMMEAN | STATISTICAL | Statistical\Averages\Mean::trim |
| TRUE | LOGICAL | Logical\Boolean::TRUE |
| TRUNC | MATH_AND_TRIG | MathTrig\Trunc::evaluate |
| TTEST | STATISTICAL | Not yet Implemented |
| TYPE | INFORMATION | Information\Value::type |
U
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| UNICHAR | TEXT_AND_DATA | TextData\CharacterConvert::characterUnicode |
| UNICODE | TEXT_AND_DATA | TextData\CharacterConvert::codeUnicode |
| UNIQUE | LOOKUP_AND_REFERENCE | LookupRef\Unique::unique |
| UPPER | TEXT_AND_DATA | TextData\CaseConvert::upper |
| USDOLLAR | FINANCIAL | Financial\Dollar::format |
V
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| VALUE | TEXT_AND_DATA | TextData\Format::VALUE |
| VALUETOTEXT | TEXT_AND_DATA | TextData\Format::valueToText |
| VAR | STATISTICAL | Statistical\Variances::VAR |
| VAR.P | STATISTICAL | Statistical\Variances::VARP |
| VAR.S | STATISTICAL | Statistical\Variances::VAR |
| VARA | STATISTICAL | Statistical\Variances::VARA |
| VARP | STATISTICAL | Statistical\Variances::VARP |
| VARPA | STATISTICAL | Statistical\Variances::VARPA |
| VDB | FINANCIAL | Not yet Implemented |
| VLOOKUP | LOOKUP_AND_REFERENCE | LookupRef\VLookup::lookup |
| VSTACK | LOOKUP_AND_REFERENCE | LookupRef\Vstack::vstack |
W
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| WEBSERVICE | WEB | Web\Service::webService |
| WEEKDAY | DATE_AND_TIME | DateTimeExcel\Week::day |
| WEEKNUM | DATE_AND_TIME | DateTimeExcel\Week::number |
| WEIBULL | STATISTICAL | Statistical\Distributions\Weibull::distribution |
| WEIBULL.DIST | STATISTICAL | Statistical\Distributions\Weibull::distribution |
| WORKDAY | DATE_AND_TIME | DateTimeExcel\WorkDay::date |
| WORKDAY.INTL | DATE_AND_TIME | Not yet Implemented |
| WRAPCOLS | MATH_AND_TRIG | Not yet Implemented |
| WRAPROWS | MATH_AND_TRIG | Not yet Implemented |
X
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| XIRR | FINANCIAL | Financial\CashFlow\Variable\NonPeriodic::rate |
| XLOOKUP | LOOKUP_AND_REFERENCE | LookupRef\XLookup::lookup |
| XMATCH | LOOKUP_AND_REFERENCE | Not yet Implemented |
| XNPV | FINANCIAL | Financial\CashFlow\Variable\NonPeriodic::presentValue |
| XOR | LOGICAL | Logical\Operations::logicalXor |
Y
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| YEAR | DATE_AND_TIME | DateTimeExcel\DateParts::year |
| YEARFRAC | DATE_AND_TIME | DateTimeExcel\YearFrac::fraction |
| YIELD | FINANCIAL | Not yet Implemented |
| YIELDDISC | FINANCIAL | Financial\Securities\Yields::yieldDiscounted |
| YIELDMAT | FINANCIAL | Financial\Securities\Yields::yieldAtMaturity |
Z
| Excel Function | Category | PhpSpreadsheet Function |
|---|---|---|
| Z.TEST | STATISTICAL | Statistical\Distributions\StandardNormal::zTest |
| ZTEST | STATISTICAL | Statistical\Distributions\StandardNormal::zTest |