Excel reference

Excel function reference

Check which Excel worksheet functions SpreadsheetConverter v12 recognizes for conversion.

How to read this list. “Recognized for conversion” means a function name is accepted for conversion. It does not guarantee that every formula or workbook using that function will calculate correctly.

Support can depend on your edition and publishing setup. Check the calculations your workbook relies on before publishing.

The list contains 419 Excel function names recognized for conversion. Compatibility aliases remain separate names; this is not a count of distinct features.

Excel functionCategoryStatus
ABSMath and TrigonometryRecognized for conversion
ACCRINTFinancialRecognized for conversion
ACCRINTMFinancialRecognized for conversion
ACOSMath and TrigonometryRecognized for conversion
ACOSHMath and TrigonometryRecognized for conversion
ADDRESSLookup and ReferenceRecognized for conversion
AMORDEGRCFinancialRecognized for conversion
AMORLINCFinancialRecognized for conversion
ANDLogicalRecognized for conversion
AREASLookup and ReferenceRecognized for conversion
ARRAYTOTEXTTextRecognized for conversion
ASCTextRecognized for conversion
ASINMath and TrigonometryRecognized for conversion
ASINHMath and TrigonometryRecognized for conversion
ATANMath and TrigonometryRecognized for conversion
ATAN2Math and TrigonometryRecognized for conversion
ATANHMath and TrigonometryRecognized for conversion
AVEDEVStatisticalRecognized for conversion
AVERAGEStatisticalRecognized for conversion
AVERAGEAStatisticalRecognized for conversion
AVERAGEIFStatisticalRecognized for conversion
AVERAGEIFSStatisticalRecognized for conversion
BESSELIEngineeringRecognized for conversion
BESSELJEngineeringRecognized for conversion
BESSELKEngineeringRecognized for conversion
BESSELYEngineeringRecognized for conversion
BETA.DISTStatisticalRecognized for conversion
BETA.INVStatisticalRecognized for conversion
BETADISTStatisticalRecognized for conversion
BETAINVStatisticalRecognized for conversion
BIN2DECEngineeringRecognized for conversion
BIN2HEXEngineeringRecognized for conversion
BIN2OCTEngineeringRecognized for conversion
BINOM.DISTStatisticalRecognized for conversion
BINOM.DIST.RANGEStatisticalRecognized for conversion
BINOM.INVStatisticalRecognized for conversion
BINOMDISTStatisticalRecognized for conversion
BITANDEngineeringRecognized for conversion
BITLSHIFTEngineeringRecognized for conversion
BITOREngineeringRecognized for conversion
BITRSHIFTEngineeringRecognized for conversion
BITXOREngineeringRecognized for conversion
BYCOLLogicalRecognized for conversion
BYROWLogicalRecognized for conversion
CEILINGMath and TrigonometryRecognized for conversion
CEILING.MATHMath and TrigonometryRecognized for conversion
CHARTextRecognized for conversion
CHIDISTStatisticalRecognized for conversion
CHIINVStatisticalRecognized for conversion
CHISQ.DISTStatisticalRecognized for conversion
CHISQ.DIST.RTStatisticalRecognized for conversion
CHISQ.INVStatisticalRecognized for conversion
CHISQ.INV.RTStatisticalRecognized for conversion
CHISQ.TESTStatisticalRecognized for conversion
CHITESTStatisticalRecognized for conversion
CHOOSELookup and ReferenceRecognized for conversion
CHOOSECOLSLookup and ReferenceRecognized for conversion
CHOOSEROWSLookup and ReferenceRecognized for conversion
CLEANTextRecognized for conversion
CODETextRecognized for conversion
COLUMNLookup and ReferenceRecognized for conversion
COLUMNSLookup and ReferenceRecognized for conversion
COMBINMath and TrigonometryRecognized for conversion
CONCATTextRecognized for conversion
CONCATENATETextRecognized for conversion
CONFIDENCEStatisticalRecognized for conversion
CONFIDENCE.NORMStatisticalRecognized for conversion
CONFIDENCE.TStatisticalRecognized for conversion
CONVERTEngineeringRecognized for conversion
CORRELStatisticalRecognized for conversion
COSMath and TrigonometryRecognized for conversion
COSHMath and TrigonometryRecognized for conversion
COUNTStatisticalRecognized for conversion
COUNTAStatisticalRecognized for conversion
COUNTBLANKStatisticalRecognized for conversion
COUNTIFStatisticalRecognized for conversion
COUNTIFSStatisticalRecognized for conversion
COUPDAYBSFinancialRecognized for conversion
COUPDAYSFinancialRecognized for conversion
COUPDAYSNCFinancialRecognized for conversion
COUPNCDFinancialRecognized for conversion
COUPNUMFinancialRecognized for conversion
COUPPCDFinancialRecognized for conversion
COVARStatisticalRecognized for conversion
COVARIANCE.PStatisticalRecognized for conversion
COVARIANCE.SStatisticalRecognized for conversion
CRITBINOMStatisticalRecognized for conversion
CUMIPMTFinancialRecognized for conversion
CUMPRINCFinancialRecognized for conversion
DATEDate and TimeRecognized for conversion
DATEDIFDate and TimeRecognized for conversion
DATEVALUEDate and TimeRecognized for conversion
DAYDate and TimeRecognized for conversion
DAYSDate and TimeRecognized for conversion
DAYS360Date and TimeRecognized for conversion
DBFinancialRecognized for conversion
DDBFinancialRecognized for conversion
DEC2BINEngineeringRecognized for conversion
DEC2HEXEngineeringRecognized for conversion
DEC2OCTEngineeringRecognized for conversion
DEGREESMath and TrigonometryRecognized for conversion
DELTAEngineeringRecognized for conversion
DEVSQStatisticalRecognized for conversion
DISCFinancialRecognized for conversion
DOLLARTextRecognized for conversion
DOLLARDEFinancialRecognized for conversion
DOLLARFRFinancialRecognized for conversion
DROPLookup and ReferenceRecognized for conversion
DURATIONFinancialRecognized for conversion
EDATEDate and TimeRecognized for conversion
EFFECTFinancialRecognized for conversion
EOMONTHDate and TimeRecognized for conversion
ERFEngineeringRecognized for conversion
ERFCEngineeringRecognized for conversion
EVENMath and TrigonometryRecognized for conversion
EXACTTextRecognized for conversion
EXPMath and TrigonometryRecognized for conversion
EXPANDLookup and ReferenceRecognized for conversion
EXPON.DISTStatisticalRecognized for conversion
EXPONDISTStatisticalRecognized for conversion
F.DISTStatisticalRecognized for conversion
F.DIST.RTStatisticalRecognized for conversion
F.INVStatisticalRecognized for conversion
F.INV.RTStatisticalRecognized for conversion
F.TESTStatisticalRecognized for conversion
FACTMath and TrigonometryRecognized for conversion
FACTDOUBLEMath and TrigonometryRecognized for conversion
FALSELogicalRecognized for conversion
FDISTStatisticalRecognized for conversion
FILTERLookup and ReferenceRecognized for conversion
FINDTextRecognized for conversion
FINVStatisticalRecognized for conversion
FISHERStatisticalRecognized for conversion
FISHERINVStatisticalRecognized for conversion
FIXEDTextRecognized for conversion
FLOORMath and TrigonometryRecognized for conversion
FLOOR.MATHMath and TrigonometryRecognized for conversion
FORECASTStatisticalRecognized for conversion
FORECAST.ETSStatisticalRecognized for conversion
FORECAST.ETS.CONFINTStatisticalRecognized for conversion
FORECAST.ETS.SEASONALITYStatisticalRecognized for conversion
FORECAST.ETS.STATStatisticalRecognized for conversion
FORECAST.LINEARStatisticalRecognized for conversion
FREQUENCYStatisticalRecognized for conversion
FTESTStatisticalRecognized for conversion
FVFinancialRecognized for conversion
FVSCHEDULEFinancialRecognized for conversion
GAMMAStatisticalRecognized for conversion
GAMMA.DISTStatisticalRecognized for conversion
GAMMA.INVStatisticalRecognized for conversion
GAMMADISTStatisticalRecognized for conversion
GAMMAINVStatisticalRecognized for conversion
GAMMALNStatisticalRecognized for conversion
GAMMALN.PRECISEStatisticalRecognized for conversion
GAUSSStatisticalRecognized for conversion
GCDMath and TrigonometryRecognized for conversion
GEOMEANStatisticalRecognized for conversion
GESTEPEngineeringRecognized for conversion
GROWTHStatisticalRecognized for conversion
HARMEANStatisticalRecognized for conversion
HEX2BINEngineeringRecognized for conversion
HEX2DECEngineeringRecognized for conversion
HEX2OCTEngineeringRecognized for conversion
HLOOKUPLookup and ReferenceRecognized for conversion
HOURDate and TimeRecognized for conversion
HSTACKLookup and ReferenceRecognized for conversion
HYPERLINKLookup and ReferenceRecognized for conversion
HYPGEOM.DISTStatisticalRecognized for conversion
HYPGEOMDISTStatisticalRecognized for conversion
IFLogicalRecognized for conversion
IFERRORLogicalRecognized for conversion
IFNALogicalRecognized for conversion
IFSLogicalRecognized for conversion
IMLOG10EngineeringRecognized for conversion
IMSQRTEngineeringRecognized for conversion
INDEXLookup and ReferenceRecognized for conversion
INDIRECTLookup and ReferenceRecognized for conversion
INTMath and TrigonometryRecognized for conversion
INTERCEPTStatisticalRecognized for conversion
INTRATEFinancialRecognized for conversion
IPMTFinancialRecognized for conversion
IRRFinancialRecognized for conversion
ISBLANKInformationRecognized for conversion
ISERRInformationRecognized for conversion
ISERRORInformationRecognized for conversion
ISEVENInformationRecognized for conversion
ISLOGICALInformationRecognized for conversion
ISNAInformationRecognized for conversion
ISNONTEXTInformationRecognized for conversion
ISNUMBERInformationRecognized for conversion
ISODDInformationRecognized for conversion
ISOMITTEDInformationRecognized for conversion
ISPMTFinancialRecognized for conversion
ISREFInformationRecognized for conversion
ISTEXTInformationRecognized for conversion
KURTStatisticalRecognized for conversion
LAMBDALogicalRecognized for conversion
LARGEStatisticalRecognized for conversion
LCMMath and TrigonometryRecognized for conversion
LEFTTextRecognized for conversion
LENTextRecognized for conversion
LETLogicalRecognized for conversion
LINESTStatisticalRecognized for conversion
LNMath and TrigonometryRecognized for conversion
LOGMath and TrigonometryRecognized for conversion
LOG10Math and TrigonometryRecognized for conversion
LOGESTStatisticalRecognized for conversion
LOGINVStatisticalRecognized for conversion
LOGNORM.DISTStatisticalRecognized for conversion
LOGNORM.INVStatisticalRecognized for conversion
LOGNORMDISTStatisticalRecognized for conversion
LOOKUPLookup and ReferenceRecognized for conversion
LOWERTextRecognized for conversion
MAKEARRAYLogicalRecognized for conversion
MAPLogicalRecognized for conversion
MATCHLookup and ReferenceRecognized for conversion
MAXStatisticalRecognized for conversion
MAXAStatisticalRecognized for conversion
MAXIFSStatisticalRecognized for conversion
MDURATIONFinancialRecognized for conversion
MEDIANStatisticalRecognized for conversion
MIDTextRecognized for conversion
MINStatisticalRecognized for conversion
MINAStatisticalRecognized for conversion
MINIFSStatisticalRecognized for conversion
MINUTEDate and TimeRecognized for conversion
MINVERSEMath and TrigonometryRecognized for conversion
MIRRFinancialRecognized for conversion
MMULTMath and TrigonometryRecognized for conversion
MODMath and TrigonometryRecognized for conversion
MODEStatisticalRecognized for conversion
MODE.MULTStatisticalRecognized for conversion
MODE.SNGLStatisticalRecognized for conversion
MONTHDate and TimeRecognized for conversion
MROUNDMath and TrigonometryRecognized for conversion
MULTINOMIALMath and TrigonometryRecognized for conversion
MUNITMath and TrigonometryRecognized for conversion
NInformationRecognized for conversion
NAInformationRecognized for conversion
NEGBINOM.DISTStatisticalRecognized for conversion
NEGBINOMDISTStatisticalRecognized for conversion
NETWORKDAYSDate and TimeRecognized for conversion
NOMINALFinancialRecognized for conversion
NORM.DISTStatisticalRecognized for conversion
NORM.INVStatisticalRecognized for conversion
NORM.S.DISTStatisticalRecognized for conversion
NORM.S.INVStatisticalRecognized for conversion
NORMDISTStatisticalRecognized for conversion
NORMINVStatisticalRecognized for conversion
NORMSDISTStatisticalRecognized for conversion
NORMSINVStatisticalRecognized for conversion
NOTLogicalRecognized for conversion
NOWDate and TimeRecognized for conversion
NPERFinancialRecognized for conversion
NPVFinancialRecognized for conversion
NUMBERVALUETextRecognized for conversion
OCT2BINEngineeringRecognized for conversion
OCT2DECEngineeringRecognized for conversion
OCT2HEXEngineeringRecognized for conversion
ODDMath and TrigonometryRecognized for conversion
ODDFPRICEFinancialRecognized for conversion
ODDFYIELDFinancialRecognized for conversion
ODDLPRICEFinancialRecognized for conversion
ODDLYIELDFinancialRecognized for conversion
OFFSETLookup and ReferenceRecognized for conversion
ORLogicalRecognized for conversion
PEARSONStatisticalRecognized for conversion
PERCENTILEStatisticalRecognized for conversion
PERCENTILE.EXCStatisticalRecognized for conversion
PERCENTILE.INCStatisticalRecognized for conversion
PERCENTOFStatisticalRecognized for conversion
PERCENTRANKStatisticalRecognized for conversion
PERCENTRANK.EXCStatisticalRecognized for conversion
PERCENTRANK.INCStatisticalRecognized for conversion
PERMUTStatisticalRecognized for conversion
PERMUTATIONAStatisticalRecognized for conversion
PHIStatisticalRecognized for conversion
PIMath and TrigonometryRecognized for conversion
PMTFinancialRecognized for conversion
POISSONStatisticalRecognized for conversion
POISSON.DISTStatisticalRecognized for conversion
POWERMath and TrigonometryRecognized for conversion
PPMTFinancialRecognized for conversion
PRICEFinancialRecognized for conversion
PRICEDISCFinancialRecognized for conversion
PRICEMATFinancialRecognized for conversion
PROBStatisticalRecognized for conversion
PRODUCTMath and TrigonometryRecognized for conversion
PROPERTextRecognized for conversion
PVFinancialRecognized for conversion
QUARTILEStatisticalRecognized for conversion
QUARTILE.EXCStatisticalRecognized for conversion
QUARTILE.INCStatisticalRecognized for conversion
QUOTIENTMath and TrigonometryRecognized for conversion
RADIANSMath and TrigonometryRecognized for conversion
RANDMath and TrigonometryRecognized for conversion
RANDARRAYMath and TrigonometryRecognized for conversion
RANDBETWEENMath and TrigonometryRecognized for conversion
RANKStatisticalRecognized for conversion
RANK.AVGStatisticalRecognized for conversion
RANK.EQStatisticalRecognized for conversion
RATEFinancialRecognized for conversion
RECEIVEDFinancialRecognized for conversion
REDUCELogicalRecognized for conversion
REGEXEXTRACTTextRecognized for conversion
REGEXREPLACETextRecognized for conversion
REGEXTESTTextRecognized for conversion
REPLACETextRecognized for conversion
REPTTextRecognized for conversion
RIGHTTextRecognized for conversion
ROMANMath and TrigonometryRecognized for conversion
ROUNDMath and TrigonometryRecognized for conversion
ROUNDDOWNMath and TrigonometryRecognized for conversion
ROUNDUPMath and TrigonometryRecognized for conversion
ROWLookup and ReferenceRecognized for conversion
ROWSLookup and ReferenceRecognized for conversion
RSQStatisticalRecognized for conversion
SCANLogicalRecognized for conversion
SEARCHTextRecognized for conversion
SECONDDate and TimeRecognized for conversion
SEQUENCEMath and TrigonometryRecognized for conversion
SERIESSUMMath and TrigonometryRecognized for conversion
SHEETInformationRecognized for conversion
SIGNMath and TrigonometryRecognized for conversion
SINMath and TrigonometryRecognized for conversion
SINHMath and TrigonometryRecognized for conversion
SKEWStatisticalRecognized for conversion
SKEW.PStatisticalRecognized for conversion
SLNFinancialRecognized for conversion
SLOPEStatisticalRecognized for conversion
SMALLStatisticalRecognized for conversion
SORTLookup and ReferenceRecognized for conversion
SORTBYLookup and ReferenceRecognized for conversion
SQRTMath and TrigonometryRecognized for conversion
SQRTPIMath and TrigonometryRecognized for conversion
STANDARDIZEStatisticalRecognized for conversion
STDEVStatisticalRecognized for conversion
STDEV.PStatisticalRecognized for conversion
STDEV.SStatisticalRecognized for conversion
STDEVAStatisticalRecognized for conversion
STDEVPStatisticalRecognized for conversion
STDEVPAStatisticalRecognized for conversion
STEYXStatisticalRecognized for conversion
SUBSTITUTETextRecognized for conversion
SUBTOTALMath and TrigonometryRecognized for conversion
SUMMath and TrigonometryRecognized for conversion
SUMIFMath and TrigonometryRecognized for conversion
SUMIFSMath and TrigonometryRecognized for conversion
SUMPRODUCTMath and TrigonometryRecognized for conversion
SUMSQMath and TrigonometryRecognized for conversion
SWITCHLogicalRecognized for conversion
SYDFinancialRecognized for conversion
TTextRecognized for conversion
T.DISTStatisticalRecognized for conversion
T.DIST.2TStatisticalRecognized for conversion
T.DIST.RTStatisticalRecognized for conversion
T.INVStatisticalRecognized for conversion
T.INV.2TStatisticalRecognized for conversion
T.TESTStatisticalRecognized for conversion
TAKELookup and ReferenceRecognized for conversion
TANMath and TrigonometryRecognized for conversion
TANHMath and TrigonometryRecognized for conversion
TBILLEQFinancialRecognized for conversion
TBILLPRICEFinancialRecognized for conversion
TBILLYIELDFinancialRecognized for conversion
TDISTStatisticalRecognized for conversion
TEXTTextRecognized for conversion
TEXTAFTERTextRecognized for conversion
TEXTBEFORETextRecognized for conversion
TEXTJOINTextRecognized for conversion
TEXTSPLITTextRecognized for conversion
TIMEDate and TimeRecognized for conversion
TIMEVALUEDate and TimeRecognized for conversion
TINVStatisticalRecognized for conversion
TOCOLLookup and ReferenceRecognized for conversion
TODAYDate and TimeRecognized for conversion
TOROWLookup and ReferenceRecognized for conversion
TRANSPOSELookup and ReferenceRecognized for conversion
TRENDStatisticalRecognized for conversion
TRIMTextRecognized for conversion
TRIMMEANStatisticalRecognized for conversion
TRIMRANGELookup and ReferenceRecognized for conversion
TRUELogicalRecognized for conversion
TRUNCMath and TrigonometryRecognized for conversion
TTESTStatisticalRecognized for conversion
TYPEInformationRecognized for conversion
UNIQUELookup and ReferenceRecognized for conversion
UPPERTextRecognized for conversion
VALUETextRecognized for conversion
VALUETOTEXTTextRecognized for conversion
VARStatisticalRecognized for conversion
VAR.PStatisticalRecognized for conversion
VAR.SStatisticalRecognized for conversion
VARAStatisticalRecognized for conversion
VARPStatisticalRecognized for conversion
VARPAStatisticalRecognized for conversion
VDBFinancialRecognized for conversion
VLOOKUPLookup and ReferenceRecognized for conversion
VSTACKLookup and ReferenceRecognized for conversion
WEBSERVICEWebServer-side calculation required; current release support pending verification
WEEKDAYDate and TimeRecognized for conversion
WEEKNUMDate and TimeRecognized for conversion
WEIBULLStatisticalRecognized for conversion
WEIBULL.DISTStatisticalRecognized for conversion
WORKDAYDate and TimeRecognized for conversion
WRAPCOLSLookup and ReferenceRecognized for conversion
WRAPROWSLookup and ReferenceRecognized for conversion
XIRRFinancialRecognized for conversion
XLOOKUPLookup and ReferenceRecognized for conversion
XMATCHLookup and ReferenceRecognized for conversion
XNPVFinancialRecognized for conversion
XORLogicalRecognized for conversion
YEARDate and TimeRecognized for conversion
YEARFRACDate and TimeRecognized for conversion
YIELDFinancialRecognized for conversion
YIELDDISCFinancialRecognized for conversion
YIELDMATFinancialRecognized for conversion
Z.TESTStatisticalRecognized for conversion
ZTESTStatisticalRecognized for conversion
Functions requiring other solutions (103)
Excel functionCategoryStatus
ACOTMath and TrigonometryNot recognized
ACOTHMath and TrigonometryNot recognized
AGGREGATEMath and TrigonometryNot recognized
ARABICMath and TrigonometryNot recognized
BAHTTEXTTextRecognized but unsupported
BASEMath and TrigonometryNot recognized
CALLAdd-in and AutomationNot recognized
CEILING.PRECISEMath and TrigonometryNot recognized
CELLInformationRecognized but unsupported
COMBINAMath and TrigonometryNot recognized
COMPLEXEngineeringRecognized but unsupported
COPILOTAINot recognized
COTMath and TrigonometryNot recognized
COTHMath and TrigonometryNot recognized
CSCMath and TrigonometryNot recognized
CSCHMath and TrigonometryNot recognized
CUBEKPIMEMBERCubeNot recognized
CUBEMEMBERCubeNot recognized
CUBEMEMBERPROPERTYCubeNot recognized
CUBERANKEDMEMBERCubeNot recognized
CUBESETCubeNot recognized
CUBESETCOUNTCubeNot recognized
CUBEVALUECubeNot recognized
DAVERAGEDatabaseRecognized but unsupported
DBCSTextNot recognized
DCOUNTDatabaseRecognized but unsupported
DCOUNTADatabaseRecognized but unsupported
DECIMALMath and TrigonometryNot recognized
DETECTLANGUAGEAINot recognized
DGETDatabaseRecognized but unsupported
DMAXDatabaseRecognized but unsupported
DMINDatabaseRecognized but unsupported
DPRODUCTDatabaseRecognized but unsupported
DSTDEVDatabaseRecognized but unsupported
DSTDEVPDatabaseRecognized but unsupported
DSUMDatabaseRecognized but unsupported
DVARDatabaseRecognized but unsupported
DVARPDatabaseRecognized but unsupported
ENCODEURLWebNot recognized
ERF.PRECISEEngineeringNot recognized
ERFC.PRECISEEngineeringNot recognized
ERROR.TYPEInformationRecognized but unsupported
EUROCONVERTAdd-in and AutomationNot recognized
FILTERXMLWebNot recognized
FINDBTextRecognized but unsupported
FLOOR.PRECISEMath and TrigonometryNot recognized
FORMULATEXTLookup and ReferenceNot recognized
GETPIVOTDATALookup and ReferenceRecognized but unsupported
GROUPBYLookup and ReferenceNot recognized
IMABSEngineeringRecognized but unsupported
IMAGELookup and ReferenceNot recognized
IMAGINARYEngineeringRecognized but unsupported
IMARGUMENTEngineeringRecognized but unsupported
IMCONJUGATEEngineeringRecognized but unsupported
IMCOSEngineeringRecognized but unsupported
IMCOSHEngineeringNot recognized
IMCOTEngineeringNot recognized
IMCSCEngineeringNot recognized
IMCSCHEngineeringNot recognized
IMDIVEngineeringRecognized but unsupported
IMEXPEngineeringRecognized but unsupported
IMLNEngineeringRecognized but unsupported
IMLOG2EngineeringRecognized but unsupported
IMPOWEREngineeringRecognized but unsupported
IMPRODUCTEngineeringRecognized but unsupported
IMREALEngineeringRecognized but unsupported
IMSECEngineeringNot recognized
IMSECHEngineeringNot recognized
IMSINEngineeringRecognized but unsupported
IMSINHEngineeringNot recognized
IMSUBEngineeringRecognized but unsupported
IMSUMEngineeringRecognized but unsupported
IMTANEngineeringNot recognized
INFOInformationRecognized but unsupported
ISFORMULAInformationNot recognized
ISO.CEILINGMath and TrigonometryNot recognized
ISOWEEKNUMDate and TimeNot recognized
JISTextRecognized but unsupported
LEFTBTextRecognized but unsupported
LENBTextRecognized but unsupported
MDETERMMath and TrigonometryRecognized but unsupported
MIDBTextRecognized but unsupported
NETWORKDAYS.INTLDate and TimeNot recognized
PDURATIONFinancialNot recognized
PHONETICTextRecognized but unsupported
PIVOTBYLookup and ReferenceNot recognized
REGISTER.IDAdd-in and AutomationNot recognized
REPLACEBTextRecognized but unsupported
RIGHTBTextRecognized but unsupported
RRIFinancialNot recognized
RTDLookup and ReferenceRecognized but unsupported
SEARCHBTextRecognized but unsupported
SECMath and TrigonometryNot recognized
SECHMath and TrigonometryNot recognized
SHEETSInformationNot recognized
STOCKHISTORYFinancialNot recognized
SUMX2MY2Math and TrigonometryRecognized but unsupported
SUMX2PY2Math and TrigonometryRecognized but unsupported
SUMXMY2Math and TrigonometryRecognized but unsupported
TRANSLATEAINot recognized
UNICHARTextNot recognized
UNICODETextNot recognized
WORKDAY.INTLDate and TimeNot recognized

Check workbook compatibility

Recognition is one part of compatibility. Some reference expressions, text comparisons, numerical edge cases and circular calculations have documented limitations. WEBSERVICE requires server-side calculation; browser-only pages cannot fetch web-service data through this function. Test the calculations your workbook relies on before publishing.

Read the existing known issues and restrictions