Formula translator / Turkish

Excel functions in Turkish and English

Excel işlevleri Türkçe ve İngilizce

Excel in Turkish has its own name for most functions: VLOOKUP is DÜŞEYARA and IF is EĞER. Paste a formula to translate it either way, or look a function up in the list below.

An example

English: =IF(VLOOKUP(A2, Prices!A:C, 3, FALSE)>=1.5, "High", "Low")

Turkish: =EĞER(DÜŞEYARA(A2; Prices!A:C; 3; YANLIŞ)>=1,5; "High"; "Low")

In Turkish, Excel usually separates arguments with a semicolon and writes decimals with a comma (1,5). Excel takes both from your computer's region settings.

All 436 functions in Turkish and English

TRUE is DOĞRU and FALSE is YANLIŞ.

EnglishTurkishWhat it does
ABSMUTLAKThe absolute value: the number without its sign.
ACOSACOSThe angle, in radians, whose cosine is the number.
ACOSHACOSHThe inverse hyperbolic cosine of a number.
ACOTACOTThe angle, in radians, whose cotangent is the number. The result is between 0 and π.
ACOTHACOTH
ADDRESSADRESBuilds a cell address as text from a row number and a column number.
AGGREGATETOPLAMALike SUBTOTAL with more calculations, and it can ignore errors in the range.
ANDVETRUE only if every condition is TRUE.
ARABICARAPÇATurns Roman numerals into a number.
ARRAYTOTEXTDİZİMETİNAll the values of a range written out as one piece of text.
ASINASİNThe angle, in radians, whose sine is the number. Wrap it in DEGREES() for degrees.
ASINHASİNHThe inverse hyperbolic sine of a number.
ATANATANThe angle, in radians, whose tangent is the number.
ATAN2ATAN2The angle, in radians, from the x-axis to the point (x, y). Unlike ATAN it knows which quarter of the circle the point is in.
ATANHATANHThe inverse hyperbolic tangent of a number.
AVEDEVORTSAPThe average distance of the values from their mean: a plain measure of how spread out they are.
AVERAGEORTALAMAThe arithmetic mean of the numbers.
AVERAGEAORTALAMAAThe average, counting text in a range as 0 and TRUE as 1.
AVERAGEIFEĞERORTALAMAAverages the cells that meet a condition.
AVERAGEIFSÇOKEĞERORTALAMAAverages the cells that meet every one of several conditions.
BASETABANWrites a number in another base, such as binary (2) or hexadecimal (16), as text.
BESSELIBESSELI
BESSELJBESSELJ
BESSELKBESSELK
BESSELYBESSELY
BETA.DISTBETA.DAĞThe beta distribution, for shares and percentages that vary between two bounds.
BETA.INVBETA.TERSThe value below which a given share of a beta distribution falls.
BETADISTBETADAĞThe chance of x or less in a beta distribution. The older form of BETA.DIST.
BETAINVBETATERS
BIN2DECBIN2DECTurns a binary number into an ordinary one.
BIN2HEXBIN2HEX
BIN2OCTBIN2OCT
BINOM.DISTBİNOM.DAĞThe chance of a number of successes in a set number of tries, each with the same chance.
BINOM.DIST.RANGEBİNOM.DAĞ.ARALIKThe chance that the number of successes in a set of tries lands between two counts.
BINOM.INVBİNOM.TERSThe smallest number of successes whose cumulative binomial chance reaches a target: how many to plan for.
BINOMDISTBİNOMDAĞ
BITANDBİTVECompares two whole numbers bit by bit and keeps the bits that are set in both.
BITLSHIFTBİTSOLAKAYDIRMoves the bits of a whole number to the left, which doubles it for every bit moved.
BITORBİTVEYACompares two whole numbers bit by bit and keeps the bits that are set in either.
BITRSHIFTBİTSAĞAKAYDIRMoves the bits of a whole number to the right, which halves it for every bit moved and drops the remainder.
BITXORBİTÖZELVEYACompares two whole numbers bit by bit and keeps the bits that are set in one but not the other.
CEILINGTAVANAYUVARLARounds a number up to the nearest multiple (away from zero when both are negative).
CEILING.MATHTAVANAYUVARLA.MATEMATİKRounds a number up to the nearest multiple; mode rounds negative numbers away from zero.
CEILING.PRECISETAVANAYUVARLA.DUYARLI
CELLHÜCRETells you something about a cell: its address, row, column, contents, number format or the type of value in it.
CHARDAMGAThe character for a character code.
CHIDISTKİKAREDAĞ
CHIINVKİKARETERS
CHISQ.DISTKİKARE.DAĞThe chi-square distribution: the chance of a value of x or less, or the height of the curve at x.
CHISQ.DIST.RTKİKARE.DAĞ.SAĞKThe right tail of the chi-square distribution: the chance of a value greater than x. This is the p-value of a chi-square statistic.
CHISQ.INVKİKARE.TERSThe value below which a given share of the chi-square distribution falls.
CHISQ.INV.RTKİKARE.TERS.SAĞKThe chi-square value with a given share of the distribution above it: the critical value of a chi-square test.
CHISQ.TESTKİKARE.TESTThe chi-square test of independence: the chance of counts this far from the expected ones if nothing but chance were at work.
CHITESTKİKARETEST
CHOOSEELEMANPicks a value from a list by its position.
CHOOSECOLSSÜTUNSEÇReturns the columns you name from an array, in the order you name them.
CHOOSEROWSSATIRSEÇReturns the rows you name from an array, in the order you name them.
CLEANTEMİZRemoves non-printable characters.
CODEKODThe character code of the first character.
COLUMNSÜTUNThe column number of a reference (A = 1).
COLUMNSSÜTUNSAYHow many columns a range has.
COMBINKOMBİNASYONHow many ways to choose a number of items from a group, when the order does not matter.
COMBINAKOMBİNASYONAThe number of ways to choose items when the same item may be chosen more than once and the order does not matter.
COMPLEXKARMAŞIK
CONCATARALIKBİRLEŞTİRJoins text from several values or ranges.
CONCATENATEBİRLEŞTİRJoins several text values (older version of CONCAT).
CONFIDENCEGÜVENİRLİK
CONFIDENCE.NORMGÜVENİLİRLİK.NORMThe margin of error for an average: add and subtract it to get the confidence interval.
CONFIDENCE.TGÜVENİLİRLİK.TThe margin of error of a sample mean, using Student's t-distribution. Add it to and subtract it from the mean for the confidence interval.
CONVERTÇEVİRConverts a number from one unit of measurement to another: miles to kilometres, pounds to kilograms, Fahrenheit to Celsius.
CORRELKORELASYONThe correlation coefficient of two data sets: from −1 (opposite) through 0 (unrelated) to 1 (move together).
COSCOSThe cosine of an angle given in radians.
COSHCOSHThe hyperbolic cosine of a number.
COTCOTThe cotangent of an angle: 1 divided by its tangent.
COTHCOTH
COUNTBAĞ_DEĞ_SAYCounts cells that contain numbers.
COUNTABAĞ_DEĞ_DOLU_SAYCounts cells that are not empty.
COUNTBLANKBOŞLUKSAYCounts empty cells in a range.
COUNTIFEĞERSAYCounts the cells that meet a condition.
COUNTIFSÇOKEĞERSAYCounts the rows that meet every one of several conditions.
COVARKOVARYANS
COVARIANCE.PKOVARYANS.PPopulation covariance: the average product of the deviations of each pair from their means.
COVARIANCE.SKOVARYANS.SSample covariance: like COVARIANCE.P, but divides by n − 1 for a sample.
CRITBINOMKRİTİKBİNOM
CSCCSCThe cosecant of an angle: 1 divided by its sine.
CSCHCSCH
CUMIPMTTOPÖDENENFAİZTotal interest paid between two payment numbers.
CUMPRINCTOPANAPARATotal paid off the loan itself (not interest) between two payment numbers.
DATETARİHBuilds a date from a year, month and day.
DATEDIFETARİHLİThe difference between two dates in years, months or days.
DATEVALUETARİHSAYISIConverts a date written as text into a date serial number.
DAVERAGEVSEÇORTThe average of a column of a table for the rows that meet conditions written in cells.
DAYGÜNThe day of the month (1-31).
DAYSGÜNSAYThe number of days between two dates.
DAYS360GÜN360Days between two dates in a year of twelve 30-day months, as some accounts count them.
DBAZALANBAKİYEDepreciation for one period, losing the same percentage of the remaining value each period.
DCOUNTVSEÇSAYCounts the numbers in a column of a table for the rows that meet conditions written in cells.
DCOUNTAVSEÇSAYDOLUCounts the cells that are not empty in a column of a table for the rows that meet conditions written in cells.
DDBÇİFTAZALANBAKİYEDepreciation for one period at double the straight-line rate (or another multiple).
DEC2BINDEC2BINWrites a whole number in binary.
DEC2HEXDEC2HEXWrites a whole number in hexadecimal.
DEC2OCTDEC2OCT
DECIMALONDALIKTurns a number written in another base, as text, into an ordinary number.
DEGREESDERECETurns radians into degrees.
DELTADELTATests whether two numbers are equal: 1 when they are, 0 when they are not.
DEVSQSAPKAREThe sum of the squared distances of the values from their mean.
DGETVALThe one value in a column of a table from the single row that meets the conditions. Two matching rows are an error, which makes it a strict lookup.
DMAXVSEÇMAKThe largest number in a column of a table among the rows that meet conditions written in cells.
DMINVSEÇMİNThe smallest number in a column of a table among the rows that meet conditions written in cells.
DOLLARLİRAA number as text in currency style: $1,234.57, with negatives in brackets.
DOLLARDELİRAONTurns a price written with a fraction, as bond prices are (1.02 meaning 1 and 2/16), into an ordinary decimal.
DOLLARFRLİRAKESTurns a decimal price into one written with a fraction, as bond prices are: 1.125 in sixteenths is 1.02.
DPRODUCTVSEÇÇARPMultiplies the numbers in a column of a table for the rows that meet conditions written in cells.
DROPBIRAKRemoves the first or last rows or columns of an array.
DSTDEVVSEÇSTDSAPMAThe standard deviation of a column of a table for the matching rows, treating them as a sample.
DSTDEVPVSEÇSTDSAPMASThe standard deviation of a column of a table for the matching rows, treating them as the whole population.
DSUMVSEÇTOPLAAdds up a column of a table for the rows that meet conditions written in cells.
DVARVSEÇVARThe variance of a column of a table for the matching rows, treating them as a sample.
DVARPVSEÇVARSThe variance of a column of a table for the matching rows, treating them as the whole population.
EDATESERİTARİHThe same day a number of months before or after a date.
EFFECTETKİNThe yearly rate you really pay or earn, once interest is added several times a year.
ENCODEURLURLKODLAText made safe to put in a web address: spaces become %20, and so on.
EOMONTHSERİAYThe last day of the month, a number of months away.
ERFHATAİŞLEVThe error function between two limits. With one limit it runs from 0.
ERF.PRECISEHATAİŞLEV.DUYARLIThe error function from 0 to x.
ERFCTÜMHATAİŞLEVThe complementary error function: 1 - ERF(x).
ERROR.TYPEHATA.TİPİA number for the kind of error: 2 #DIV/0!, 3 #VALUE!, 4 #REF!, 5 #NAME?, 6 #NUM!, 7 #N/A.
EVENÇİFTRounds away from zero to the next even integer.
EXACTÖZDEŞTRUE if two text values are exactly the same, including case.
EXPÜSe raised to a power.
EXPANDGENİŞLETGrows an array to a set number of rows and columns, filling the new cells.
EXPON.DISTÜSTEL.DAĞThe exponential distribution, for the time between events that happen at a steady rate: the chance of waiting x or less.
EXPONDISTÜSTELDAĞ
F.DISTF.DAĞThe F-distribution: the chance of a ratio of two variances of x or less, or the height of the curve at x.
F.DIST.RTF.DAĞ.SAĞKThe right tail of the F-distribution: the chance of a ratio greater than x. This is the p-value of an F statistic.
F.INVF.TERSThe value below which a given share of the F-distribution falls.
F.INV.RTF.TERS.SAĞKThe F value with a given share of the distribution above it: the critical value of an F-test.
F.TESTF.TESTThe F-test: the chance that two samples would have variances this different if their populations varied equally. Two-tailed.
FACTÇARPINIMFactorial: 1 × 2 × … × n.
FACTDOUBLEÇİFTFAKTÖRThe double factorial: the number times every second whole number below it (7 × 5 × 3 × 1).
FDISTFDAĞ
FILTERFİLTREKeeps only the rows that meet a condition. The result spills.
FINDBULPosition of one text inside another (case-sensitive).
FINVFTERS
FISHERFISHERThe Fisher transformation of a correlation, which makes it close to normally distributed so that it can be tested.
FISHERINVFISHERTERSTurns a Fisher-transformed value back into a correlation.
FIXEDSAYIDÜZENLEA number as text, rounded to a set number of decimals, with or without commas.
FLOORTABANAYUVARLARounds a number down to the nearest multiple (toward zero when both are negative).
FLOOR.MATHTABANAYUVARLA.MATEMATİKRounds a number down to the nearest multiple; mode rounds negative numbers toward zero.
FLOOR.PRECISETABANAYUVARLA.DUYARLI
FORECASTTAHMİNPredicts a y value for a new x from the best-fit straight line through known data.
FORMULATEXTFORMÜLMETNİShows the formula in a cell as text.
FREQUENCYSIKLIKCounts how many values fall into each bin, for a histogram. Spills one more count than there are bins: the last counts values above the top bin.
FTESTFTEST
FVGDThe future value of an investment with regular payments.
FVSCHEDULEGDPROGRAMWhat an amount grows to when the interest rate changes from period to period.
GAMMAGAMAThe gamma function, which stretches the factorial to numbers that are not whole: GAMMA(n) is (n-1)!
GAMMA.DISTGAMA.DAĞThe gamma distribution, for values that cannot be negative and lean to the right, such as waiting times.
GAMMA.INVGAMA.TERSThe value below which a given share of a gamma distribution falls.
GAMMADISTGAMADAĞ
GAMMAINVGAMATERS
GAMMALNGAMALNThe natural logarithm of the gamma function. It stays small where GAMMA itself would overflow.
GAMMALN.PRECISEGAMALN.DUYARLI
GAUSSGAUSSThe chance that a standard normal value falls between the mean and z standard deviations above it.
GCDOBEBGreatest common divisor.
GEOMEANGEOORTThe geometric mean: the right average for growth rates.
GESTEPBESINIRTests whether a number reaches a threshold: 1 when it is greater than or equal to the step, 0 when it is not.
GETPIVOTDATAÖZETVERİALReads one value out of a PivotTable by naming it, so that the formula still finds it when the PivotTable grows or is sorted.
GROWTHBÜYÜMEValues on the best-fit exponential curve: predictions for something that grows by a steady percentage rather than a steady amount. Spills.
HARMEANHARORTThe harmonic mean: the right average for rates such as speeds.
HEX2BINHEX2BIN
HEX2DECHEX2DECTurns a hexadecimal number into an ordinary one.
HEX2OCTHEX2OCT
HLOOKUPYATAYARAFinds a value in the first row of a table and returns a value from the same column.
HOURSAATThe hour of a time (0-23).
HSTACKYATAYYIĞPlaces arrays side by side into one wider array.
HYPERLINKKÖPRÜMakes a cell a link: to a web page, an email address, or another cell ("#Sheet2!A1"). Select the cell and click its link button, or Ctrl+click it, to follow the link.
HYPGEOM.DISTHİPERGEOM.DAĞThe hypergeometric distribution: the chance of a number of successes in a sample drawn without putting anything back.
HYPGEOMDISTHİPERGEOMDAĞThe chance of exactly a number of successes in a sample drawn without putting anything back. The older form of HYPGEOM.DIST.
IFEĞERReturns one value if a condition is TRUE and another if it is FALSE.
IFERROREĞERHATAReturns a fallback value if a formula results in an error.
IFNAEĞERYOKSAReturns a fallback value only for #N/A errors.
IFSÇOKEĞERChecks conditions in order and returns the value for the first TRUE one.
IMABSSANMUTLAK
IMAGINARYSANAL
IMARGUMENTSANBAĞ_DEĞİŞKEN
IMCONJUGATESANEŞLENEK
IMCOSSANCOS
IMCOSHSANCOSH
IMCOTSANCOT
IMCSCSANCSC
IMCSCHSANCSCH
IMDIVSANBÖL
IMEXPSANÜS
IMLNSANLN
IMLOG10SANLOG10
IMLOG2SANLOG2
IMPOWERSANKUVVET
IMPRODUCTSANÇARP
IMREALSANGERÇEK
IMSECSANSEC
IMSECHSANSECH
IMSINSANSIN
IMSINHSANSINH
IMSQRTSANKAREKÖK
IMSUBSANTOPLA
IMSUMSANÇIKAR
IMTANSANTAN
INDEXİNDİSThe value at a given row and column of a range.
INDIRECTDOLAYLITurns text such as "B2" into a real reference to that cell or range.
INFOBİLGİ
INTTAMSAYIRounds down to the nearest whole number.
INTERCEPTKESMENOKTASIWhere the best-fit straight line crosses the y axis: the predicted y when x is 0.
IPMTFAİZTUTARIThe interest part of one loan payment.
IRRİÇ_VERİM_ORANIInternal rate of return for a series of cash flows.
ISBLANKEBOŞSATRUE if the cell is empty.
ISERREHATATRUE if the value is any error except #N/A.
ISERROREHATALIYSATRUE if the value is any error.
ISEVENÇİFTMİTRUE if the number is even.
ISFORMULAEFORMÜLSETRUE if the cell holds a formula.
ISLOGICALEMANTIKSALSATRUE if the value is TRUE or FALSE.
ISNAEYOKSATRUE if the value is the #N/A error.
ISNONTEXTEMETİNDEĞİLSETRUE if the value is not text.
ISNUMBERESAYIYSATRUE if the value is a number (dates count too).
ISODDTEKMİTRUE if the number is odd.
ISOWEEKNUMISOHAFTASAYThe ISO 8601 week number: weeks start on Monday, and week 1 contains the first Thursday of the year.
ISPMTISPMTThe interest paid in a period of a loan that is repaid in equal amounts of principal, so the interest falls every period.
ISREFEREFSETRUE if the value is a reference to a cell or range.
ISTEXTEMETİNSETRUE if the value is text.
KURTBASIKLIKKurtosis: how heavy the tails are compared with a normal distribution (0). Positive means more extreme values.
LARGEBÜYÜKThe k-th largest value (k = 1 is the maximum).
LCMOKEKLeast common multiple.
LEFTSOLDANThe first characters of a text value.
LENUZUNLUKThe number of characters in a text value.
LINESTDOTFits a straight line by least squares and returns its slope(s) and intercept, with the full regression statistics (standard errors, R², F, sums of squares) if you ask. Spills.
LNLNNatural logarithm.
LOGLOGLogarithm to a base (default 10).
LOG10LOG10Base-10 logarithm.
LOGESTLOTFits an exponential curve, y = b × m^x, and returns the growth factor m and the starting value b, with the regression statistics if you ask. Spills.
LOGINVLOGTERS
LOGNORM.DISTLOGNORM.DAĞThe lognormal distribution, for values whose logarithm is normally distributed, such as prices and incomes.
LOGNORM.INVLOGNORM.TERSThe value below which a given share of a lognormal distribution falls.
LOGNORMDISTLOGNORMDAĞThe chance of x or less in a lognormal distribution. The older form of LOGNORM.DIST.
LOOKUPARAFinds a value in a sorted row or column and returns the value in the same place in another. XLOOKUP is the modern choice.
LOWERKÜÇÜKHARFConverts text to lowercase.
MATCHKAÇINCIThe position of a value in a row or column.
MAXMAKThe largest number.
MAXAMAKAThe largest value, counting text in a range as 0 and TRUE as 1.
MAXIFSÇOKEĞERMAKThe largest value among cells that meet conditions.
MDETERMDETERMİNANTThe determinant of a square matrix.
MEDIANORTANCAThe middle number of a sorted list.
MIDPARÇAALCharacters from the middle of a text value.
MINMİNThe smallest number.
MINAMİNAThe smallest value, counting text in a range as 0 and TRUE as 1.
MINIFSÇOKEĞERMİNThe smallest value among cells that meet conditions.
MINUTEDAKİKAThe minute of a time (0-59).
MINVERSEDİZEY_TERSThe inverse of a square matrix.
MIRRD_İÇ_VERİM_ORANIRate of return when money borrowed and money reinvested earn different rates.
MMULTDÇARPMultiplies two matrices.
MODMODThe remainder after division.
MODEENÇOK_OLANThe most frequently occurring number.
MODE.MULTENÇOK_OLAN.ÇOKEvery value that is tied for most common, as a list.
MODE.SNGLENÇOK_OLAN.TEK
MONTHAYThe month of a date (1-12).
MROUNDKYUVARLARounds to the nearest multiple of a number.
MULTINOMIALÇOKTERİMLİThe number of ways to split a group into smaller groups of the given sizes: the factorial of the total, divided by the factorial of each size.
MUNITBİRİMMATRİSThe unit matrix of a given size: 1 down the diagonal and 0 everywhere else.
NSConverts a value to a number (text becomes 0).
NAYOKSAYReturns the #N/A error on purpose.
NEGBINOM.DISTNEGBİNOM.DAĞThe negative binomial distribution: the chance of a number of failures before a given number of successes.
NEGBINOMDISTNEGBİNOMDAĞThe chance of exactly a number of failures before a given number of successes. The older form of NEGBINOM.DIST.
NETWORKDAYSTAMİŞGÜNÜWorking days (Monday–Friday) between two dates, inclusive.
NETWORKDAYS.INTLTAMİŞGÜNÜ.ULUSLWorking days between two dates, inclusive, with the weekend on days you choose.
NOMINALNOMİNALThe quoted yearly rate behind an effective rate. The reverse of EFFECT.
NORM.DISTNORM.DAĞThe normal distribution: the chance of a value at or below x, or the height of the bell curve at x.
NORM.INVNORM.TERSThe value below which a given share of a normal distribution falls.
NORM.S.DISTNORM.S.DAĞThe standard normal distribution (mean 0, standard deviation 1) at a z-score.
NORM.S.INVNORM.S.TERSThe z-score below which a given share of the standard normal distribution falls.
NORMDISTNORMDAĞ
NORMINVNORMTERS
NORMSDISTNORMSDAĞThe chance of a z-score or less in the standard normal distribution. The older form of NORM.S.DIST.
NORMSINVNORMSTERS
NOTDEĞİLFlips TRUE to FALSE and FALSE to TRUE.
NOWŞİMDİThe current date and time.
NPERTAKSİT_SAYISIHow many payment periods are needed to pay off a loan.
NPVNBDNet present value of future cash flows at a discount rate.
NUMBERVALUESAYIDEĞERİTurns text into a number, whatever decimal and thousands marks it uses.
OCT2BINOCT2BIN
OCT2DECOCT2DEC
OCT2HEXOCT2HEX
ODDTEKRounds away from zero to the next odd integer.
OFFSETKAYDIRA range a set number of rows and columns away from a starting cell, of any size.
PDURATIONPSÜREHow many periods an investment needs to reach a target at a steady rate.
PEARSONPEARSONThe Pearson correlation coefficient, the same as CORREL.
PERCENTILEYÜZDEBİRLİKThe value below which a given percentage of the data falls.
PERCENTILE.EXCYÜZDEBİRLİK.HRCThe value below which a percentage of the data falls, excluding 0% and 100%.
PERCENTILE.INCYÜZDEBİRLİK.DHL
PERCENTRANK.EXCYÜZDERANK.HRCWhere a value stands in a list, between 0 and 1 without ever reaching either.
PERCENTRANK.INCYÜZDERANK.DHLWhere a value stands in a list, from 0 (the lowest) to 1 (the highest).
PERMUTPERMÜTASYONHow many ways to pick a number of items from a group, when the order matters.
PERMUTATIONAPERMÜTASYONAThe number of ordered arrangements when the same item may be used more than once: number to the power of number_chosen.
PHIPHIThe height of the standard normal bell curve at x.
PIPİThe number π (3.14159…).
PMTDEVRESEL_ÖDEMEThe payment for a loan with constant payments and a constant interest rate.
POISSONPOISSON
POISSON.DISTPOISSON.DAĞThe chance of a number of events in a period, given how many happen on average.
POWERKUVVETRaises a number to a power (same as ^).
PPMTANA_PARA_ÖDEMESİThe principal (pay-down) part of one loan payment.
PRICEDEĞER
PROBOLASILIKAdds up the probabilities of the outcomes that fall between two limits.
PRODUCTÇARPIMMultiplies all the numbers together.
PROPERYAZIM.DÜZENİCapitalises The First Letter Of Each Word.
PVBDThe present value: what a series of future payments is worth now.
QUARTILEDÖRTTEBİRLİKA quartile of the data (0 = min, 2 = median, 4 = max).
QUARTILE.EXCDÖRTTEBİRLİK.HRCA quartile of the data (1, 2 or 3), using the exclusive method.
QUARTILE.INCDÖRTTEBİRLİK.DHL
QUOTIENTBÖLÜMThe whole-number part of a division.
RADIANSRADYANTurns degrees into radians, which is what SIN, COS and TAN take.
RANDS_SAYI_ÜRETA random number between 0 and 1. Changes on every edit.
RANDARRAYRASGDİZİFills an array with random numbers.
RANDBETWEENRASTGELEARADAA random whole number between two limits.
RANKRANKThe position of a number in a list (1 = largest by default).
RANK.AVGRANK.ORTThe position of a number in a list. Tied values share the average of their positions.
RATEFAİZ_ORANIThe interest rate per period of a loan or investment.
RECEIVEDGETİRİ
REPLACEDEĞİŞTİRReplaces characters at a given position.
REPTYİNELERepeats text a number of times.
RIGHTSAĞDANThe last characters of a text value.
ROMANROMENWrites a number in Roman numerals.
ROUNDYUVARLARounds a number to a given number of digits.
ROUNDDOWNAŞAĞIYUVARLARounds a number towards zero.
ROUNDUPYUKARIYUVARLARounds a number away from zero.
ROWSATIRThe row number of a reference (or of the current cell).
ROWSSATIRSAYHow many rows a range has.
RRIGERÇEKLEŞENYATIRIMGETİRİSİThe steady growth rate per period that turns one amount into another (CAGR).
RSQRKARER squared: the share of the variation in y that the best-fit line explains, from 0 to 1.
SEARCHMBULPosition of one text inside another (not case-sensitive, allows wildcards).
SECSECThe secant of an angle: 1 divided by its cosine.
SECHSECH
SECONDSANİYEThe second of a time (0-59).
SERIESSUMSERİTOPLAThe sum of a power series: each coefficient times x raised to a power that grows by a fixed step.
SHEETSAYFAThe number of a sheet, counting the tabs from the left: 1 for the first.
SHEETSSAYFALARHow many sheets the workbook has.
SIGNİŞARET1 for positive numbers, -1 for negative, 0 for zero.
SINSİNThe sine of an angle given in radians.
SINHSİNHThe hyperbolic sine of a number.
SKEWÇARPIKLIKSkewness: how lopsided the data are. Positive means a longer tail of high values, negative a longer tail of low values.
SKEW.PÇARPIKLIK.PHow lopsided a whole population is: positive when the tail runs to the right, negative when it runs to the left.
SLNDAStraight-line depreciation: the same loss of value every year.
SLOPEEĞİMThe slope of the straight line that best fits the data: how much y changes for each 1 added to x.
SMALLKÜÇÜKThe k-th smallest value (k = 1 is the minimum).
SORTSIRALASorts a range. The result spills.
SORTBYSIRALAÖLÇÜTSorts a range by the values in another range.
SQRTKAREKÖKSquare root.
SQRTPIKAREKÖKPİThe square root of a number multiplied by π.
STANDARDIZESTANDARTLAŞTIRMAA z-score: how many standard deviations a value is above (or below) the mean.
STDEVSTDSAPMAStandard deviation of a sample.
STDEV.PSTDSAPMA.PStandard deviation of an entire population.
STDEV.SSTDSAPMA.S
STDEVASTDSAPMAAThe standard deviation of a sample, counting text and FALSE in a range as 0 and TRUE as 1. STDEV skips them.
STDEVPSTDSAPMAS
STDEVPASTDSAPMASAThe standard deviation of a whole population, counting text and FALSE in a range as 0 and TRUE as 1. STDEVP skips them.
STEYXSTHYXThe standard error of the regression: the typical distance of a y value from the best-fit line.
SUBSTITUTEYERİNEKOYReplaces specific text with new text.
SUBTOTALALTTOPLAMTotals a range, leaving out rows that a filter hides and other subtotals inside it.
SUMTOPLAAdds up numbers, cells and ranges.
SUMIFETOPLAAdds the cells that meet one condition.
SUMIFSÇOKETOPLAAdds the cells that meet every one of several conditions.
SUMPRODUCTTOPLA.ÇARPIMMultiplies matching items in arrays, then adds the results.
SUMSQTOPKAREAdds the squares of the numbers.
SUMX2MY2TOPX2EY2Adds up the differences of the squares of matching values in two ranges.
SUMX2PY2TOPX2AY2Adds up the sums of the squares of matching values in two ranges.
SUMXMY2TOPXEY2Adds up the squares of the differences of matching values in two ranges.
SWITCHİLKEŞLEŞENCompares a value against a list and returns the matching result.
SYDYATSum-of-years’ digits depreciation: more in the early periods, less in the late ones.
TMReturns the value if it is text, otherwise empty text.
T.DISTT.DAĞStudent's t-distribution: the chance of a t of x or less, or the height of the curve at x.
T.DIST.2TT.DAĞ.2KThe two-tailed t-distribution: the chance of a t further from 0 than x, on either side. This is the p-value of a two-sided t-test.
T.DIST.RTT.DAĞ.SAĞKThe right tail of the t-distribution: the chance of a t greater than x.
T.INVT.TERSThe t-value below which a given share of the t-distribution falls.
T.INV.2TT.TERS.2KThe t-value with a given share of the distribution beyond it, counting both tails. This is the critical value of a two-sided test.
T.TESTT.TESTStudent's t-test: the chance that two samples would differ this much if they came from populations with the same mean.
TANTANThe tangent of an angle given in radians.
TANHTANHThe hyperbolic tangent of a number.
TBILLEQHTAHEŞ
TBILLPRICEHTAHDEĞER
TBILLYIELDHTAHÖDEME
TDISTTDAĞThe tail of the t-distribution beyond x, on one side or both. The older form of T.DIST.RT and T.DIST.2T.
TEXTMETNEÇEVİRFormats a number as text using a format code.
TEXTAFTERSONRAKİMETİNThe text that comes after a delimiter.
TEXTBEFOREÖNCEKİMETİNThe text that comes before a delimiter.
TEXTJOINMETİNBİRLEŞTİRJoins text with a separator between each item.
TEXTSPLITMETİNBÖLSplits text into separate cells at a delimiter. The result spills.
TIMEZAMANBuilds a time from hours, minutes and seconds.
TIMEVALUEZAMANSAYISIConverts a time written as text into a fraction of a day.
TINVTTERS
TOCOLSÜTUNATurns an array into a single column.
TODAYBUGÜNToday's date. Updates automatically.
TOROWSATIRATurns an array into a single row.
TRANSPOSEDEVRİK_DÖNÜŞÜMFlips rows into columns and columns into rows.
TRENDEĞİLİMValues on the best-fit straight line (least squares): fitted values for the known data, or predictions for new x values. Spills.
TRIMKIRPRemoves extra spaces, leaving single spaces between words.
TRIMMEANKIRPORTALAMAThe average with a share of the highest and lowest values left out.
TRUNCNSATCuts off the decimal part of a number.
TTESTTTEST
TYPETÜRA number for the kind of value: 1 number, 2 text, 4 TRUE or FALSE, 16 error, 64 array.
UNICHARUNICODEKARAKTERİThe character with a Unicode number: letters of any alphabet, symbols, emoji.
UNICODEUNICODEThe Unicode number of the first character of some text.
UNIQUEBENZERSİZRemoves duplicates from a list. The result spills.
UPPERBÜYÜKHARFConverts text to UPPERCASE.
VALUETOTEXTDEĞERMETİNAny value as text. Text passes through unchanged, or in quotes in the strict format.
VARVARVariance of a sample.
VAR.PVAR.PVariance of an entire population.
VAR.SVAR.S
VARAVARAThe variance of a sample, counting text and FALSE in a range as 0 and TRUE as 1. VAR skips them.
VARPVARS
VARPAVARSAThe variance of a whole population, counting text and FALSE in a range as 0 and TRUE as 1. VARP skips them.
VDBDABDepreciation between any two points in an asset’s life, by declining balance that switches to straight-line once that gives more.
VLOOKUPDÜŞEYARAFinds a value in the first column of a table and returns a value from the same row.
VSTACKDÜŞEYYIĞStacks arrays on top of each other into one taller array.
WEEKDAYHAFTANINGÜNÜThe day of the week as a number.
WEEKNUMHAFTASAYThe week number of the year.
WEIBULLWEIBULL
WEIBULL.DISTWEIBULL.DAĞThe Weibull distribution, used for how long things last before they fail.
WORKDAYİŞGÜNÜThe date a number of working days before or after a date.
WORKDAY.INTLİŞGÜNÜ.ULUSLThe date a number of working days before or after a date, with the weekend on days you choose.
XIRRAİÇVERİMORANIThe yearly rate of return for cash flows that fall on any dates.
XLOOKUPÇAPRAZARASearches a range and returns the matching item from another range. The modern replacement for VLOOKUP.
XMATCHÇAPRAZEŞLEŞTİRThe position of a value in a list, with exact match by default.
XNPVANBDNet present value of cash flows that fall on any dates, not evenly spaced ones.
XORÖZELVEYATRUE if an odd number of conditions are TRUE.
YEARYILThe year of a date.
YEARFRACYILORANThe fraction of a year between two dates, using a day-count basis.
YIELDÖDEME
Z.TESTZ.TESTThe one-tailed z-test: the chance of a sample mean this far above a claimed population mean.
ZTESTZTEST

How it works

A workbook is not tied to a language. Excel stores every formula the same way and shows it in the language of whoever opens the file, so a file made in Turkish Excel works in English Excel without changes. The names only get in the way when a formula travels as text: in a tutorial, a forum answer, an email or a chat.

The translator changes four things: function names, the separator between arguments, the decimal point, and TRUE, FALSE and error values such as #N/A. Text in quotes, cell references and sheet names stay exactly as you wrote them. Every name was checked against two sources before it was added; where a name could not be confirmed, the translator leaves the English one and tells you.

Other languages