# 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
