Engine reference
The GRID engine is built to calculate the way Excel and Google Sheets do: the same functions with the same syntax, error values and edge cases. See also the list of supported operators.
| ABSMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| ACCRINTFinancial | Financial | ✓ | ✓ | – |
| ACCRINTMFinancial | Financial | ✓ | ✓ | – |
| ACOSMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| ACOSHMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| ACOTMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| ACOTHMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| ADDOperator | Operator | – | ✓ | ✓ |
| ADDRESSLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| AGGREGATEMath & trigonometry | Math & trigonometry | ✓ | – | ✓ |
| AIAI | AI | – | ✓ | – |
| AMORDEGRCFinancial | Financial | ✓ | – | – |
| AMORLINCFinancial | Financial | ✓ | ✓ | – |
| ANDLogical | Logical | ✓ | ✓ | ✓ |
| ARABICMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| AREASLookup & reference | Lookup & reference | ✓ | – | – |
| ARRAYFORMULAGoogle | – | ✓ | ✓ | |
| ARRAYTOTEXTText | Text | ✓ | – | – |
| ARRAY_CONSTRAINArray | Array | – | ✓ | ⊘ |
| ASCText | Text | ✓ | ✓ | – |
| ASINMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| ASINHMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| ATANMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| ATAN2Math & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| ATANHMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| AVEDEVStatistical | Statistical | ✓ | ✓ | – |
| AVERAGEStatistical | Statistical | ✓ | ✓ | ✓ |
| AVERAGE.WEIGHTEDStatistical | Statistical | – | ✓ | – |
| AVERAGEAStatistical | Statistical | ✓ | ✓ | ✓ |
| AVERAGEIFStatistical | Statistical | ✓ | ✓ | ✓ |
| AVERAGEIFSStatistical | Statistical | ✓ | ✓ | ✓ |
| BAHTTEXTText | Text | ✓ | – | ✓ |
| BASEMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| BESSELIEngineering | Engineering | ✓ | – | ✓ |
| BESSELJEngineering | Engineering | ✓ | – | ✓ |
| BESSELKEngineering | Engineering | ✓ | – | ✓ |
| BESSELYEngineering | Engineering | ✓ | – | ✓ |
| BETA.DISTStatistical | Statistical | ✓ | ✓ | ✓ |
| BETA.INVStatistical | Statistical | ✓ | ✓ | ✓ |
| BETADISTCompatibility | Compatibility | ✓ | ✓ | ✓ |
| BETAINVCompatibility | Compatibility | ✓ | ✓ | ✓ |
| BIN2DECEngineering | Engineering | ✓ | ✓ | ✓ |
| BIN2HEXEngineering | Engineering | ✓ | ✓ | ✓ |
| BIN2OCTEngineering | Engineering | ✓ | ✓ | ✓ |
| BINOM.DISTStatistical | Statistical | ✓ | ✓ | ✓ |
| BINOM.DIST.RANGEStatistical | Statistical | ✓ | – | ✓ |
| BINOM.INVStatistical | Statistical | ✓ | ✓ | ✓ |
| BINOMDISTCompatibility | Compatibility | ✓ | ✓ | ✓ |
| BITANDEngineering | Engineering | ✓ | ✓ | ✓ |
| BITLSHIFTEngineering | Engineering | ✓ | ✓ | ✓ |
| BITOREngineering | Engineering | ✓ | ✓ | ✓ |
| BITRSHIFTEngineering | Engineering | ✓ | ✓ | ✓ |
| BITXOREngineering | Engineering | ✓ | ✓ | ✓ |
| BYCOLLogical | Logical | ✓ | ✓ | ✓ |
| BYROWLogical | Logical | ✓ | ✓ | ✓ |
| CALLAdd-in & automation | Add-in & automation | ✓ | – | ⊘ |
| CEILINGMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| CEILING.MATHMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| CEILING.PRECISEMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| CELLInformation | Information | ✓ | ✓ | ✓ |
| CHARText | Text | ✓ | ✓ | ✓ |
| CHIDISTCompatibility | Compatibility | ✓ | ✓ | ✓ |
| CHIINVCompatibility | Compatibility | ✓ | ✓ | ✓ |
| CHISQ.DISTStatistical | Statistical | ✓ | ✓ | ✓ |
| CHISQ.DIST.RTStatistical | Statistical | ✓ | ✓ | ✓ |
| CHISQ.INVStatistical | Statistical | ✓ | ✓ | ✓ |
| CHISQ.INV.RTStatistical | Statistical | ✓ | ✓ | ✓ |
| CHISQ.TESTStatistical | Statistical | ✓ | ✓ | – |
| CHITESTCompatibility | Compatibility | ✓ | ✓ | – |
| CHOOSELookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| CHOOSECOLSLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| CHOOSEROWSLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| CLEANText | Text | ✓ | ✓ | ✓ |
| CODEText | Text | ✓ | ✓ | ✓ |
| COLUMNLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| COLUMNSLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| COMBINMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| COMBINAMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| COMPLEXEngineering | Engineering | ✓ | ✓ | ✓ |
| CONCATText | Text | ✓ | ✓ | ✓ |
| CONCATENATECompatibility | Compatibility | ✓ | ✓ | ✓ |
| CONFIDENCECompatibility | Compatibility | ✓ | ✓ | ✓ |
| CONFIDENCE.NORMStatistical | Statistical | ✓ | ✓ | ✓ |
| CONFIDENCE.TStatistical | Statistical | ✓ | ✓ | ✓ |
| CONVERTEngineering | Engineering | ✓ | ✓ | ✓ |
| CORRELStatistical | Statistical | ✓ | ✓ | ✓ |
| COSMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| COSHMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| COTMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| COTHMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| COUNTStatistical | Statistical | ✓ | ✓ | ✓ |
| COUNTAStatistical | Statistical | ✓ | ✓ | ✓ |
| COUNTBLANKStatistical | Statistical | ✓ | ✓ | ✓ |
| COUNTIFStatistical | Statistical | ✓ | ✓ | ✓ |
| COUNTIFSStatistical | Statistical | ✓ | ✓ | ✓ |
| COUNTUNIQUEMath & trigonometry | Math & trigonometry | – | ✓ | – |
| COUPDAYBSFinancial | Financial | ✓ | ✓ | ✓ |
| COUPDAYSFinancial | Financial | ✓ | ✓ | ✓ |
| COUPDAYSNCFinancial | Financial | ✓ | ✓ | ✓ |
| COUPNCDFinancial | Financial | ✓ | ✓ | ✓ |
| COUPNUMFinancial | Financial | ✓ | ✓ | ✓ |
| COUPPCDFinancial | Financial | ✓ | ✓ | ✓ |
| COVARCompatibility | Compatibility | ✓ | ✓ | ✓ |
| COVARIANCE.PStatistical | Statistical | ✓ | ✓ | ✓ |
| COVARIANCE.SStatistical | Statistical | ✓ | ✓ | ✓ |
| CRITBINOMCompatibility | Compatibility | ✓ | ✓ | ✓ |
| CSCMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| CSCHMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| CUBEKPIMEMBERCube | Cube | ✓ | – | ⊘ |
| CUBEMEMBERCube | Cube | ✓ | – | ⊘ |
| CUBEMEMBERPROPERTYCube | Cube | ✓ | – | ⊘ |
| CUBERANKEDMEMBERCube | Cube | ✓ | – | ⊘ |
| CUBESETCube | Cube | ✓ | – | ⊘ |
| CUBESETCOUNTCube | Cube | ✓ | – | ⊘ |
| CUBEVALUECube | Cube | ✓ | – | ⊘ |
| CUMIPMTFinancial | Financial | ✓ | ✓ | ✓ |
| CUMPRINCFinancial | Financial | ✓ | ✓ | ✓ |
| DATEDate & time | Date & time | ✓ | ✓ | ✓ |
| DATEDIFDate & time | Date & time | ✓ | ✓ | ✓ |
| DATEVALUEDate & time | Date & time | ✓ | ✓ | ✓ |
| DAVERAGEDatabase | Database | ✓ | ✓ | ✓ |
| DAYDate & time | Date & time | ✓ | ✓ | ✓ |
| DAYSDate & time | Date & time | ✓ | ✓ | ✓ |
| DAYS360Date & time | Date & time | ✓ | ✓ | ✓ |
| DBFinancial | Financial | ✓ | ✓ | ✓ |
| DBCSText | Text | ✓ | – | – |
| DCOUNTDatabase | Database | ✓ | ✓ | ✓ |
| DCOUNTADatabase | Database | ✓ | ✓ | ✓ |
| DDBFinancial | Financial | ✓ | ✓ | ✓ |
| DEC2BINEngineering | Engineering | ✓ | ✓ | ✓ |
| DEC2HEXEngineering | Engineering | ✓ | ✓ | ✓ |
| DEC2OCTEngineering | Engineering | ✓ | ✓ | ✓ |
| DECIMALMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| DEGREESMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| DELTAEngineering | Engineering | ✓ | ✓ | ✓ |
| DETECTLANGUAGEText | Text | ✓ | ✓ | ⊘ |
| DEVSQStatistical | Statistical | ✓ | ✓ | – |
| DGETDatabase | Database | ✓ | ✓ | ✓ |
| DISCFinancial | Financial | ✓ | ✓ | ✓ |
| DIVIDEOperator | Operator | – | ✓ | ✓ |
| DMAXDatabase | Database | ✓ | ✓ | ✓ |
| DMINDatabase | Database | ✓ | ✓ | ✓ |
| DOLLARText | Text | ✓ | ✓ | ✓ |
| DOLLARDEFinancial | Financial | ✓ | ✓ | ✓ |
| DOLLARFRFinancial | Financial | ✓ | ✓ | ✓ |
| DPRODUCTDatabase | Database | ✓ | ✓ | ✓ |
| DROPLookup & reference | Lookup & reference | ✓ | – | ✓ |
| DSTDEVDatabase | Database | ✓ | ✓ | ✓ |
| DSTDEVPDatabase | Database | ✓ | ✓ | ✓ |
| DSUMDatabase | Database | ✓ | ✓ | ✓ |
| DURATIONFinancial | Financial | ✓ | ✓ | ✓ |
| DVARDatabase | Database | ✓ | ✓ | ✓ |
| DVARPDatabase | Database | ✓ | ✓ | ✓ |
| EDATEDate & time | Date & time | ✓ | ✓ | ✓ |
| EFFECTFinancial | Financial | ✓ | ✓ | ✓ |
| ENCODEURLWeb | Web | ✓ | ✓ | ✓ |
| EOMONTHDate & time | Date & time | ✓ | ✓ | ✓ |
| EPOCHTODATEDate & time | Date & time | – | ✓ | ✓ |
| EQOperator | Operator | – | ✓ | ✓ |
| ERFEngineering | Engineering | ✓ | ✓ | ✓ |
| ERF.PRECISEEngineering | Engineering | ✓ | ✓ | ✓ |
| ERFCEngineering | Engineering | ✓ | ✓ | ✓ |
| ERFC.PRECISEEngineering | Engineering | ✓ | ✓ | ✓ |
| ERROR.TYPEInformation | Information | ✓ | ✓ | ✓ |
| EUROCONVERTAdd-in & automation | Add-in & automation | ✓ | – | ⊘ |
| EVENMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| EXACTText | Text | ✓ | ✓ | ✓ |
| EXPMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| EXPANDLookup & reference | Lookup & reference | ✓ | – | ✓ |
| EXPON.DISTStatistical | Statistical | ✓ | ✓ | ✓ |
| EXPONDISTCompatibility | Compatibility | ✓ | ✓ | ✓ |
| F.DISTStatistical | Statistical | ✓ | ✓ | ✓ |
| F.DIST.RTStatistical | Statistical | ✓ | ✓ | ✓ |
| F.INVStatistical | Statistical | ✓ | ✓ | ✓ |
| F.INV.RTStatistical | Statistical | ✓ | ✓ | ✓ |
| F.TESTStatistical | Statistical | ✓ | ✓ | – |
| FACTMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| FACTDOUBLEMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| FALSELogical | Logical | ✓ | ✓ | ✓ |
| FDISTCompatibility | Compatibility | ✓ | ✓ | ✓ |
| FILTERLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| FILTERXMLWeb | Web | ✓ | – | ⊘ |
| FINDText | Text | ✓ | ✓ | ✓ |
| FINDBText | Text | ✓ | ✓ | ✓ |
| FINVCompatibility | Compatibility | ✓ | ✓ | ✓ |
| FISHERStatistical | Statistical | ✓ | ✓ | ✓ |
| FISHERINVStatistical | Statistical | ✓ | ✓ | ✓ |
| FIXEDText | Text | ✓ | ✓ | ✓ |
| FLATTENArray | Array | – | ✓ | ✓ |
| FLOORCompatibility | Compatibility | ✓ | ✓ | ✓ |
| FLOOR.MATHMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| FLOOR.PRECISEMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| FORECASTCompatibility | Compatibility | ✓ | ✓ | ✓ |
| FORECAST.ETSStatistical | Statistical | ✓ | – | – |
| FORECAST.ETS.CONFINTStatistical | Statistical | ✓ | – | – |
| FORECAST.ETS.SEASONALITYStatistical | Statistical | ✓ | – | – |
| FORECAST.ETS.STATStatistical | Statistical | ✓ | – | – |
| FORECAST.LINEARStatistical | Statistical | ✓ | ✓ | ✓ |
| FORMULATEXTLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| FREQUENCYStatistical | Statistical | ✓ | ✓ | ✓ |
| FTESTCompatibility | Compatibility | ✓ | ✓ | – |
| FVFinancial | Financial | ✓ | ✓ | ✓ |
| FVSCHEDULEFinancial | Financial | ✓ | ✓ | ✓ |
| GAMMAStatistical | Statistical | ✓ | ✓ | ✓ |
| GAMMA.DISTStatistical | Statistical | ✓ | ✓ | ✓ |
| GAMMA.INVStatistical | Statistical | ✓ | ✓ | ✓ |
| GAMMADISTCompatibility | Compatibility | ✓ | ✓ | ✓ |
| GAMMAINVCompatibility | Compatibility | ✓ | ✓ | ✓ |
| GAMMALNStatistical | Statistical | ✓ | ✓ | ✓ |
| GAMMALN.PRECISEStatistical | Statistical | ✓ | ✓ | ✓ |
| GAUSSStatistical | Statistical | ✓ | ✓ | ✓ |
| GCDMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| GEOMEANStatistical | Statistical | ✓ | ✓ | ✓ |
| GESTEPEngineering | Engineering | ✓ | ✓ | ✓ |
| GETPIVOTDATALookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| GOOGLEFINANCEGoogle | – | ✓ | ⊘ | |
| GOOGLETRANSLATEGoogle | – | ✓ | ⊘ | |
| GROUPBYLookup & reference | Lookup & reference | ✓ | – | – |
| GROWTHStatistical | Statistical | ✓ | ✓ | – |
| GTOperator | Operator | – | ✓ | ✓ |
| GTEOperator | Operator | – | ✓ | ✓ |
| HARMEANStatistical | Statistical | ✓ | ✓ | – |
| HEX2BINEngineering | Engineering | ✓ | ✓ | ✓ |
| HEX2DECEngineering | Engineering | ✓ | ✓ | ✓ |
| HEX2OCTEngineering | Engineering | ✓ | ✓ | ✓ |
| HLOOKUPLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| HOURDate & time | Date & time | ✓ | ✓ | ✓ |
| HSTACKLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| HYPERLINKLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| HYPGEOM.DISTStatistical | Statistical | ✓ | ✓ | ✓ |
| HYPGEOMDISTCompatibility | Compatibility | ✓ | ✓ | ✓ |
| IFLogical | Logical | ✓ | ✓ | ✓ |
| IFERRORLogical | Logical | ✓ | ✓ | ✓ |
| IFNALogical | Logical | ✓ | ✓ | ✓ |
| IFSLogical | Logical | ✓ | ✓ | ✓ |
| IMABSEngineering | Engineering | ✓ | ✓ | ✓ |
| IMAGELookup & reference | Lookup & reference | ✓ | ✓ | ⊘ |
| IMAGINARYEngineering | Engineering | ✓ | ✓ | ✓ |
| IMARGUMENTEngineering | Engineering | ✓ | ✓ | ✓ |
| IMCONJUGATEEngineering | Engineering | ✓ | ✓ | ✓ |
| IMCOSEngineering | Engineering | ✓ | ✓ | ✓ |
| IMCOSHEngineering | Engineering | ✓ | ✓ | ✓ |
| IMCOTEngineering | Engineering | ✓ | ✓ | ✓ |
| IMCOTHEngineering | Engineering | – | ✓ | ✓ |
| IMCSCEngineering | Engineering | ✓ | ✓ | ✓ |
| IMCSCHEngineering | Engineering | ✓ | ✓ | ✓ |
| IMDIVEngineering | Engineering | ✓ | ✓ | ✓ |
| IMEXPEngineering | Engineering | ✓ | ✓ | ✓ |
| IMLNEngineering | Engineering | ✓ | ✓ | ✓ |
| IMLOGEngineering | Engineering | – | ✓ | ✓ |
| IMLOG10Engineering | Engineering | ✓ | ✓ | ✓ |
| IMLOG2Engineering | Engineering | ✓ | ✓ | ✓ |
| IMPORTDATAWeb | Web | – | ✓ | ⊘ |
| IMPORTFEEDWeb | Web | – | ✓ | ⊘ |
| IMPORTHTMLWeb | Web | – | ✓ | ⊘ |
| IMPORTRANGEWeb | Web | – | ✓ | ⊘ |
| IMPORTXMLWeb | Web | – | ✓ | ⊘ |
| IMPOWEREngineering | Engineering | ✓ | ✓ | ✓ |
| IMPRODUCTEngineering | Engineering | ✓ | ✓ | ✓ |
| IMREALEngineering | Engineering | ✓ | ✓ | ✓ |
| IMSECEngineering | Engineering | ✓ | ✓ | ✓ |
| IMSECHEngineering | Engineering | ✓ | ✓ | ✓ |
| IMSINEngineering | Engineering | ✓ | ✓ | ✓ |
| IMSINHEngineering | Engineering | ✓ | ✓ | ✓ |
| IMSQRTEngineering | Engineering | ✓ | ✓ | ✓ |
| IMSUBEngineering | Engineering | ✓ | ✓ | ✓ |
| IMSUMEngineering | Engineering | ✓ | ✓ | ✓ |
| IMTANEngineering | Engineering | ✓ | ✓ | ✓ |
| IMTANHEngineering | Engineering | – | ✓ | ✓ |
| INDEXLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| INDIRECTLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| INFOInformation | Information | ✓ | – | ✓ |
| INTMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| INTERCEPTStatistical | Statistical | ✓ | ✓ | ✓ |
| INTRATEFinancial | Financial | ✓ | ✓ | ✓ |
| IPMTFinancial | Financial | ✓ | ✓ | ✓ |
| IRRFinancial | Financial | ✓ | ✓ | ✓ |
| ISBETWEENOperator | Operator | – | ✓ | ✓ |
| ISBLANKInformation | Information | ✓ | ✓ | ✓ |
| ISDATEInformation | Information | – | ✓ | ✓ |
| ISEMAILInformation | Information | – | ✓ | ✓ |
| ISERRInformation | Information | ✓ | ✓ | ✓ |
| ISERRORInformation | Information | ✓ | ✓ | ✓ |
| ISEVENInformation | Information | ✓ | ✓ | ✓ |
| ISFORMULAInformation | Information | ✓ | ✓ | ✓ |
| ISLOGICALInformation | Information | ✓ | ✓ | ✓ |
| ISNAInformation | Information | ✓ | ✓ | ✓ |
| ISNONTEXTInformation | Information | ✓ | ✓ | ✓ |
| ISNUMBERInformation | Information | ✓ | ✓ | ✓ |
| ISO.CEILINGMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| ISODDInformation | Information | ✓ | ✓ | ✓ |
| ISOMITTEDInformation | Information | ✓ | – | ✓ |
| ISOWEEKNUMDate & time | Date & time | ✓ | ✓ | ✓ |
| ISPMTFinancial | Financial | ✓ | ✓ | ✓ |
| ISREFInformation | Information | ✓ | ✓ | ✓ |
| ISTEXTInformation | Information | ✓ | ✓ | ✓ |
| ISURLWeb | Web | – | ✓ | ✓ |
| JOINText | Text | – | ✓ | ✓ |
| KURTStatistical | Statistical | ✓ | ✓ | ✓ |
| LAMBDALogical | Logical | ✓ | ✓ | ✓ |
| LARGEStatistical | Statistical | ✓ | ✓ | ✓ |
| LCMMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| LEFTText | Text | ✓ | ✓ | ✓ |
| LEFTBText | Text | ✓ | ✓ | ✓ |
| LENText | Text | ✓ | ✓ | ✓ |
| LENBText | Text | ✓ | ✓ | ✓ |
| LETLogical | Logical | ✓ | ✓ | ✓ |
| LINESTStatistical | Statistical | ✓ | ✓ | ✓ |
| LNMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| LOGMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| LOG10Math & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| LOGESTStatistical | Statistical | ✓ | ✓ | – |
| LOGINVCompatibility | Compatibility | ✓ | ✓ | ✓ |
| LOGNORM.DISTStatistical | Statistical | ✓ | ✓ | ✓ |
| LOGNORM.INVStatistical | Statistical | ✓ | ✓ | ✓ |
| LOGNORMDISTCompatibility | Compatibility | ✓ | ✓ | ✓ |
| LOOKUPLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| LOWERText | Text | ✓ | ✓ | ✓ |
| LTOperator | Operator | – | ✓ | ✓ |
| LTEOperator | Operator | – | ✓ | ✓ |
| MAKEARRAYLogical | Logical | ✓ | ✓ | ✓ |
| MAPLogical | Logical | ✓ | ✓ | ✓ |
| MARGINOFERRORStatistical | Statistical | – | ✓ | – |
| MATCHLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| MAXStatistical | Statistical | ✓ | ✓ | ✓ |
| MAXAStatistical | Statistical | ✓ | ✓ | ✓ |
| MAXIFSStatistical | Statistical | ✓ | ✓ | ✓ |
| MDETERMMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| MDURATIONFinancial | Financial | ✓ | ✓ | ✓ |
| MEDIANStatistical | Statistical | ✓ | ✓ | ✓ |
| MIDText | Text | ✓ | ✓ | ✓ |
| MIDBText | Text | ✓ | ✓ | ✓ |
| MINStatistical | Statistical | ✓ | ✓ | ✓ |
| MINAStatistical | Statistical | ✓ | ✓ | ✓ |
| MINIFSStatistical | Statistical | ✓ | ✓ | ✓ |
| MINUSOperator | Operator | – | ✓ | ✓ |
| MINUTEDate & time | Date & time | ✓ | ✓ | ✓ |
| MINVERSEMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| MIRRFinancial | Financial | ✓ | ✓ | ✓ |
| MMULTMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| MODMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| MODECompatibility | Compatibility | ✓ | ✓ | ✓ |
| MODE.MULTStatistical | Statistical | ✓ | ✓ | ✓ |
| MODE.SNGLStatistical | Statistical | ✓ | ✓ | ✓ |
| MONTHDate & time | Date & time | ✓ | ✓ | ✓ |
| MROUNDMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| MULTINOMIALMath & trigonometry | Math & trigonometry | ✓ | ✓ | – |
| MULTIPLYOperator | Operator | – | ✓ | ✓ |
| MUNITMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| NInformation | Information | ✓ | ✓ | ✓ |
| NAInformation | Information | ✓ | ✓ | ✓ |
| NEOperator | Operator | – | ✓ | ✓ |
| NEGBINOM.DISTStatistical | Statistical | ✓ | ✓ | ✓ |
| NEGBINOMDISTCompatibility | Compatibility | ✓ | ✓ | ✓ |
| NETWORKDAYSDate & time | Date & time | ✓ | ✓ | ✓ |
| NETWORKDAYS.INTLDate & time | Date & time | ✓ | ✓ | ✓ |
| NOMINALFinancial | Financial | ✓ | ✓ | ✓ |
| NORM.DISTStatistical | Statistical | ✓ | ✓ | ✓ |
| NORM.INVStatistical | Statistical | ✓ | ✓ | ✓ |
| NORM.S.DISTStatistical | Statistical | ✓ | ✓ | ✓ |
| NORM.S.INVStatistical | Statistical | ✓ | ✓ | ✓ |
| NORMDISTCompatibility | Compatibility | ✓ | ✓ | ✓ |
| NORMINVCompatibility | Compatibility | ✓ | ✓ | ✓ |
| NORMSDISTCompatibility | Compatibility | ✓ | ✓ | ✓ |
| NORMSINVCompatibility | Compatibility | ✓ | ✓ | ✓ |
| NOTLogical | Logical | ✓ | ✓ | ✓ |
| NOWDate & time | Date & time | ✓ | ✓ | ✓ |
| NPERFinancial | Financial | ✓ | ✓ | ✓ |
| NPVFinancial | Financial | ✓ | ✓ | ✓ |
| NUMBERVALUEText | Text | ✓ | – | ✓ |
| OCT2BINEngineering | Engineering | ✓ | ✓ | ✓ |
| OCT2DECEngineering | Engineering | ✓ | ✓ | ✓ |
| OCT2HEXEngineering | Engineering | ✓ | ✓ | ✓ |
| ODDMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| ODDFPRICEFinancial | Financial | ✓ | – | – |
| ODDFYIELDFinancial | Financial | ✓ | – | – |
| ODDLPRICEFinancial | Financial | ✓ | – | – |
| ODDLYIELDFinancial | Financial | ✓ | – | – |
| OFFSETLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| ORLogical | Logical | ✓ | ✓ | ✓ |
| PDURATIONFinancial | Financial | ✓ | ✓ | ✓ |
| PEARSONStatistical | Statistical | ✓ | ✓ | – |
| PERCENTILECompatibility | Compatibility | ✓ | ✓ | ✓ |
| PERCENTILE.EXCStatistical | Statistical | ✓ | ✓ | ✓ |
| PERCENTILE.INCStatistical | Statistical | ✓ | ✓ | ✓ |
| PERCENTOFMath & trigonometry | Math & trigonometry | ✓ | – | – |
| PERCENTRANKCompatibility | Compatibility | ✓ | ✓ | ✓ |
| PERCENTRANK.EXCStatistical | Statistical | ✓ | ✓ | ✓ |
| PERCENTRANK.INCStatistical | Statistical | ✓ | ✓ | ✓ |
| PERMUTStatistical | Statistical | ✓ | ✓ | ✓ |
| PERMUTATIONAStatistical | Statistical | ✓ | ✓ | ✓ |
| PHIStatistical | Statistical | ✓ | ✓ | ✓ |
| PHONETICText | Text | ✓ | – | – |
| PIMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| PIVOTBYLookup & reference | Lookup & reference | ✓ | – | – |
| PMTFinancial | Financial | ✓ | ✓ | ✓ |
| POISSONCompatibility | Compatibility | ✓ | ✓ | ✓ |
| POISSON.DISTStatistical | Statistical | ✓ | ✓ | ✓ |
| POWOperator | Operator | – | ✓ | ✓ |
| POWERMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| PPMTFinancial | Financial | ✓ | ✓ | ✓ |
| PRICEFinancial | Financial | ✓ | ✓ | ✓ |
| PRICEDISCFinancial | Financial | ✓ | ✓ | ✓ |
| PRICEMATFinancial | Financial | ✓ | ✓ | ✓ |
| PROBStatistical | Statistical | ✓ | ✓ | – |
| PRODUCTMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| PROPERText | Text | ✓ | ✓ | ✓ |
| PVFinancial | Financial | ✓ | ✓ | ✓ |
| QUARTILECompatibility | Compatibility | ✓ | ✓ | ✓ |
| QUARTILE.EXCStatistical | Statistical | ✓ | ✓ | ✓ |
| QUARTILE.INCStatistical | Statistical | ✓ | ✓ | ✓ |
| QUERYGoogle | – | ✓ | ✓ | |
| QUOTIENTMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| RADIANSMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| RANDMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| RANDARRAYMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| RANDBETWEENMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| RANKCompatibility | Compatibility | ✓ | ✓ | ✓ |
| RANK.AVGStatistical | Statistical | ✓ | ✓ | ✓ |
| RANK.EQStatistical | Statistical | ✓ | ✓ | ✓ |
| RATEFinancial | Financial | ✓ | ✓ | ✓ |
| RECEIVEDFinancial | Financial | ✓ | ✓ | ✓ |
| REDUCELogical | Logical | ✓ | ✓ | ✓ |
| REGEXEXTRACTText | Text | ✓ | ✓ | ✓ |
| REGEXMATCHText | Text | – | ✓ | ✓ |
| REGEXREPLACEText | Text | ✓ | ✓ | ✓ |
| REGEXTESTText | Text | ✓ | – | – |
| REGISTER.IDAdd-in & automation | Add-in & automation | ✓ | – | ⊘ |
| REPLACEText | Text | ✓ | ✓ | ✓ |
| REPLACEBText | Text | ✓ | ✓ | ✓ |
| REPTText | Text | ✓ | ✓ | ✓ |
| RIGHTText | Text | ✓ | ✓ | ✓ |
| RIGHTBText | Text | ✓ | ✓ | ✓ |
| ROMANMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| ROUNDMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| ROUNDDOWNMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| ROUNDUPMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| ROWLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| ROWSLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| RRIFinancial | Financial | ✓ | ✓ | ✓ |
| RSQStatistical | Statistical | ✓ | ✓ | – |
| RTDLookup & reference | Lookup & reference | ✓ | – | ⊘ |
| SCANLogical | Logical | ✓ | ✓ | ✓ |
| SEARCHText | Text | ✓ | ✓ | ✓ |
| SEARCHBText | Text | ✓ | ✓ | ✓ |
| SECMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| SECHMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| SECONDDate & time | Date & time | ✓ | ✓ | ✓ |
| SEQUENCEMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| SERIESSUMMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| SHEETInformation | Information | ✓ | ✓ | – |
| SHEETSInformation | Information | ✓ | ✓ | – |
| SIGNMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| SINMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| SINHMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| SKEWStatistical | Statistical | ✓ | ✓ | ✓ |
| SKEW.PStatistical | Statistical | ✓ | ✓ | ✓ |
| SLNFinancial | Financial | ✓ | ✓ | ✓ |
| SLOPEStatistical | Statistical | ✓ | ✓ | ✓ |
| SMALLStatistical | Statistical | ✓ | ✓ | ✓ |
| SORTLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| SORTBYLookup & reference | Lookup & reference | ✓ | – | ✓ |
| SORTNFilter | Filter | – | ✓ | ✓ |
| SPARKLINEGoogle | – | ✓ | ⊘ | |
| SPLITText | Text | – | ✓ | ✓ |
| SQRTMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| SQRTPIMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| STANDARDIZEStatistical | Statistical | ✓ | ✓ | ✓ |
| STDEVCompatibility | Compatibility | ✓ | ✓ | ✓ |
| STDEV.PStatistical | Statistical | ✓ | ✓ | ✓ |
| STDEV.SStatistical | Statistical | ✓ | ✓ | ✓ |
| STDEVAStatistical | Statistical | ✓ | ✓ | ✓ |
| STDEVPCompatibility | Compatibility | ✓ | ✓ | ✓ |
| STDEVPAStatistical | Statistical | ✓ | ✓ | ✓ |
| STEYXStatistical | Statistical | ✓ | ✓ | – |
| STOCKHISTORYInformation | Information | ✓ | – | ⊘ |
| SUBSTITUTEText | Text | ✓ | ✓ | ✓ |
| SUBTOTALMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| SUMMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| SUMIFMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| SUMIFSMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| SUMPRODUCTMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| SUMSQMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| SUMX2MY2Math & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| SUMX2PY2Math & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| SUMXMY2Math & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| SWITCHLogical | Logical | ✓ | ✓ | ✓ |
| SYDFinancial | Financial | ✓ | ✓ | ✓ |
| TText | Text | ✓ | ✓ | ✓ |
| T.DISTStatistical | Statistical | ✓ | ✓ | ✓ |
| T.DIST.2TStatistical | Statistical | ✓ | ✓ | ✓ |
| T.DIST.RTStatistical | Statistical | ✓ | ✓ | ✓ |
| T.INVStatistical | Statistical | ✓ | ✓ | ✓ |
| T.INV.2TStatistical | Statistical | ✓ | ✓ | ✓ |
| T.TESTStatistical | Statistical | ✓ | ✓ | – |
| TAKELookup & reference | Lookup & reference | ✓ | – | ✓ |
| TANMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| TANHMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| TBILLEQFinancial | Financial | ✓ | ✓ | ✓ |
| TBILLPRICEFinancial | Financial | ✓ | ✓ | ✓ |
| TBILLYIELDFinancial | Financial | ✓ | ✓ | ✓ |
| TDISTCompatibility | Compatibility | ✓ | ✓ | ✓ |
| TEXTText | Text | ✓ | ✓ | ✓ |
| TEXTAFTERText | Text | ✓ | – | ✓ |
| TEXTBEFOREText | Text | ✓ | – | ✓ |
| TEXTJOINText | Text | ✓ | ✓ | ✓ |
| TEXTSPLITText | Text | ✓ | – | ✓ |
| TIMEDate & time | Date & time | ✓ | ✓ | ✓ |
| TIMEVALUEDate & time | Date & time | ✓ | ✓ | ✓ |
| TINVCompatibility | Compatibility | ✓ | ✓ | ✓ |
| TOCOLLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| TODAYDate & time | Date & time | ✓ | ✓ | ✓ |
| TOROWLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| TO_DATEParser | Parser | – | ✓ | ✓ |
| TO_DOLLARSParser | Parser | – | ✓ | ✓ |
| TO_PERCENTParser | Parser | – | ✓ | ✓ |
| TO_PURE_NUMBERParser | Parser | – | ✓ | ✓ |
| TO_TEXTParser | Parser | – | ✓ | ✓ |
| TRANSLATEText | Text | ✓ | – | – |
| TRANSPOSELookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| TRENDStatistical | Statistical | ✓ | ✓ | ✓ |
| TRIMText | Text | ✓ | ✓ | ✓ |
| TRIMMEANStatistical | Statistical | ✓ | ✓ | – |
| TRIMRANGELookup & reference | Lookup & reference | ✓ | – | ✓ |
| TRUELogical | Logical | ✓ | ✓ | ✓ |
| TRUNCMath & trigonometry | Math & trigonometry | ✓ | ✓ | ✓ |
| TTESTCompatibility | Compatibility | ✓ | ✓ | – |
| TYPEInformation | Information | ✓ | ✓ | ✓ |
| UMINUSOperator | Operator | – | ✓ | ✓ |
| UNARY_PERCENTOperator | Operator | – | ✓ | ✓ |
| UNICHARText | Text | ✓ | ✓ | ✓ |
| UNICODEText | Text | ✓ | ✓ | ✓ |
| UNIQUELookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| UPLUSOperator | Operator | – | ✓ | ✓ |
| UPPERText | Text | ✓ | ✓ | ✓ |
| VALUEText | Text | ✓ | ✓ | ✓ |
| VALUETOTEXTText | Text | ✓ | – | – |
| VARCompatibility | Compatibility | ✓ | ✓ | ✓ |
| VAR.PStatistical | Statistical | ✓ | ✓ | ✓ |
| VAR.SStatistical | Statistical | ✓ | ✓ | ✓ |
| VARAStatistical | Statistical | ✓ | ✓ | ✓ |
| VARPCompatibility | Compatibility | ✓ | ✓ | – |
| VARPAStatistical | Statistical | ✓ | ✓ | ✓ |
| VDBFinancial | Financial | ✓ | ✓ | – |
| VLOOKUPLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| VSTACKLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| WEBSERVICEWeb | Web | ✓ | – | ⊘ |
| WEEKDAYDate & time | Date & time | ✓ | ✓ | ✓ |
| WEEKNUMDate & time | Date & time | ✓ | ✓ | ✓ |
| WEIBULLCompatibility | Compatibility | ✓ | ✓ | ✓ |
| WEIBULL.DISTStatistical | Statistical | ✓ | ✓ | ✓ |
| WORKDAYDate & time | Date & time | ✓ | ✓ | ✓ |
| WORKDAY.INTLDate & time | Date & time | ✓ | ✓ | ✓ |
| WRAPCOLSLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| WRAPROWSLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| XIRRFinancial | Financial | ✓ | ✓ | ✓ |
| XLOOKUPLookup & reference | Lookup & reference | ✓ | ✓ | ✓ |
| XMATCHLookup & reference | Lookup & reference | ✓ | – | ✓ |
| XNPVFinancial | Financial | ✓ | ✓ | ✓ |
| XORLogical | Logical | ✓ | ✓ | ✓ |
| YEARDate & time | Date & time | ✓ | ✓ | ✓ |
| YEARFRACDate & time | Date & time | ✓ | ✓ | ✓ |
| YIELDFinancial | Financial | ✓ | ✓ | ✓ |
| YIELDDISCFinancial | Financial | ✓ | ✓ | ✓ |
| YIELDMATFinancial | Financial | ✓ | ✓ | ✓ |
| Z.TESTStatistical | Statistical | ✓ | ✓ | – |
| ZTESTCompatibility | Compatibility | ✓ | ✓ | – |
✓ supported– not supported⊘ not relevant
Of the 567 functions Excel and Google Sheets ship between them, the engine evaluates 492. The remaining 75 fall into two groups, and both are rare in real workbooks: the share of formulas they appear in is far smaller than their share of this list.
Seldom-used functions the engine does not evaluate yet: statistical tests and regressions (T.TEST, F.TEST, PEARSON, LOGEST, TRIMMEAN), the FORECAST.ETS family (FORECAST.ETS), odd-period bond pricing (ODDFPRICE, ODDLYIELD, ACCRINT), double-byte text helpers (ASC, DBCS, PHONETIC) and the newest arrivals (GROUPBY, PIVOTBY, REGEXTEST). A workbook that uses one still opens and calculates; only that cell shows an error.
They only make sense inside the application that hosts them: fetching live data from the web (WEBSERVICE, IMPORTRANGE, GOOGLEFINANCE, STOCKHISTORY), querying an OLAP cube (the CUBE functions), calling COM add-ins (CALL, REGISTER.ID, RTD) or rendering application widgets (IMAGE, SPARKLINE). An engine that runs headless, in-process and offline has no host for them, so they are marked ⊘ rather than counted as gaps.
Argument signatures for every supported function are in the engine documentation.
Support status is read from the GRID engine, @grid-is/apiary 17.0.0, last updated 2026-09-15. Function availability follows Microsoft's and Google's published function lists, last refreshed 2026-09-15.
Install the engine from npm with a free evaluation license and start building today. When you are ready to ship, talk to us. Most teams are surprised how quickly they go from first install to production, with direct support from the GRID team throughout.