Can I Spreadsheet?
caniuse.com for spreadsheet functions. Search any function to see whether it's documented, tested, and how Excel, Google Sheets, and LibreOffice Calc actually behave.
600 of 600 functions
600Functions inventoried
1/3Engines executed
604Test cases executed
86Quirks discovered
Methodology: every result badge on this site
traces back to a formula that was actually written into a real workbook and
recalculated by that engine, proven with deterministic and volatile canary
formulas on every run (see the test harness).
Nothing here is scraped from vendor docs and presented as tested. Functions
we haven't run through an engine yet are labeled not yet live-tested and show inventory data only.
Most compatibility-interesting functions
- COUNT Quirk found
- ERROR.TYPE Quirk found
- LARGE Quirk found
- LN Quirk found
- LOG Quirk found
- LOG10 Quirk found
- PERCENTILE.EXC Quirk found
- SMALL Quirk found
All functions
- ABS Math and trigonometry Supported, behaves as documented
- ACCRINT Financial not yet live-tested
- ACCRINTM Financial not yet live-tested
- ACOS Math and trigonometry not yet live-tested
- ACOSH Math and trigonometry not yet live-tested
- ACOT Math and trigonometry not yet live-tested
- ACOTH Math and trigonometry not yet live-tested
- ADD Operator not yet live-tested
- ADDRESS Lookup and reference Supported, behaves as documented
- AGGREGATE Math and trigonometry not yet live-tested
- AI AI not yet live-tested
- AMORDEGRC Financial not yet live-tested
- AMORLINC Financial not yet live-tested
- AND Logical Supported, behaves as documented
- ARABIC Math and trigonometry not yet live-tested
- AREAS Lookup and reference not yet live-tested
- ARRAYFORMULA Google not yet live-tested
- ARRAYTOTEXT Text Unsupported (not recognized)
- ARRAY_CONSTRAIN Array not yet live-tested
- ASC Text not yet live-tested
- ASIN Math and trigonometry not yet live-tested
- ASINH Math and trigonometry not yet live-tested
- ATAN Math and trigonometry not yet live-tested
- ATAN2 Math and trigonometry not yet live-tested
- ATANH Math and trigonometry not yet live-tested
- AVEDEV Statistical not yet live-tested
- AVERAGE Statistical Supported, behaves as documented
- AVERAGE.WEIGHTED Statistical not yet live-tested
- AVERAGEA Statistical not yet live-tested
- AVERAGEIF Statistical Supported, behaves as documented
- AVERAGEIFS Statistical Supported, behaves as documented
- BAHTTEXT Text not yet live-tested
- BASE Math and trigonometry not yet live-tested
- BESSELI Engineering not yet live-tested
- BESSELJ Engineering not yet live-tested
- BESSELK Engineering not yet live-tested
- BESSELY Engineering not yet live-tested
- BETA.DIST Statistical not yet live-tested
- BETA.INV Statistical not yet live-tested
- BETADIST Compatibility not yet live-tested
- BETAINV Compatibility not yet live-tested
- BIN2DEC Engineering not yet live-tested
- BIN2HEX Engineering not yet live-tested
- BIN2OCT Engineering not yet live-tested
- BINOM.DIST Statistical not yet live-tested
- BINOM.DIST.RANGE Statistical not yet live-tested
- BINOM.INV Statistical not yet live-tested
- BINOMDIST Compatibility not yet live-tested
- BITAND Engineering not yet live-tested
- BITLSHIFT Engineering not yet live-tested
- BITOR Engineering not yet live-tested
- BITRSHIFT Engineering not yet live-tested
- BITXOR Engineering not yet live-tested
- BYCOL Logical not yet live-tested
- BYROW Logical not yet live-tested
- CALL Add-in and Automation not yet live-tested
- CEILING Compatibility Supported, behaves as documented
- CEILING.MATH Math and trigonometry Supported, behaves as documented
- CEILING.PRECISE Math and trigonometry not yet live-tested
- CELL Information not yet live-tested
- CHAR Text Quirk found
- CHIDIST Compatibility not yet live-tested
- CHIINV Compatibility not yet live-tested
- CHISQ.DIST Statistical not yet live-tested
- CHISQ.DIST.RT Statistical not yet live-tested
- CHISQ.INV Statistical not yet live-tested
- CHISQ.INV.RT Statistical not yet live-tested
- CHISQ.TEST Statistical not yet live-tested
- CHISQDIST Statistical Part One not yet live-tested
- CHISQINV Statistical Part One not yet live-tested
- CHITEST Compatibility not yet live-tested
- CHOOSE Lookup and reference Supported, behaves as documented
- CHOOSECOLS Lookup and reference not yet live-tested
- CHOOSEROWS Lookup and reference not yet live-tested
- CLEAN Text Supported, behaves as documented
- CODE Text Supported, behaves as documented
- COLUMN Lookup and reference Supported, behaves as documented
- COLUMNS Lookup and reference Supported, behaves as documented
- COMBIN Math and trigonometry not yet live-tested
- COMBINA Math and trigonometry not yet live-tested
- COMPLEX Engineering not yet live-tested
- CONCAT Text Supported, behaves as documented
- CONCATENATE Text not yet live-tested
- CONFIDENCE Compatibility not yet live-tested
- CONFIDENCE.NORM Statistical not yet live-tested
- CONFIDENCE.T Statistical not yet live-tested
- CONVERT Engineering not yet live-tested
- CONVERT_OOO Mathematical not yet live-tested
- COPILOT Text not yet live-tested
- CORREL Statistical not yet live-tested
- COS Math and trigonometry not yet live-tested
- COSH Math and trigonometry not yet live-tested
- COT Math and trigonometry not yet live-tested
- COTH Math and trigonometry not yet live-tested
- COUNT Statistical Quirk found
- COUNTA Statistical Supported, behaves as documented
- COUNTBLANK Statistical Supported, behaves as documented
- COUNTIF Statistical Supported, behaves as documented
- COUNTIFS Statistical Supported, behaves as documented
- COUNTUNIQUE Math not yet live-tested
- COUPDAYBS Financial not yet live-tested
- COUPDAYS Financial not yet live-tested
- COUPDAYSNC Financial not yet live-tested
- COUPNCD Financial not yet live-tested
- COUPNUM Financial not yet live-tested
- COUPPCD Financial not yet live-tested
- COVAR Compatibility not yet live-tested
- COVARIANCE.P Statistical not yet live-tested
- COVARIANCE.S Statistical not yet live-tested
- CRITBINOM Compatibility not yet live-tested
- CSC Math and trigonometry not yet live-tested
- CSCH Math and trigonometry not yet live-tested
- CUBEKPIMEMBER Cube not yet live-tested
- CUBEMEMBER Cube not yet live-tested
- CUBEMEMBERPROPERTY Cube not yet live-tested
- CUBERANKEDMEMBER Cube not yet live-tested
- CUBESET Cube not yet live-tested
- CUBESETCOUNT Cube not yet live-tested
- CUBEVALUE Cube not yet live-tested
- CUMIPMT Financial not yet live-tested
- CUMIPMT_ADD Financial Part Two not yet live-tested
- CUMPRINC Financial not yet live-tested
- CUMPRINC_ADD Financial Part Two not yet live-tested
- CURRENT Information not yet live-tested
- DATE Date and time Supported, behaves as documented
- DATEDIF Date and time Quirk found
- DATEVALUE Date and time not yet live-tested
- DAVERAGE Database not yet live-tested
- DAY Date and time Quirk found
- DAYS Date and time Supported, behaves as documented
- DAYS360 Date and time Supported, behaves as documented
- DAYSINMONTH Date & Time not yet live-tested
- DAYSINYEAR Date & Time not yet live-tested
- DB Financial not yet live-tested
- DBCS Text not yet live-tested
- DCOUNT Database not yet live-tested
- DCOUNTA Database not yet live-tested
- DDB Financial not yet live-tested
- DDE Spreadsheet not yet live-tested
- DEC2BIN Engineering not yet live-tested
- DEC2HEX Engineering not yet live-tested
- DEC2OCT Engineering not yet live-tested
- DECIMAL Math and trigonometry not yet live-tested
- DEGREES Math and trigonometry Supported, behaves as documented
- DELTA Engineering not yet live-tested
- DETECTLANGUAGE Text not yet live-tested
- DEVSQ Statistical not yet live-tested
- DGET Database not yet live-tested
- DISC Financial not yet live-tested
- DIVIDE Operator not yet live-tested
- DMAX Database not yet live-tested
- DMIN Database not yet live-tested
- DOLLAR Text not yet live-tested
- DOLLARDE Financial not yet live-tested
- DOLLARFR Financial not yet live-tested
- DPRODUCT Database not yet live-tested
- DROP Lookup and reference not yet live-tested
- DSTDEV Database not yet live-tested
- DSTDEVP Database not yet live-tested
- DSUM Database not yet live-tested
- DURATION Financial not yet live-tested
- DVAR Database not yet live-tested
- DVARP Database not yet live-tested
- EASTERSUNDAY Date & Time not yet live-tested
- EDATE Date and time Supported, behaves as documented
- EFFECT Financial not yet live-tested
- EFFECT_ADD Financial not yet live-tested
- ENCODEURL Web not yet live-tested
- EOMONTH Date and time Supported, behaves as documented
- EPOCHTODATE Date not yet live-tested
- EQ Operator not yet live-tested
- ERF Engineering not yet live-tested
- ERF.PRECISE Engineering not yet live-tested
- ERFC Engineering not yet live-tested
- ERFC.PRECISE Engineering not yet live-tested
- ERROR.TYPE Information Quirk found
- ERRORTYPE Spreadsheet not yet live-tested
- EUROCONVERT Add-in and Automation not yet live-tested
- EVEN Math and trigonometry not yet live-tested
- EXACT Text Supported, behaves as documented
- EXP Math and trigonometry Supported, behaves as documented
- EXPAND Lookup and reference not yet live-tested
- EXPON.DIST Statistical not yet live-tested
- EXPONDIST Compatibility not yet live-tested
- F.DIST Statistical not yet live-tested
- F.DIST.RT Statistical not yet live-tested
- F.INV Statistical not yet live-tested
- F.INV.RT Statistical not yet live-tested
- F.TEST Statistical not yet live-tested
- FACT Math and trigonometry not yet live-tested
- FACTDOUBLE Math and trigonometry not yet live-tested
- FALSE Logical Supported, behaves as documented
- FDIST Compatibility not yet live-tested
- FILTER Lookup and reference Unsupported (not recognized)
- FILTERXML Web not yet live-tested
- FIND Text Supported, behaves as documented
- FINDB Text not yet live-tested
- FINV Compatibility not yet live-tested
- FISHER Statistical not yet live-tested
- FISHERINV Statistical not yet live-tested
- FIXED Text not yet live-tested
- FLATTEN Array not yet live-tested
- FLOOR Compatibility Quirk found
- FLOOR.MATH Math and trigonometry Supported, behaves as documented
- FLOOR.PRECISE Math and trigonometry not yet live-tested
- FORECAST Statistical not yet live-tested
- FORECAST.ETS Statistical not yet live-tested
- FORECAST.ETS.CONFINT Statistical not yet live-tested
- FORECAST.ETS.SEASONALITY Statistical not yet live-tested
- FORECAST.ETS.STAT Statistical not yet live-tested
- FORECAST.LINEAR Statistical not yet live-tested
- FORMULA Information not yet live-tested
- FORMULATEXT Lookup and reference Supported, behaves as documented
- FREQUENCY Statistical not yet live-tested
- FTEST Compatibility not yet live-tested
- FV Financial not yet live-tested
- FVSCHEDULE Financial not yet live-tested
- GAMMA Statistical not yet live-tested
- GAMMA.DIST Statistical not yet live-tested
- GAMMA.INV Statistical not yet live-tested
- GAMMADIST Compatibility not yet live-tested
- GAMMAINV Compatibility not yet live-tested
- GAMMALN Statistical not yet live-tested
- GAMMALN.PRECISE Statistical not yet live-tested
- GAUSS Statistical not yet live-tested
- GCD Math and trigonometry not yet live-tested
- GCD_EXCEL2003 Mathematical not yet live-tested
- GEOMEAN Statistical not yet live-tested
- GESTEP Engineering not yet live-tested
- GETPIVOTDATA Lookup and reference not yet live-tested
- GOOGLEFINANCE Google not yet live-tested
- GOOGLETRANSLATE Google not yet live-tested
- GROUPBY Lookup and reference not yet live-tested
- GROWTH Statistical not yet live-tested
- GT Operator not yet live-tested
- GTE Operator not yet live-tested
- HARMEAN Statistical not yet live-tested
- HEX2BIN Engineering not yet live-tested
- HEX2DEC Engineering not yet live-tested
- HEX2OCT Engineering not yet live-tested
- HLOOKUP Lookup and reference Quirk found
- HOUR Date and time Supported, behaves as documented
- HSTACK Lookup and reference not yet live-tested
- HYPERLINK Lookup and reference Supported, behaves as documented
- HYPGEOM.DIST Statistical not yet live-tested
- HYPGEOMDIST Compatibility not yet live-tested
- IF Logical not yet live-tested
- IFERROR Logical Supported, behaves as documented
- IFNA Logical Supported, behaves as documented
- IFS Logical Supported, behaves as documented
- IMABS Engineering not yet live-tested
- IMAGE Lookup and reference not yet live-tested
- IMAGINARY Engineering not yet live-tested
- IMARGUMENT Engineering not yet live-tested
- IMCONJUGATE Engineering not yet live-tested
- IMCOS Engineering not yet live-tested
- IMCOSH Engineering not yet live-tested
- IMCOT Engineering not yet live-tested
- IMCOTH Engineering not yet live-tested
- IMCSC Engineering not yet live-tested
- IMCSCH Engineering not yet live-tested
- IMDIV Engineering not yet live-tested
- IMEXP Engineering not yet live-tested
- IMLN Engineering not yet live-tested
- IMLOG Engineering not yet live-tested
- IMLOG10 Engineering not yet live-tested
- IMLOG2 Engineering not yet live-tested
- IMPORTDATA Web not yet live-tested
- IMPORTFEED Web not yet live-tested
- IMPORTHTML Web not yet live-tested
- IMPORTRANGE Web not yet live-tested
- IMPORTXML Web not yet live-tested
- IMPOWER Engineering not yet live-tested
- IMPRODUCT Engineering not yet live-tested
- IMREAL Engineering not yet live-tested
- IMSEC Engineering not yet live-tested
- IMSECH Engineering not yet live-tested
- IMSIN Engineering not yet live-tested
- IMSINH Engineering not yet live-tested
- IMSQRT Engineering not yet live-tested
- IMSUB Engineering not yet live-tested
- IMSUM Engineering not yet live-tested
- IMTAN Engineering not yet live-tested
- IMTANH Engineering not yet live-tested
- INDEX Lookup and reference Supported, behaves as documented
- INDIRECT Lookup and reference Supported, behaves as documented
- INFO Information not yet live-tested
- INT Math and trigonometry Supported, behaves as documented
- INTERCEPT Statistical not yet live-tested
- INTRATE Financial not yet live-tested
- IPMT Financial not yet live-tested
- IRR Financial not yet live-tested
- ISBETWEEN Operator not yet live-tested
- ISBLANK Information Supported, behaves as documented
- ISDATE Info not yet live-tested
- ISEMAIL Info not yet live-tested
- ISERR Information Supported, behaves as documented
- ISERROR Information Supported, behaves as documented
- ISEVEN Information Supported, behaves as documented
- ISEVEN_ADD Information not yet live-tested
- ISFORMULA Information not yet live-tested
- ISLEAPYEAR Date & Time not yet live-tested
- ISLOGICAL Information Supported, behaves as documented
- ISNA Information Supported, behaves as documented
- ISNONTEXT Information not yet live-tested
- ISNUMBER Information Quirk found
- ISO.CEILING Math and trigonometry not yet live-tested
- ISODD Information Supported, behaves as documented
- ISODD_ADD Information not yet live-tested
- ISOMITTED Information not yet live-tested
- ISOWEEKNUM Date and time Supported, behaves as documented
- ISPMT Financial not yet live-tested
- ISREF Information not yet live-tested
- ISTEXT Information Supported, behaves as documented
- ISURL Web not yet live-tested
- JIS Text not yet live-tested
- JOIN Text not yet live-tested
- KURT Statistical not yet live-tested
- LAMBDA Logical Unsupported (not recognized)
- LARGE Statistical Quirk found
- LCM Math and trigonometry not yet live-tested
- LCM_EXCEL2003 Mathematical not yet live-tested
- LEFT Text Supported, behaves as documented
- LEFTB Text not yet live-tested
- LEN Text Supported, behaves as documented
- LENB Text not yet live-tested
- LET Logical Unsupported (not recognized)
- LINEST Statistical not yet live-tested
- LN Math and trigonometry Quirk found
- LOG Math and trigonometry Quirk found
- LOG10 Math and trigonometry Quirk found
- LOGEST Statistical not yet live-tested
- LOGINV Compatibility not yet live-tested
- LOGNORM.DIST Statistical not yet live-tested
- LOGNORM.INV Statistical not yet live-tested
- LOGNORMDIST Compatibility not yet live-tested
- LOOKUP Lookup and reference Supported, behaves as documented
- LOWER Text Supported, behaves as documented
- LT Operator not yet live-tested
- LTE Operator not yet live-tested
- MAKEARRAY Logical not yet live-tested
- MAP Logical not yet live-tested
- MARGINOFERROR Statistical not yet live-tested
- MATCH Lookup and reference Supported, behaves as documented
- MAX Statistical Supported, behaves as documented
- MAXA Statistical not yet live-tested
- MAXIFS Statistical Supported, behaves as documented
- MDETERM Math and trigonometry not yet live-tested
- MDURATION Financial not yet live-tested
- MEDIAN Statistical Supported, behaves as documented
- MID Text Supported, behaves as documented
- MIDB Text not yet live-tested
- MIN Statistical Supported, behaves as documented
- MINA Statistical not yet live-tested
- MINIFS Statistical Supported, behaves as documented
- MINUS Operator not yet live-tested
- MINUTE Date and time Supported, behaves as documented
- MINVERSE Math and trigonometry not yet live-tested
- MIRR Financial not yet live-tested
- MMULT Math and trigonometry not yet live-tested
- MOD Math and trigonometry Supported, behaves as documented
- MODE Compatibility Quirk found
- MODE.MULT Statistical not yet live-tested
- MODE.SNGL Statistical not yet live-tested
- MONTH Date and time Quirk found
- MONTHS Date & Time not yet live-tested
- MROUND Math and trigonometry Quirk found
- MULTINOMIAL Math and trigonometry not yet live-tested
- MULTIPLY Operator not yet live-tested
- MUNIT Math and trigonometry not yet live-tested
- N Information Supported, behaves as documented
- NA Information Supported, behaves as documented
- NE Operator not yet live-tested
- NEGBINOM.DIST Statistical not yet live-tested
- NEGBINOMDIST Compatibility not yet live-tested
- NETWORKDAYS Date and time Supported, behaves as documented
- NETWORKDAYS.INTL Date and time not yet live-tested
- NOMINAL Financial not yet live-tested
- NOMINAL_ADD Financial Part Two not yet live-tested
- NORM.DIST Statistical not yet live-tested
- NORM.INV Compatibility not yet live-tested
- NORM.S.DIST Statistical not yet live-tested
- NORM.S.INV Statistical not yet live-tested
- NORMDIST Compatibility not yet live-tested
- NORMINV Statistical not yet live-tested
- NORMSDIST Compatibility not yet live-tested
- NORMSINV Compatibility not yet live-tested
- NOT Logical Supported, behaves as documented
- NOW Date and time not yet live-tested
- NPER Financial not yet live-tested
- NPV Financial not yet live-tested
- NUMBERVALUE Text Supported, behaves as documented
- OCT2BIN Engineering not yet live-tested
- OCT2DEC Engineering not yet live-tested
- OCT2HEX Engineering not yet live-tested
- ODD Math and trigonometry not yet live-tested
- ODDFPRICE Financial not yet live-tested
- ODDFYIELD Financial not yet live-tested
- ODDLPRICE Financial not yet live-tested
- ODDLYIELD Financial not yet live-tested
- OFFSET Lookup and reference Quirk found
- OR Logical Supported, behaves as documented
- PDURATION Financial not yet live-tested
- PEARSON Statistical not yet live-tested
- PERCENTILE Compatibility not yet live-tested
- PERCENTILE.EXC Statistical Quirk found
- PERCENTILE.INC Statistical Quirk found
- PERCENTOF Math and trigonometry not yet live-tested
- PERCENTRANK Compatibility not yet live-tested
- PERCENTRANK.EXC Statistical not yet live-tested
- PERCENTRANK.INC Statistical not yet live-tested
- PERMUT Statistical not yet live-tested
- PERMUTATIONA Statistical not yet live-tested
- PHI Statistical not yet live-tested
- PHONETIC Text not yet live-tested
- PI Math and trigonometry Supported, behaves as documented
- PIVOTBY Lookup and reference not yet live-tested
- PMT Financial not yet live-tested
- POISSON Compatibility not yet live-tested
- POISSON.DIST Statistical not yet live-tested
- POW Operator not yet live-tested
- POWER Math and trigonometry Quirk found
- PPMT Financial not yet live-tested
- PRICE Financial not yet live-tested
- PRICEDISC Financial not yet live-tested
- PRICEMAT Financial not yet live-tested
- PROB Statistical not yet live-tested
- PRODUCT Math and trigonometry not yet live-tested
- PROPER Text Supported, behaves as documented
- PV Financial not yet live-tested
- QUARTILE Compatibility not yet live-tested
- QUARTILE.EXC Statistical not yet live-tested
- QUARTILE.INC Statistical Quirk found
- QUERY Google not yet live-tested
- QUOTIENT Math and trigonometry not yet live-tested
- RADIANS Math and trigonometry Supported, behaves as documented
- RAND Math and trigonometry Quirk found
- RAND.NV Mathematical not yet live-tested
- RANDARRAY Math and trigonometry not yet live-tested
- RANDBETWEEN Math and trigonometry Quirk found
- RANDBETWEEN.NV Mathematical not yet live-tested
- RANK Compatibility Supported, behaves as documented
- RANK.AVG Statistical Supported, behaves as documented
- RANK.EQ Statistical Supported, behaves as documented
- RATE Financial not yet live-tested
- RAWSUBTRACT Mathematical not yet live-tested
- RECEIVED Financial not yet live-tested
- REDUCE Logical not yet live-tested
- REGEX Text not yet live-tested
- REGEXEXTRACT Text not yet live-tested
- REGEXMATCH Text not yet live-tested
- REGEXREPLACE Text not yet live-tested
- REGEXTEST Text not yet live-tested
- REGISTER.ID Add-in and Automation not yet live-tested
- REPLACE Text Supported, behaves as documented
- REPLACEB Text not yet live-tested
- REPT Text Supported, behaves as documented
- RIGHT Text Supported, behaves as documented
- RIGHTB Text not yet live-tested
- ROMAN Math and trigonometry not yet live-tested
- ROT13 Add-in not yet live-tested
- ROUND Math and trigonometry Supported, behaves as documented
- ROUNDDOWN Math and trigonometry Supported, behaves as documented
- ROUNDUP Math and trigonometry Supported, behaves as documented
- ROW Lookup and reference Supported, behaves as documented
- ROWS Lookup and reference Supported, behaves as documented
- RRI Financial not yet live-tested
- RSQ Statistical not yet live-tested
- RTD Lookup and reference not yet live-tested
- SCAN Logical not yet live-tested
- SEARCH Text Supported, behaves as documented
- SEARCHB Text not yet live-tested
- SEC Math and trigonometry not yet live-tested
- SECH Math and trigonometry not yet live-tested
- SECOND Date and time Supported, behaves as documented
- SEQUENCE Math and trigonometry Unsupported (not recognized)
- SERIESSUM Math and trigonometry not yet live-tested
- SHEET Information not yet live-tested
- SHEETS Information not yet live-tested
- SIGN Math and trigonometry Supported, behaves as documented
- SIN Math and trigonometry not yet live-tested
- SINH Math and trigonometry not yet live-tested
- SKEW Statistical not yet live-tested
- SKEW.P Statistical not yet live-tested
- SKEWP Statistical Part Five not yet live-tested
- SLN Financial not yet live-tested
- SLOPE Statistical not yet live-tested
- SMALL Statistical Quirk found
- SORT Lookup and reference Unsupported (not recognized)
- SORTBY Lookup and reference not yet live-tested
- SORTN Filter not yet live-tested
- SPARKLINE Google not yet live-tested
- SPLIT Text not yet live-tested
- SQRT Math and trigonometry Quirk found
- SQRTPI Math and trigonometry not yet live-tested
- STANDARDIZE Statistical not yet live-tested
- STDEV Compatibility Supported, behaves as documented
- STDEV.P Statistical Supported, behaves as documented
- STDEV.S Statistical Supported, behaves as documented
- STDEVA Statistical not yet live-tested
- STDEVP Compatibility not yet live-tested
- STDEVPA Statistical not yet live-tested
- STEYX Statistical not yet live-tested
- STOCKHISTORY Information not yet live-tested
- SUBSTITUTE Text Supported, behaves as documented
- SUBTOTAL Math and trigonometry not yet live-tested
- SUM Math and trigonometry Quirk found
- SUMIF Math and trigonometry Supported, behaves as documented
- SUMIFS Math and trigonometry Supported, behaves as documented
- SUMPRODUCT Math and trigonometry Supported, behaves as documented
- SUMSQ Math and trigonometry not yet live-tested
- SUMX2MY2 Math and trigonometry not yet live-tested
- SUMX2PY2 Math and trigonometry not yet live-tested
- SUMXMY2 Math and trigonometry not yet live-tested
- SWITCH Logical Supported, behaves as documented
- SYD Financial not yet live-tested
- T Text not yet live-tested
- T.DIST Statistical not yet live-tested
- T.DIST.2T Statistical not yet live-tested
- T.DIST.RT Statistical not yet live-tested
- T.INV Statistical not yet live-tested
- T.INV.2T Statistical not yet live-tested
- T.TEST Statistical not yet live-tested
- TAKE Lookup and reference not yet live-tested
- TAN Math and trigonometry not yet live-tested
- TANH Math and trigonometry not yet live-tested
- TBILLEQ Financial not yet live-tested
- TBILLPRICE Financial not yet live-tested
- TBILLYIELD Financial not yet live-tested
- TDIST Compatibility not yet live-tested
- TEXT Text Supported, behaves as documented
- TEXTAFTER Text Unsupported (not recognized)
- TEXTBEFORE Text Unsupported (not recognized)
- TEXTJOIN Text Supported, behaves as documented
- TEXTSPLIT Text Unsupported (not recognized)
- TIME Date and time Supported, behaves as documented
- TIMEVALUE Date and time not yet live-tested
- TINV Compatibility not yet live-tested
- TOCOL Lookup and reference not yet live-tested
- TODAY Date and time Quirk found
- TOROW Lookup and reference not yet live-tested
- TO_DATE Parser not yet live-tested
- TO_DOLLARS Parser not yet live-tested
- TO_PERCENT Parser not yet live-tested
- TO_PURE_NUMBER Parser not yet live-tested
- TO_TEXT Parser not yet live-tested
- TRANSLATE Text not yet live-tested
- TRANSPOSE Lookup and reference Supported, behaves as documented
- TREND Statistical not yet live-tested
- TRIM Text Quirk found
- TRIMMEAN Statistical not yet live-tested
- TRIMRANGE Lookup and reference not yet live-tested
- TRUE Logical Supported, behaves as documented
- TRUNC Math and trigonometry Supported, behaves as documented
- TTEST Compatibility not yet live-tested
- TYPE Information Quirk found
- UMINUS Operator not yet live-tested
- UNARY_PERCENT Operator not yet live-tested
- UNICHAR Text Quirk found
- UNICODE Text Supported, behaves as documented
- UNIQUE Lookup and reference Unsupported (not recognized)
- UPLUS Operator not yet live-tested
- UPPER Text Supported, behaves as documented
- VALUE Text Supported, behaves as documented
- VALUETOTEXT Text not yet live-tested
- VAR Compatibility not yet live-tested
- VAR.P Statistical not yet live-tested
- VAR.S Statistical Supported, behaves as documented
- VARA Statistical not yet live-tested
- VARP Compatibility not yet live-tested
- VARPA Statistical not yet live-tested
- VDB Financial not yet live-tested
- VLOOKUP Lookup and reference Quirk found
- VSTACK Lookup and reference not yet live-tested
- WEBSERVICE Web not yet live-tested
- WEEKDAY Date and time Quirk found
- WEEKNUM Date and time Supported, behaves as documented
- WEEKNUM_EXCEL2003 Date & Time not yet live-tested
- WEEKNUM_OOO Date & Time not yet live-tested
- WEEKS Date & Time not yet live-tested
- WEEKSINYEAR Date & Time not yet live-tested
- WEIBULL Compatibility not yet live-tested
- WEIBULL.DIST Statistical not yet live-tested
- WORKDAY Date and time Supported, behaves as documented
- WORKDAY.INTL Date and time not yet live-tested
- WRAPCOLS Lookup and reference not yet live-tested
- WRAPROWS Lookup and reference not yet live-tested
- XIRR Financial not yet live-tested
- XLOOKUP Lookup and reference Unsupported (not recognized)
- XMATCH Lookup and reference not yet live-tested
- XNPV Financial not yet live-tested
- XOR Logical Supported, behaves as documented
- YEAR Date and time Quirk found
- YEARFRAC Date and time Quirk found
- YEARS Date & Time not yet live-tested
- YIELD Financial not yet live-tested
- YIELDDISC Financial not yet live-tested
- YIELDMAT Financial not yet live-tested
- Z.TEST Statistical not yet live-tested
- ZTEST Compatibility not yet live-tested