Can I Spreadsheet? — Excel vs Google Sheets vs LibreOffice function compatibility
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
Popular functions
The most-searched functions, each with executed cross-app results and version history:
OFFSETMEDIANMINIFSFORECAST.ETSMROUNDCHARERROR.TYPEISERRORNUMBERVALUEABSSTDEVVLOOKUPXLOOKUPINDEXMATCHINDIRECTIFIFSIFERRORSUMIFSUMIFSCOUNTIFCOUNTIFSFILTERSORTUNIQUESEQUENCETEXTJOINCONCATENATETEXTSPLITSUBSTITUTELEFTMIDRIGHTTEXTDATEDIFEOMONTHWEEKDAYNETWORKDAYSWORKDAYAVERAGEIFMAXIFSROUNDMODPMT
600 Functions inventoried
1/3 Engines executed
841 Test cases executed
56 Quirks 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
- LAMBDALogical Quirk found 3 quirks
- COUNTStatistical Quirk found 2 quirks
- ERROR.TYPEInformation Quirk found 2 quirks
- LARGEStatistical Quirk found 2 quirks
- LNMath and trigonometry Quirk found 2 quirks
- LOGMath and trigonometry Quirk found 2 quirks
- LOG10Math and trigonometry Quirk found 2 quirks
- PERCENTILE.EXCStatistical Quirk found 2 quirks
All functions
- ABSMath and trigonometry Supported, behaves as documented
- ACCRINTFinancial not yet live-tested
- ACCRINTMFinancial not yet live-tested
- ACOSMath and trigonometry not yet live-tested
- ACOSHMath and trigonometry not yet live-tested
- ACOTMath and trigonometry not yet live-tested
- ACOTHMath and trigonometry not yet live-tested
- ADDOperator not yet live-tested
- ADDRESSLookup and reference Supported, behaves as documented
- AGGREGATEMath and trigonometry Supported, behaves as documented
- AIAI not yet live-tested
- AMORDEGRCFinancial not yet live-tested
- AMORLINCFinancial not yet live-tested
- ANDLogical Supported, behaves as documented
- ARABICMath and trigonometry Supported, behaves as documented
- AREASLookup and reference not yet live-tested
- ARRAYFORMULAGoogle not yet live-tested
- ARRAYTOTEXTText Unsupported (not recognized)
- ARRAY_CONSTRAINArray not yet live-tested
- ASCText not yet live-tested
- ASINMath and trigonometry not yet live-tested
- ASINHMath and trigonometry not yet live-tested
- ATANMath and trigonometry not yet live-tested
- ATAN2Math and trigonometry not yet live-tested
- ATANHMath and trigonometry not yet live-tested
- AVEDEVStatistical Supported, behaves as documented
- AVERAGEStatistical Supported, behaves as documented
- AVERAGE.WEIGHTEDStatistical not yet live-tested
- AVERAGEAStatistical not yet live-tested
- AVERAGEIFStatistical Supported, behaves as documented
- AVERAGEIFSStatistical Supported, behaves as documented
- BAHTTEXTText not yet live-tested
- BASEMath and trigonometry Supported, behaves as documented
- BESSELIEngineering not yet live-tested
- BESSELJEngineering not yet live-tested
- BESSELKEngineering not yet live-tested
- BESSELYEngineering not yet live-tested
- BETA.DISTStatistical not yet live-tested
- BETA.INVStatistical not yet live-tested
- BETADISTCompatibility not yet live-tested
- BETAINVCompatibility not yet live-tested
- BIN2DECEngineering Supported, behaves as documented
- BIN2HEXEngineering Supported, behaves as documented
- BIN2OCTEngineering Supported, behaves as documented
- BINOM.DISTStatistical not yet live-tested
- BINOM.DIST.RANGEStatistical not yet live-tested
- BINOM.INVStatistical not yet live-tested
- BINOMDISTCompatibility not yet live-tested
- BITANDEngineering Supported, behaves as documented
- BITLSHIFTEngineering Supported, behaves as documented
- BITOREngineering Supported, behaves as documented
- BITRSHIFTEngineering Supported, behaves as documented
- BITXOREngineering Supported, behaves as documented
- BYCOLLogical Unsupported (not recognized)
- BYROWLogical Unsupported (not recognized)
- CALLAdd-in and Automation not yet live-tested
- CEILINGCompatibility Supported, behaves as documented
- CEILING.MATHMath and trigonometry Supported, behaves as documented
- CEILING.PRECISEMath and trigonometry Supported, behaves as documented
- CELLInformation not yet live-tested
- CHARText Quirk found
- CHIDISTCompatibility not yet live-tested
- CHIINVCompatibility not yet live-tested
- CHISQ.DISTStatistical not yet live-tested
- CHISQ.DIST.RTStatistical not yet live-tested
- CHISQ.INVStatistical not yet live-tested
- CHISQ.INV.RTStatistical not yet live-tested
- CHISQ.TESTStatistical not yet live-tested
- CHISQDISTStatistical Part One not yet live-tested
- CHISQINVStatistical Part One not yet live-tested
- CHITESTCompatibility not yet live-tested
- CHOOSELookup and reference Supported, behaves as documented
- CHOOSECOLSLookup and reference Supported, behaves as documented
- CHOOSEROWSLookup and reference Supported, behaves as documented
- CLEANText Supported, behaves as documented
- CODEText Supported, behaves as documented
- COLUMNLookup and reference Supported, behaves as documented
- COLUMNSLookup and reference Supported, behaves as documented
- COMBINMath and trigonometry Supported, behaves as documented
- COMBINAMath and trigonometry Supported, behaves as documented
- COMPLEXEngineering not yet live-tested
- CONCATText Supported, behaves as documented
- CONCATENATEText Supported, behaves as documented
- CONFIDENCECompatibility not yet live-tested
- CONFIDENCE.NORMStatistical not yet live-tested
- CONFIDENCE.TStatistical not yet live-tested
- CONVERTEngineering Supported, behaves as documented
- CONVERT_OOOMathematical not yet live-tested
- COPILOTText not yet live-tested
- CORRELStatistical Supported, behaves as documented
- COSMath and trigonometry not yet live-tested
- COSHMath and trigonometry not yet live-tested
- COTMath and trigonometry not yet live-tested
- COTHMath and trigonometry not yet live-tested
- COUNTStatistical Quirk found
- COUNTAStatistical Supported, behaves as documented
- COUNTBLANKStatistical Supported, behaves as documented
- COUNTIFStatistical Supported, behaves as documented
- COUNTIFSStatistical Supported, behaves as documented
- COUNTUNIQUEMath not yet live-tested
- COUPDAYBSFinancial not yet live-tested
- COUPDAYSFinancial not yet live-tested
- COUPDAYSNCFinancial not yet live-tested
- COUPNCDFinancial not yet live-tested
- COUPNUMFinancial not yet live-tested
- COUPPCDFinancial not yet live-tested
- COVARCompatibility Supported, behaves as documented
- COVARIANCE.PStatistical Supported, behaves as documented
- COVARIANCE.SStatistical Supported, behaves as documented
- CRITBINOMCompatibility not yet live-tested
- CSCMath and trigonometry not yet live-tested
- CSCHMath and trigonometry not yet live-tested
- CUBEKPIMEMBERCube not yet live-tested
- CUBEMEMBERCube not yet live-tested
- CUBEMEMBERPROPERTYCube not yet live-tested
- CUBERANKEDMEMBERCube not yet live-tested
- CUBESETCube not yet live-tested
- CUBESETCOUNTCube not yet live-tested
- CUBEVALUECube not yet live-tested
- CUMIPMTFinancial Supported, behaves as documented
- CUMIPMT_ADDFinancial Part Two not yet live-tested
- CUMPRINCFinancial Supported, behaves as documented
- CUMPRINC_ADDFinancial Part Two not yet live-tested
- CURRENTInformation not yet live-tested
- DATEDate and time Supported, behaves as documented
- DATEDIFDate and time Quirk found
- DATEVALUEDate and time Supported, behaves as documented
- DAVERAGEDatabase Supported, behaves as documented
- DAYDate and time Quirk found
- DAYSDate and time Supported, behaves as documented
- DAYS360Date and time Supported, behaves as documented
- DAYSINMONTHDate & Time not yet live-tested
- DAYSINYEARDate & Time not yet live-tested
- DBFinancial Supported, behaves as documented
- DBCSText not yet live-tested
- DCOUNTDatabase Supported, behaves as documented
- DCOUNTADatabase not yet live-tested
- DDBFinancial Supported, behaves as documented
- DDESpreadsheet not yet live-tested
- DEC2BINEngineering Supported, behaves as documented
- DEC2HEXEngineering Supported, behaves as documented
- DEC2OCTEngineering Supported, behaves as documented
- DECIMALMath and trigonometry Supported, behaves as documented
- DEGREESMath and trigonometry Supported, behaves as documented
- DELTAEngineering not yet live-tested
- DETECTLANGUAGEText not yet live-tested
- DEVSQStatistical Supported, behaves as documented
- DGETDatabase Supported, behaves as documented
- DISCFinancial not yet live-tested
- DIVIDEOperator not yet live-tested
- DMAXDatabase Supported, behaves as documented
- DMINDatabase Supported, behaves as documented
- DOLLARText Supported, behaves as documented
- DOLLARDEFinancial not yet live-tested
- DOLLARFRFinancial not yet live-tested
- DPRODUCTDatabase not yet live-tested
- DROPLookup and reference Supported, behaves as documented
- DSTDEVDatabase not yet live-tested
- DSTDEVPDatabase not yet live-tested
- DSUMDatabase Supported, behaves as documented
- DURATIONFinancial not yet live-tested
- DVARDatabase not yet live-tested
- DVARPDatabase not yet live-tested
- EASTERSUNDAYDate & Time not yet live-tested
- EDATEDate and time Supported, behaves as documented
- EFFECTFinancial Supported, behaves as documented
- EFFECT_ADDFinancial not yet live-tested
- ENCODEURLWeb not yet live-tested
- EOMONTHDate and time Supported, behaves as documented
- EPOCHTODATEDate not yet live-tested
- EQOperator not yet live-tested
- ERFEngineering not yet live-tested
- ERF.PRECISEEngineering not yet live-tested
- ERFCEngineering not yet live-tested
- ERFC.PRECISEEngineering not yet live-tested
- ERROR.TYPEInformation Quirk found
- ERRORTYPESpreadsheet not yet live-tested
- EUROCONVERTAdd-in and Automation not yet live-tested
- EVENMath and trigonometry Supported, behaves as documented
- EXACTText Supported, behaves as documented
- EXPMath and trigonometry Supported, behaves as documented
- EXPANDLookup and reference Supported, behaves as documented
- EXPON.DISTStatistical not yet live-tested
- EXPONDISTCompatibility not yet live-tested
- F.DISTStatistical not yet live-tested
- F.DIST.RTStatistical not yet live-tested
- F.INVStatistical not yet live-tested
- F.INV.RTStatistical not yet live-tested
- F.TESTStatistical not yet live-tested
- FACTMath and trigonometry Supported, behaves as documented
- FACTDOUBLEMath and trigonometry Supported, behaves as documented
- FALSELogical Supported, behaves as documented
- FDISTCompatibility not yet live-tested
- FILTERLookup and reference Quirk found
- FILTERXMLWeb not yet live-tested
- FINDText Supported, behaves as documented
- FINDBText not yet live-tested
- FINVCompatibility not yet live-tested
- FISHERStatistical not yet live-tested
- FISHERINVStatistical not yet live-tested
- FIXEDText Supported, behaves as documented
- FLATTENArray not yet live-tested
- FLOORCompatibility Quirk found
- FLOOR.MATHMath and trigonometry Supported, behaves as documented
- FLOOR.PRECISEMath and trigonometry not yet live-tested
- FORECASTStatistical Supported, behaves as documented
- FORECAST.ETSStatistical Supported, behaves as documented
- FORECAST.ETS.CONFINTStatistical not yet live-tested
- FORECAST.ETS.SEASONALITYStatistical not yet live-tested
- FORECAST.ETS.STATStatistical not yet live-tested
- FORECAST.LINEARStatistical Supported, behaves as documented
- FORMULAInformation not yet live-tested
- FORMULATEXTLookup and reference Supported, behaves as documented
- FREQUENCYStatistical Supported, behaves as documented
- FTESTCompatibility not yet live-tested
- FVFinancial Supported, behaves as documented
- FVSCHEDULEFinancial not yet live-tested
- GAMMAStatistical not yet live-tested
- GAMMA.DISTStatistical not yet live-tested
- GAMMA.INVStatistical not yet live-tested
- GAMMADISTCompatibility not yet live-tested
- GAMMAINVCompatibility not yet live-tested
- GAMMALNStatistical not yet live-tested
- GAMMALN.PRECISEStatistical not yet live-tested
- GAUSSStatistical not yet live-tested
- GCDMath and trigonometry Supported, behaves as documented
- GCD_EXCEL2003Mathematical not yet live-tested
- GEOMEANStatistical Supported, behaves as documented
- GESTEPEngineering not yet live-tested
- GETPIVOTDATALookup and reference not yet live-tested
- GOOGLEFINANCEGoogle not yet live-tested
- GOOGLETRANSLATEGoogle not yet live-tested
- GROUPBYLookup and reference Unsupported (not recognized)
- GROWTHStatistical Supported, behaves as documented
- GTOperator not yet live-tested
- GTEOperator not yet live-tested
- HARMEANStatistical Supported, behaves as documented
- HEX2BINEngineering Supported, behaves as documented
- HEX2DECEngineering Supported, behaves as documented
- HEX2OCTEngineering Supported, behaves as documented
- HLOOKUPLookup and reference Quirk found
- HOURDate and time Supported, behaves as documented
- HSTACKLookup and reference Supported, behaves as documented
- HYPERLINKLookup and reference Supported, behaves as documented
- HYPGEOM.DISTStatistical not yet live-tested
- HYPGEOMDISTCompatibility not yet live-tested
- IFLogical Supported, behaves as documented
- IFERRORLogical Quirk found
- IFNALogical Supported, behaves as documented
- IFSLogical Supported, behaves as documented
- IMABSEngineering not yet live-tested
- IMAGELookup and reference not yet live-tested
- IMAGINARYEngineering not yet live-tested
- IMARGUMENTEngineering not yet live-tested
- IMCONJUGATEEngineering not yet live-tested
- IMCOSEngineering not yet live-tested
- IMCOSHEngineering not yet live-tested
- IMCOTEngineering not yet live-tested
- IMCOTHEngineering not yet live-tested
- IMCSCEngineering not yet live-tested
- IMCSCHEngineering not yet live-tested
- IMDIVEngineering not yet live-tested
- IMEXPEngineering not yet live-tested
- IMLNEngineering not yet live-tested
- IMLOGEngineering not yet live-tested
- IMLOG10Engineering not yet live-tested
- IMLOG2Engineering not yet live-tested
- IMPORTDATAWeb not yet live-tested
- IMPORTFEEDWeb not yet live-tested
- IMPORTHTMLWeb not yet live-tested
- IMPORTRANGEWeb not yet live-tested
- IMPORTXMLWeb not yet live-tested
- IMPOWEREngineering not yet live-tested
- IMPRODUCTEngineering not yet live-tested
- IMREALEngineering not yet live-tested
- IMSECEngineering not yet live-tested
- IMSECHEngineering not yet live-tested
- IMSINEngineering not yet live-tested
- IMSINHEngineering not yet live-tested
- IMSQRTEngineering not yet live-tested
- IMSUBEngineering not yet live-tested
- IMSUMEngineering not yet live-tested
- IMTANEngineering not yet live-tested
- IMTANHEngineering not yet live-tested
- INDEXLookup and reference Supported, behaves as documented
- INDIRECTLookup and reference Supported, behaves as documented
- INFOInformation not yet live-tested
- INTMath and trigonometry Supported, behaves as documented
- INTERCEPTStatistical Supported, behaves as documented
- INTRATEFinancial not yet live-tested
- IPMTFinancial Supported, behaves as documented
- IRRFinancial Supported, behaves as documented
- ISBETWEENOperator not yet live-tested
- ISBLANKInformation Supported, behaves as documented
- ISDATEInfo not yet live-tested
- ISEMAILInfo not yet live-tested
- ISERRInformation Supported, behaves as documented
- ISERRORInformation Supported, behaves as documented
- ISEVENInformation Supported, behaves as documented
- ISEVEN_ADDInformation not yet live-tested
- ISFORMULAInformation Supported, behaves as documented
- ISLEAPYEARDate & Time not yet live-tested
- ISLOGICALInformation Supported, behaves as documented
- ISNAInformation Supported, behaves as documented
- ISNONTEXTInformation not yet live-tested
- ISNUMBERInformation Quirk found
- ISO.CEILINGMath and trigonometry not yet live-tested
- ISODDInformation Supported, behaves as documented
- ISODD_ADDInformation not yet live-tested
- ISOMITTEDInformation not yet live-tested
- ISOWEEKNUMDate and time Supported, behaves as documented
- ISPMTFinancial not yet live-tested
- ISREFInformation Supported, behaves as documented
- ISTEXTInformation Supported, behaves as documented
- ISURLWeb not yet live-tested
- JISText not yet live-tested
- JOINText not yet live-tested
- KURTStatistical not yet live-tested
- LAMBDALogical Quirk found
- LARGEStatistical Quirk found
- LCMMath and trigonometry Supported, behaves as documented
- LCM_EXCEL2003Mathematical not yet live-tested
- LEFTText Supported, behaves as documented
- LEFTBText not yet live-tested
- LENText Supported, behaves as documented
- LENBText not yet live-tested
- LETLogical Supported, behaves as documented
- LINESTStatistical Supported, behaves as documented
- LNMath and trigonometry Quirk found
- LOGMath and trigonometry Quirk found
- LOG10Math and trigonometry Quirk found
- LOGESTStatistical not yet live-tested
- LOGINVCompatibility not yet live-tested
- LOGNORM.DISTStatistical not yet live-tested
- LOGNORM.INVStatistical not yet live-tested
- LOGNORMDISTCompatibility not yet live-tested
- LOOKUPLookup and reference Supported, behaves as documented
- LOWERText Supported, behaves as documented
- LTOperator not yet live-tested
- LTEOperator not yet live-tested
- MAKEARRAYLogical Unsupported (not recognized)
- MAPLogical Unsupported (not recognized)
- MARGINOFERRORStatistical not yet live-tested
- MATCHLookup and reference Supported, behaves as documented
- MAXStatistical Supported, behaves as documented
- MAXAStatistical not yet live-tested
- MAXIFSStatistical Supported, behaves as documented
- MDETERMMath and trigonometry not yet live-tested
- MDURATIONFinancial not yet live-tested
- MEDIANStatistical Supported, behaves as documented
- MIDText Supported, behaves as documented
- MIDBText not yet live-tested
- MINStatistical Supported, behaves as documented
- MINAStatistical not yet live-tested
- MINIFSStatistical Supported, behaves as documented
- MINUSOperator not yet live-tested
- MINUTEDate and time Supported, behaves as documented
- MINVERSEMath and trigonometry not yet live-tested
- MIRRFinancial not yet live-tested
- MMULTMath and trigonometry not yet live-tested
- MODMath and trigonometry Supported, behaves as documented
- MODECompatibility Quirk found
- MODE.MULTStatistical Supported, behaves as documented
- MODE.SNGLStatistical Supported, behaves as documented
- MONTHDate and time Quirk found
- MONTHSDate & Time not yet live-tested
- MROUNDMath and trigonometry Quirk found
- MULTINOMIALMath and trigonometry Supported, behaves as documented
- MULTIPLYOperator not yet live-tested
- MUNITMath and trigonometry not yet live-tested
- NInformation Supported, behaves as documented
- NAInformation Supported, behaves as documented
- NEOperator not yet live-tested
- NEGBINOM.DISTStatistical not yet live-tested
- NEGBINOMDISTCompatibility not yet live-tested
- NETWORKDAYSDate and time Supported, behaves as documented
- NETWORKDAYS.INTLDate and time Supported, behaves as documented
- NOMINALFinancial Supported, behaves as documented
- NOMINAL_ADDFinancial Part Two not yet live-tested
- NORM.DISTStatistical not yet live-tested
- NORM.INVCompatibility not yet live-tested
- NORM.S.DISTStatistical not yet live-tested
- NORM.S.INVStatistical not yet live-tested
- NORMDISTCompatibility not yet live-tested
- NORMINVStatistical not yet live-tested
- NORMSDISTCompatibility not yet live-tested
- NORMSINVCompatibility not yet live-tested
- NOTLogical Supported, behaves as documented
- NOWDate and time Supported, behaves as documented
- NPERFinancial Supported, behaves as documented
- NPVFinancial Supported, behaves as documented
- NUMBERVALUEText Supported, behaves as documented
- OCT2BINEngineering Supported, behaves as documented
- OCT2DECEngineering Supported, behaves as documented
- OCT2HEXEngineering Supported, behaves as documented
- ODDMath and trigonometry Supported, behaves as documented
- ODDFPRICEFinancial not yet live-tested
- ODDFYIELDFinancial not yet live-tested
- ODDLPRICEFinancial not yet live-tested
- ODDLYIELDFinancial not yet live-tested
- OFFSETLookup and reference Quirk found
- ORLogical Supported, behaves as documented
- PDURATIONFinancial not yet live-tested
- PEARSONStatistical Supported, behaves as documented
- PERCENTILECompatibility Supported, behaves as documented
- PERCENTILE.EXCStatistical Quirk found
- PERCENTILE.INCStatistical Quirk found
- PERCENTOFMath and trigonometry not yet live-tested
- PERCENTRANKCompatibility Supported, behaves as documented
- PERCENTRANK.EXCStatistical not yet live-tested
- PERCENTRANK.INCStatistical not yet live-tested
- PERMUTStatistical not yet live-tested
- PERMUTATIONAStatistical not yet live-tested
- PHIStatistical not yet live-tested
- PHONETICText not yet live-tested
- PIMath and trigonometry Supported, behaves as documented
- PIVOTBYLookup and reference Unsupported (not recognized)
- PMTFinancial Supported, behaves as documented
- POISSONCompatibility not yet live-tested
- POISSON.DISTStatistical not yet live-tested
- POWOperator not yet live-tested
- POWERMath and trigonometry Quirk found
- PPMTFinancial Supported, behaves as documented
- PRICEFinancial not yet live-tested
- PRICEDISCFinancial not yet live-tested
- PRICEMATFinancial not yet live-tested
- PROBStatistical not yet live-tested
- PRODUCTMath and trigonometry Supported, behaves as documented
- PROPERText Supported, behaves as documented
- PVFinancial Supported, behaves as documented
- QUARTILECompatibility Supported, behaves as documented
- QUARTILE.EXCStatistical Supported, behaves as documented
- QUARTILE.INCStatistical Quirk found
- QUERYGoogle not yet live-tested
- QUOTIENTMath and trigonometry Supported, behaves as documented
- RADIANSMath and trigonometry Supported, behaves as documented
- RANDMath and trigonometry Supported, behaves as documented
- RAND.NVMathematical not yet live-tested
- RANDARRAYMath and trigonometry Supported, behaves as documented
- RANDBETWEENMath and trigonometry Supported, behaves as documented
- RANDBETWEEN.NVMathematical not yet live-tested
- RANKCompatibility Supported, behaves as documented
- RANK.AVGStatistical Supported, behaves as documented
- RANK.EQStatistical Supported, behaves as documented
- RATEFinancial Supported, behaves as documented
- RAWSUBTRACTMathematical not yet live-tested
- RECEIVEDFinancial not yet live-tested
- REDUCELogical Unsupported (not recognized)
- REGEXText not yet live-tested
- REGEXEXTRACTText not yet live-tested
- REGEXMATCHText not yet live-tested
- REGEXREPLACEText not yet live-tested
- REGEXTESTText not yet live-tested
- REGISTER.IDAdd-in and Automation not yet live-tested
- REPLACEText Supported, behaves as documented
- REPLACEBText not yet live-tested
- REPTText Supported, behaves as documented
- RIGHTText Supported, behaves as documented
- RIGHTBText not yet live-tested
- ROMANMath and trigonometry Supported, behaves as documented
- ROT13Add-in not yet live-tested
- ROUNDMath and trigonometry Supported, behaves as documented
- ROUNDDOWNMath and trigonometry Supported, behaves as documented
- ROUNDUPMath and trigonometry Supported, behaves as documented
- ROWLookup and reference Supported, behaves as documented
- ROWSLookup and reference Supported, behaves as documented
- RRIFinancial not yet live-tested
- RSQStatistical Supported, behaves as documented
- RTDLookup and reference not yet live-tested
- SCANLogical Unsupported (not recognized)
- SEARCHText Supported, behaves as documented
- SEARCHBText not yet live-tested
- SECMath and trigonometry not yet live-tested
- SECHMath and trigonometry not yet live-tested
- SECONDDate and time Supported, behaves as documented
- SEQUENCEMath and trigonometry Supported, behaves as documented
- SERIESSUMMath and trigonometry not yet live-tested
- SHEETInformation Supported, behaves as documented
- SHEETSInformation Supported, behaves as documented
- SIGNMath and trigonometry Supported, behaves as documented
- SINMath and trigonometry not yet live-tested
- SINHMath and trigonometry not yet live-tested
- SKEWStatistical not yet live-tested
- SKEW.PStatistical not yet live-tested
- SKEWPStatistical Part Five not yet live-tested
- SLNFinancial Supported, behaves as documented
- SLOPEStatistical Supported, behaves as documented
- SMALLStatistical Quirk found
- SORTLookup and reference Supported, behaves as documented
- SORTBYLookup and reference Supported, behaves as documented
- [SORTN](https://canispreadshe