Excel Functions List
500 functions, EN-TR

Turkish and English names, category and version of 500 Excel functions.

EnglishTurkishCategoryVersion
ABSMUTLAKMath and trigonometry
ACCRINTGERÇEKFAİZFinancial
ACCRINTMGERÇEKFAİZVFinancial
ACOSACOSMath and trigonometry
ACOSHACOSHMath and trigonometry
ACOTACOTMath and trigonometry2013
ACOTHACOTHMath and trigonometry2013
AGGREGATETOPLAMAMath and trigonometry
ADDRESSADRESLookup and reference
AMORDEGRCAMORDEGRCFinancial
AMORLINCAMORLINCFinancial
ANDVELogical
ARABICARAPMath and trigonometry2013
AREASALANSAYLookup and reference
ARRAYTOTEXTDİZİMETİNText2021
ASCASCText
ASINASİNMath and trigonometry
ASINHASİNHMath and trigonometry
ATANATANMath and trigonometry
ATAN2ATAN2Math and trigonometry
ATANHATANHMath and trigonometry
AVEDEVORTSAPStatistical
AVERAGEORTALAMAStatistical
AVERAGEAORTALAMAAStatistical
AVERAGEIFEĞERORTALAMAStatistical
AVERAGEIFSÇOKEĞERORTALAMAStatistical
BAHTTEXTBAHTMETİNText
BASETABANMath and trigonometry
BESSELIBESSELIEngineering
BESSELJBESSELJEngineering
BESSELKBESSELKEngineering
BESSELYBESSELYEngineering
BETADISTBETADAĞCompatibility
BETA.DISTBETA.DAĞStatistical2010
BETAINVBETATERSCompatibility
BIN2DECBIN2DECEngineering
BIN2HEXBIN2HEXEngineering
BIN2OCTBIN2OCTEngineering
BINOMDISTBİNOMDAĞCompatibility
BINOM.DISTBİNOM.DAĞStatistical2010
BINOM.DIST.RANGEBİNOM.DAĞ.ARALIKStatistical2013
BINOM.INVBİNOM.TERSStatistical2010
BITANDBİTVEEngineering2013
BITLSHIFTBİTSOLAKAYDIREngineering2013
BITORBİTVEYAEngineering2013
BITRSHIFTBİTSAĞAKAYDIREngineering2013
BITXORBİTÖZELVEYAEngineering2013
BYCOLBYCOLLogical2024
BYROWBYROWLogical2024
CEILINGTAVANAYUVARLACompatibility
CEILING.MATHTAVANAYUVARLA.MATEMATİKMath and trigonometry2013
CEILING.PRECISETAVANAYUVARLA.DUYARLIMath and trigonometry
CELLHÜCREInformation
CHARDAMGAText
CHIDISTKİKAREDAĞCompatibility
CHIINVKİKARETERSCompatibility
CHITESTKİKARETESTCompatibility
CHISQ.DISTKİKARE.DAĞStatistical2010
CHISQ.DIST.RTKİKARE.DAĞ.SAĞKStatistical2010
CHISQ.INVKİKARE.TERSStatistical2010
CHISQ.INV.RTKİKARE.TERS.SAĞKStatistical2010
CHISQ.TESTKİKARE.TESTStatistical2010
CHOOSEELEMANLookup and reference
CHOOSECOLSSÜTUNSEÇLookup and reference2024
CHOOSEROWSSATIRSEÇLookup and reference2024
CLEANTEMİZText
CODEKODText
COLUMNSÜTUNLookup and reference
COLUMNSSÜTUNSAYLookup and reference
COMBINKOMBİNASYONMath and trigonometry
COMBINAKOMBİNASYONAMath and trigonometry2013
COMPLEXKARMAŞIKEngineering
CONCATARALIKBİRLEŞTİRText2019
CONCATENATEBİRLEŞTİRText
CONFIDENCEGÜVENİRLİKCompatibility
CONFIDENCE.NORMGÜVENİLİRLİK.NORMStatistical2010
CONFIDENCE.TGÜVENİLİRLİK.TStatistical2010
CONVERTÇEVİREngineering
CORRELKORELASYONStatistical
COSCOSMath and trigonometry
COSHCOSHMath and trigonometry
COTCOTMath and trigonometry2013
COTHCOTHMath and trigonometry2013
COUNTBAĞ_DEĞ_SAYStatistical
COUNTABAĞ_DEĞ_DOLU_SAYStatistical
COUNTBLANKBOŞLUKSAYStatistical
COUNTIFSÇOKEĞERSAYStatistical
COUPDAYBSKUPONGÜNBDFinancial
COUPDAYSKUPONGÜNFinancial
COUPDAYSNCKUPONGÜNDSKFinancial
COUPNCDKUPONGÜNSKTFinancial
COUPNUMKUPONSAYIFinancial
COUPPCDKUPONGÜNÖKTFinancial
COVARKOVARYANSCompatibility
COVARIANCE.PKOVARYANS.PStatistical2010
COVARIANCE.SKOVARYANS.SStatistical2010
CRITBINOMKRİTİKBİNOMCompatibility
CSCCSCMath and trigonometry2013
CSCHCSCHMath and trigonometry2013
CUBEKPIMEMBERKÜPKPIÜYESİCube
CUBEMEMBERKÜPÜYESİCube
CUBEMEMBERPROPERTYKÜPÜYEÖZELLİĞİCube
CUBERANKEDMEMBERDERECELİKÜPÜYESİCube
CUBESETKÜPKÜMESİCube
CUBESETCOUNTKÜPKÜMESAYISICube
CUBEVALUEKÜPDEĞERİCube
CUMIPMTTOPÖDENENFAİZFinancial
CUMPRINCTOPANAPARAFinancial
DATETARİHDate and time
DATEDIFETARİHLİDate and time
DATEVALUETARİHSAYISIDate and time
DAVERAGEVSEÇORTDatabase
DAYGÜNDate and time
DAYSGÜNSAYDate and time2013
DAYS360GÜN360Date and time
DBAZALANBAKİYEFinancial
DBCSDBCSText2013
DCOUNTVSEÇSAYDatabase
DCOUNTAVSEÇSAYDOLUDatabase
DDBÇİFTAZALANBAKİYEFinancial
DEC2BINDEC2BINEngineering
DEC2HEXDEC2HEXEngineering
DEC2OCTDEC2OCTEngineering
DECIMALONDALIKMath and trigonometry2013
DEGREESDERECEMath and trigonometry
DELTADELTAEngineering
DETECTLANGUAGEDİLİALGILAText365
DEVSQSAPKAREStatistical
DGETVALDatabase
DISCİNDİRİMFinancial
DMAXVSEÇMAKDatabase
DMINVSEÇMİNDatabase
DOLLARLİRAText
DOLLARDELİRAONFinancial
DOLLARFRLİRAKESFinancial
DPRODUCTVSEÇÇARPDatabase
DROPBIRAKLookup and reference2024
DSTDEVVSEÇSTDSAPMADatabase
DSTDEVPVSEÇSTDSAPMASDatabase
DSUMVSEÇTOPLADatabase
DURATIONSÜREFinancial
DVARVSEÇVARDatabase
DVARPVSEÇVARSDatabase
EDATESERİTARİHDate and time
EFFECTETKİNFinancial
ENCODEURLURLKODLAWeb2013
EOMONTHSERİAYDate and time
ERFHATAİŞLEVEngineering
ERF.PRECISEHATAİŞLEV.DUYARLIEngineering2010
ERFCTÜMHATAİŞLEVEngineering
ERFC.PRECISETÜMHATAİŞLEV.DUYARLIEngineering2010
ERROR.TYPEHATA.TİPİInformation
EUROCONVERTEUROCONVERTAdd-in and Automation
EVENÇİFTMath and trigonometry
EXACTÖZDEŞText
EXPÜSMath and trigonometry
EXPANDGENİŞLETLookup and reference2024
EXPON.DISTÜSTEL.DAĞStatistical2010
EXPONDISTÜSTELDAĞCompatibility
FACTÇARPINIMMath and trigonometry
FACTDOUBLEÇİFTFAKTÖRMath and trigonometry
FALSEYANLIŞLogical
F.DISTF.DAĞStatistical2010
FDISTFDAĞCompatibility
F.DIST.RTF.DAĞ.SAĞKStatistical2010
FILTERFİLTRELookup and reference2021
FILTERXMLXMLFİLTRELEWeb2013
F.INVF.TERSStatistical2010
F.INV.RTF.TERS.SAĞKStatistical2010
FINVFTERSCompatibility
FISHERFISHERStatistical
FISHERINVFISHERTERSStatistical
FIXEDSAYIDÜZENLEText
FLOORTABANAYUVARLACompatibility
FLOOR.MATHTABANAYUVARLA.MATEMATİKMath and trigonometry2013
FLOOR.PRECISETABANAYUVARLA.DUYARLIMath and trigonometry
FORMULATEXTFORMÜLMETNİLookup and reference2013
FREQUENCYSIKLIKStatistical
F.TESTF.TESTStatistical2010
FTESTFTESTCompatibility
FVGDFinancial
FVSCHEDULEGDPROGRAMFinancial
GAMMAGAMAStatistical2013
GAMMA.DISTGAMA.DAĞStatistical2010
GAMMADISTGAMADAĞCompatibility
GAMMA.INVGAMA.TERSStatistical2010
GAMMAINVGAMATERSCompatibility
GAMMALNGAMALNStatistical
GAMMALN.PRECISEGAMALN.DUYARLIStatistical2010
GAUSSGAUSSStatistical2013
GCDOBEBMath and trigonometry
GEOMEANGEOORTStatistical
GESTEPBESINIREngineering
GETPIVOTDATAÖZETVERİALLookup and reference
GROUPBYGRUPLAÖLÇÜTLookup and reference365
GROWTHBÜYÜMEStatistical
HARMEANHARORTStatistical
HEX2BINHEX2BINEngineering
HEX2DECHEX2DECEngineering
HEX2OCTHEX2OCTEngineering
HLOOKUPYATAYARALookup and reference
HOURSAATDate and time
HSTACKYATAYYIĞLookup and reference2024
HYPERLINKKÖPRÜLookup and reference
HYPGEOM.DISTHİPERGEOM.DAĞStatistical
HYPGEOMDISTHİPERGEOMDAĞCompatibility
IFEĞERLogical
IFERROREĞERHATALogical
IFNAEĞERYOKSALogical2013
IFSÇOKEĞERLogical2019
IMABSSANMUTLAKEngineering
IMAGERESİMLookup and reference2024
IMAGINARYSANALEngineering
IMARGUMENTSANBAĞ_DEĞİŞKENEngineering
IMCONJUGATESANEŞLENEKEngineering
IMCOSSANCOSEngineering
IMCOSHSANCOSHEngineering2013
IMCOTSANCOTEngineering2013
IMCSCSANCSCEngineering2013
IMCSCHSANCSCHEngineering2013
IMDIVSANBÖLEngineering
IMEXPSANÜSEngineering
IMLNSANLNEngineering
IMLOG10SANLOG10Engineering
IMLOG2SANLOG2Engineering
IMPOWERSANKUVVETEngineering
IMPRODUCTSANÇARPEngineering
IMREALSANGERÇEKEngineering
IMSECSANSECEngineering2013
IMSECHSANSECHEngineering2013
IMSINSANSINEngineering
IMSINHSANSINHEngineering2013
IMSQRTSANKAREKÖKEngineering
IMSUBSANTOPLAEngineering
IMSUMSANÇIKAREngineering
IMTANSANTANEngineering2013
INDEXİNDİSLookup and reference
INDIRECTDOLAYLILookup and reference
INFOBİLGİInformation
INTTAMSAYIMath and trigonometry
INTERCEPTKESMENOKTASIStatistical
INTRATEFAİZORANIFinancial
IPMTFAİZTUTARIFinancial
IRRİÇ_VERİM_ORANIFinancial
ISEVENÇİFTMİInformation
ISFORMULAEFORMÜLSEInformation2013
ISOMITTEDATLANMIŞInformation2024
ISO.CEILINGISO.TAVANMath and trigonometry2013
ISOWEEKNUMISOHAFTASAYDate and time2013
ISPMTISPMTFinancial
JISJISText
KURTBASIKLIKStatistical
LAMBDALAMBDALogical2024
LARGEBÜYÜKStatistical
LCMOKEKMath and trigonometry
LEFTSOLDANText
LEFTBSOLBText
LENUZUNLUKText
LENBUZUNLUKBText
LETLETLogical2021
LINESTDOTStatistical
LNLNMath and trigonometry
LOGLOGMath and trigonometry
LOG10LOG10Math and trigonometry
LOGESTLOTStatistical
LOGINVLOGTERSCompatibility
LOGNORM.DISTLOGNORM.DAĞStatistical2010
LOGNORMDISTLOGNORMDAĞCompatibility
LOGNORM.INVLOGNORM.TERSStatistical2010
LOOKUPARALookup and reference
LOWERKÜÇÜKHARFText
MAKEARRAYDİZİOLUŞTURLogical2024
MAPMAPLogical2024
MATCHKAÇINCILookup and reference
MAXMAKStatistical
MAXAMAKAStatistical
MAXIFSÇOKEĞERMAKStatistical2019
MDETERMDETERMİNANTMath and trigonometry
MDURATIONMSÜREFinancial
MEDIANORTANCAStatistical
MIDPARÇAALText
MIDBORTABText
MINMİNStatistical
MINIFSÇOKEĞERMİNStatistical2019
MINAMİNAStatistical
MINUTEDAKİKADate and time
MINVERSEDİZEY_TERSMath and trigonometry
MIRRD_İÇ_VERİM_ORANIFinancial
MMULTDÇARPMath and trigonometry
MODMODMath and trigonometry
MODEENÇOK_OLANCompatibility
MODE.MULTENÇOK_OLAN.ÇOKStatistical2010
MODE.SNGLENÇOK_OLAN.TEKStatistical2010
MONTHAYDate and time
MROUNDKYUVARLAMath and trigonometry
MULTINOMIALÇOKTERİMLİMath and trigonometry
MUNITBİRİMMATRİSMath and trigonometry2013
NSInformation
NAYOKSAYInformation
NEGBINOM.DISTNEGBİNOM.DAĞStatistical2010
NEGBINOMDISTNEGBİNOMDAĞCompatibility
NETWORKDAYSTAMİŞGÜNÜDate and time
NETWORKDAYS.INTLTAMİŞGÜNÜ.ULUSLDate and time2010
NOMINALNOMİNALFinancial
NORM.DISTNORM.DAĞStatistical2010
NORMDISTNORMDAĞCompatibility
NORMINVNORMTERSStatistical
NORM.INVNORM.TERSCompatibility2010
NORM.S.DISTNORM.S.DAĞStatistical2010
NORMSDISTNORMSDAĞCompatibility
NORM.S.INVNORM.S.TERSStatistical2010
NORMSINVNORMSTERSCompatibility
NOTDEĞİLLogical
NOWŞİMDİDate and time
NPERTAKSİT_SAYISIFinancial
NPVNBDFinancial
NUMBERVALUESAYIDEĞERİText2013
OCT2BINOCT2BINEngineering
OCT2DECOCT2DECEngineering
OCT2HEXOCT2HEXEngineering
ODDTEKMath and trigonometry
ODDFPRICETEKYDEĞERFinancial
ODDFYIELDTEKYÖDEMEFinancial
ODDLPRICETEKSDEĞERFinancial
ODDLYIELDTEKSÖDEMEFinancial
OFFSETKAYDIRLookup and reference
ORYADALogical
PDURATIONPSÜREFinancial2013
PEARSONPEARSONStatistical
PERCENTILE.EXCYÜZDEBİRLİK.HRCStatistical2010
PERCENTILE.INCYÜZDEBİRLİK.DHLStatistical2010
PERCENTILEYÜZDEBİRLİKCompatibility
PERCENTOFPERCENTOFMath and trigonometry365
PERCENTRANK.EXCYÜZDERANK.HRCStatistical2010
PERCENTRANK.INCYÜZDERANK.DHLStatistical2010
PERCENTRANKYÜZDERANKCompatibility
PERMUTPERMÜTASYONStatistical
PERMUTATIONAPERMÜTASYONAStatistical2013
PHIPHIStatistical2013
PHONETICSESText
PIPİMath and trigonometry
PIVOTBYÖZETÖLÇÜTLookup and reference365
PMTDEVRESEL_ÖDEMEFinancial
POISSON.DISTPOISSON.DAĞStatistical2010
POISSONPOISSONCompatibility
POWERKUVVETMath and trigonometry
PPMTANA_PARA_ÖDEMESİFinancial
PRICEDEĞERFinancial
PRICEDISCDEĞERİNDFinancial
PRICEMATDEĞERVADEFinancial
PROBOLASILIKStatistical
PRODUCTÇARPIMMath and trigonometry
PROPERYAZIM.DÜZENİText
PVBDFinancial
QUARTILEDÖRTTEBİRLİKCompatibility
QUARTILE.EXCDÖRTTEBİRLİK.HRCStatistical2010
QUARTILE.INCDÖRTTEBİRLİK.DHLStatistical2010
QUOTIENTBÖLÜMMath and trigonometry
RADIANSRADYANMath and trigonometry
RANDS_SAYI_ÜRETMath and trigonometry
RANDARRAYRASGDİZİMath and trigonometry2021
RANDBETWEENRASTGELEARADAMath and trigonometry
RANK.AVGRANK.ORTStatistical2010
RANK.EQRANK.EŞİTStatistical2010
RANKRANKCompatibility
RATEFAİZ_ORANIFinancial
RECEIVEDGETİRİFinancial
REDUCEREDUCELogical2024
REGEXEXTRACTNORMİFADEAYIKLAText365
REGEXREPLACENORMİFADEDEĞİŞTİRText365
REGEXTESTNORMİFADESINAText365
REPLACEDEĞİŞTİRText
REPLACEBDEĞİŞTİRBText
REPTYİNELEText
RIGHTSAĞDANText
RIGHTBSAĞBText
ROMANROMENMath and trigonometry
ROUNDYUVARLAMath and trigonometry
ROUNDDOWNAŞAĞIYUVARLAMath and trigonometry
ROUNDUPYUKARIYUVARLAMath and trigonometry
ROWSATIRLookup and reference
ROWSSATIRSAYLookup and reference
RRIGERÇEKLEŞENYATIRIMGETİRİSİFinancial2013
RSQRKAREStatistical
RTDGZVLookup and reference
SCANSCANLogical2024
SEARCHMBULText
SEARCHBARABText
SECSECMath and trigonometry2013
SECHSECHMath and trigonometry2013
SECONDSANİYEDate and time
SEQUENCESIRALIMath and trigonometry2021
SERIESSUMSERİTOPLAMath and trigonometry
SHEETSAYFAInformation2013
SHEETSSAYFALARInformation2013
SIGNİŞARETMath and trigonometry
SINSİNMath and trigonometry
SINHSİNHMath and trigonometry
SKEWÇARPIKLIKStatistical
SKEW.PÇARPIKLIK.PStatistical2013
SLNDAFinancial
SLOPEEĞİMStatistical
SMALLKÜÇÜKStatistical
SORTSIRALALookup and reference2021
SORTBYSIRALAÖLÇÜTLookup and reference2021
SQRTKAREKÖKMath and trigonometry
SQRTPIKAREKÖKPİMath and trigonometry
STANDARDIZESTANDARTLAŞTIRMAStatistical
STDEVSTDSAPMACompatibility
STDEV.PSTDSAPMA.PStatistical2010
STDEV.SSTDSAPMA.SStatistical2010
STDEVASTDSAPMAAStatistical
STDEVPSTDSAPMASCompatibility
STDEVPASTDSAPMASAStatistical
STEYXSTHYXStatistical
STOCKHISTORYSTOKGEÇMİŞİInformation
SUBSTITUTEYERİNEKOYText
SUBTOTALALTTOPLAMMath and trigonometry
SUMTOPLAMath and trigonometry
SUMIFETOPLAMath and trigonometry
SUMIFSÇOKETOPLAMath and trigonometry
SUMPRODUCTTOPLA.ÇARPIMMath and trigonometry
SUMSQTOPKAREMath and trigonometry
SUMX2MY2TOPX2EY2Math and trigonometry
SUMX2PY2TOPX2AY2Math and trigonometry
SUMXMY2TOPXEY2Math and trigonometry
SWITCHİLKEŞLEŞENLogical2019
SYDYATFinancial
TMText
TANTANMath and trigonometry
TANHTANHMath and trigonometry
TAKEALLookup and reference2024
TBILLEQHTAHEŞFinancial
TBILLPRICEHTAHDEĞERFinancial
TBILLYIELDHTAHÖDEMEFinancial
T.DISTT.DAĞStatistical2010
T.DIST.2TT.DAĞ.2KStatistical2010
T.DIST.RTT.DAĞ.SAĞKStatistical2010
TDISTTDAĞCompatibility
TEXTMETNEÇEVİRText
TEXTAFTERSONRAKİMETİNText2024
TEXTBEFOREÖNCEKİMETİNText2024
TEXTJOINMETİNBİRLEŞTİRText2019
TEXTSPLITMETİNBÖLText2024
TIMEZAMANDate and time
TIMEVALUEZAMANSAYISIDate and time
T.INVT.TERSStatistical2010
T.INV.2TT.TERS.2KStatistical2010
TINVTTERSCompatibility
TOCOLSÜTUNALookup and reference2024
TOROWSATIRALookup and reference2024
TODAYBUGÜNDate and time
TRANSLATEDİLÇEVİRText365
TRANSPOSEDEVRİK_DÖNÜŞÜMLookup and reference
TRENDEĞİLİMStatistical
TRIMKIRPText
TRIMMEANKIRPORTALAMAStatistical
TRIMRANGEKIRPARALIĞILookup and reference365
TRUEDOĞRULogical
TRUNCNSATMath and trigonometry
T.TESTT.TESTStatistical2010
TTESTTTESTCompatibility
TYPETÜRInformation
UNICHARUNICODEKARAKTERİText2013
UNICODEUNICODEText2013
UNIQUEBENZERSİZLookup and reference2021
UPPERBÜYÜKHARFText
VALUESAYIYAÇEVİRText
VALUETOTEXTDEĞERMETİNText2021
VARVARCompatibility
VAR.PVAR.PStatistical2010
VAR.SVAR.SStatistical2010
VARAVARAStatistical
VARPVARSCompatibility
VARPAVARSAStatistical
VDBDABFinancial
VLOOKUPDÜŞEYARALookup and reference
VSTACKDÜŞEYYIĞLookup and reference2024
WEBSERVICEWEBHİZMETİWeb2013
WEEKDAYHAFTANINGÜNÜDate and time
WEEKNUMHAFTASAYDate and time
WEIBULLWEIBULLCompatibility
WEIBULL.DISTWEIBULL.DAĞStatistical2010
WORKDAYİŞGÜNÜDate and time
WORKDAY.INTLİŞGÜNÜ.ULUSLDate and time2010
WRAPCOLSSÜTUNSARLookup and reference2024
WRAPROWSSATIRSARLookup and reference2024
XIRRAİÇVERİMORANIFinancial
XLOOKUPÇAPRAZARALookup and reference2021
XMATCHÇAPRAZEŞLEŞTİRLookup and reference2021
XNPVANBDFinancial
XORÖZELVEYALogical2013
YEARYILDate and time
YEARFRACYILORANDate and time
YIELDÖDEMEFinancial
YIELDDISCÖDEMEİNDFinancial
YIELDMATÖDEMEVADEFinancial
Z.TESTZ.TESTStatistical2010
ZTESTZTESTCompatibility
COUNTIFEĞERSAYStatistical

More tools

About Excel Functions List

Turkish and English names, category and version of 500 Excel functions.

Turkish function names were taken directly from Turkish Excel, and the example results on formula pages were calculated in real Excel. Everything runs in your browser; your data is never uploaded.

How to use Excel Functions List

  1. Type or paste a formulaEnglish or Turkish.
  2. See the resultTranslation or calculation is instant.
  3. CopyPaste it into Excel with one click.

Frequently asked questions

Is Excel Functions List free?

Yes, completely free with no account.

Why does Turkish Excel use semicolons?

Turkish uses the comma as the decimal mark, so Turkish Excel separates arguments with semicolons (;). English Excel uses commas.

Is my data uploaded?

No, everything runs in your browser.