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