Formula translator / German

Excel functions in German and English

Excel-Funktionen auf Deutsch und Englisch

Excel in German has its own name for most functions: VLOOKUP is SVERWEIS and IF is WENN. 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")

German: =WENN(SVERWEIS(A2; Prices!A:C; 3; FALSCH)>=1,5; "High"; "Low")

In German, 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 434 functions in German and English

TRUE is WAHR and FALSE is FALSCH.

EnglishGermanWhat it does
ABSABSThe absolute value: the number without its sign.
ACCRINTMAUFGELZINSF
ACOSARCCOSThe angle, in radians, whose cosine is the number.
ACOSHARCCOSHYPThe inverse hyperbolic cosine of a number.
ACOTARCCOTThe angle, in radians, whose cotangent is the number. The result is between 0 and π.
ADDRESSADRESSEBuilds a cell address as text from a row number and a column number.
AGGREGATEAGGREGATLike SUBTOTAL with more calculations, and it can ignore errors in the range.
ANDUNDTRUE only if every condition is TRUE.
ARABICARABISCHTurns Roman numerals into a number.
AREASBEREICHE
ARRAYTOTEXTMATRIXZUTEXTAll the values of a range written out as one piece of text.
ASINARCSINThe angle, in radians, whose sine is the number. Wrap it in DEGREES() for degrees.
ASINHARCSINHYPThe inverse hyperbolic sine of a number.
ATANARCTANThe angle, in radians, whose tangent is the number.
ATAN2ARCTAN2The 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.
ATANHARCTANHYPThe inverse hyperbolic tangent of a number.
AVEDEVMITTELABWThe average distance of the values from their mean: a plain measure of how spread out they are.
AVERAGEMITTELWERTThe arithmetic mean of the numbers.
AVERAGEAMITTELWERTAThe average, counting text in a range as 0 and TRUE as 1.
AVERAGEIFMITTELWERTWENNAverages the cells that meet a condition.
AVERAGEIFSMITTELWERTWENNSAverages the cells that meet every one of several conditions.
BAHTTEXTBAHTTEXT
BASEBASISWrites a number in another base, such as binary (2) or hexadecimal (16), as text.
BESSELIBESSELI
BESSELJBESSELJ
BESSELKBESSELK
BESSELYBESSELY
BETA.DISTBETA.VERTThe beta distribution, for shares and percentages that vary between two bounds.
BETA.INVBETA.INVThe value below which a given share of a beta distribution falls.
BETADISTBETAVERTThe chance of x or less in a beta distribution. The older form of BETA.DIST.
BETAINVBETAINV
BIN2DECBININDEZTurns a binary number into an ordinary one.
BIN2HEXBININHEX
BIN2OCTBININOKT
BINOM.DISTBINOM.VERTThe chance of a number of successes in a set number of tries, each with the same chance.
BINOM.DIST.RANGEBINOM.VERT.BEREICHThe chance that the number of successes in a set of tries lands between two counts.
BINOM.INVBINOM.INVThe smallest number of successes whose cumulative binomial chance reaches a target: how many to plan for.
BINOMDISTBINOMVERT
BITANDBITUNDCompares two whole numbers bit by bit and keeps the bits that are set in both.
BITLSHIFTBITLVERSCHIEBMoves the bits of a whole number to the left, which doubles it for every bit moved.
BITORBITODERCompares two whole numbers bit by bit and keeps the bits that are set in either.
BITRSHIFTBITRVERSCHIEBMoves the bits of a whole number to the right, which halves it for every bit moved and drops the remainder.
BITXORBITXODERCompares two whole numbers bit by bit and keeps the bits that are set in one but not the other.
CEILINGOBERGRENZERounds a number up to the nearest multiple (away from zero when both are negative).
CEILING.MATHOBERGRENZE.MATHEMATIKRounds a number up to the nearest multiple; mode rounds negative numbers away from zero.
CELLZELLETells you something about a cell: its address, row, column, contents, number format or the type of value in it.
CHARZEICHENThe character for a character code.
CHIDISTCHIVERT
CHIINVCHIINV
CHISQ.DISTCHIQU.VERTThe chi-square distribution: the chance of a value of x or less, or the height of the curve at x.
CHISQ.DIST.RTCHIQU.VERT.REThe 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.INVCHIQU.INVThe value below which a given share of the chi-square distribution falls.
CHISQ.INV.RTCHIQU.INV.REThe chi-square value with a given share of the distribution above it: the critical value of a chi-square test.
CHISQ.TESTCHIQU.TESTThe chi-square test of independence: the chance of counts this far from the expected ones if nothing but chance were at work.
CHITESTCHITEST
CHOOSEWAHLPicks a value from a list by its position.
CHOOSECOLSSPALTENWAHLReturns the columns you name from an array, in the order you name them.
CHOOSEROWSZEILENWAHLReturns the rows you name from an array, in the order you name them.
CLEANSÄUBERNRemoves non-printable characters.
CODECODEThe character code of the first character.
COLUMNSPALTEThe column number of a reference (A = 1).
COLUMNSSPALTENHow many columns a range has.
COMBINKOMBINATIONENHow many ways to choose a number of items from a group, when the order does not matter.
COMBINAKOMBINATIONEN2The number of ways to choose items when the same item may be chosen more than once and the order does not matter.
COMPLEXKOMPLEXE
CONCATTEXTKETTEJoins text from several values or ranges.
CONCATENATEVERKETTENJoins several text values (older version of CONCAT).
CONFIDENCEKONFIDENZ
CONFIDENCE.NORMKONFIDENZ.NORMThe margin of error for an average: add and subtract it to get the confidence interval.
CONFIDENCE.TKONFIDENZ.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.
CONVERTUMWANDELNConverts a number from one unit of measurement to another: miles to kilometres, pounds to kilograms, Fahrenheit to Celsius.
CORRELKORRELThe correlation coefficient of two data sets: from −1 (opposite) through 0 (unrelated) to 1 (move together).
COSCOSThe cosine of an angle given in radians.
COSHCOSHYPThe hyperbolic cosine of a number.
COTCOTThe cotangent of an angle: 1 divided by its tangent.
COUNTANZAHLCounts cells that contain numbers.
COUNTAANZAHL2Counts cells that are not empty.
COUNTBLANKANZAHLLEEREZELLENCounts empty cells in a range.
COUNTIFZÄHLENWENNCounts the cells that meet a condition.
COUNTIFSZÄHLENWENNSCounts the rows that meet every one of several conditions.
COVARKOVAR
COVARIANCE.PKOVARIANZ.PPopulation covariance: the average product of the deviations of each pair from their means.
COVARIANCE.SKOVARIANZ.SSample covariance: like COVARIANCE.P, but divides by n − 1 for a sample.
CRITBINOMKRITBINOM
CSCCOSECThe cosecant of an angle: 1 divided by its sine.
CSCHCOSECHYP
CUMIPMTKUMZINSZTotal interest paid between two payment numbers.
CUMPRINCKUMKAPITALTotal paid off the loan itself (not interest) between two payment numbers.
DATEDATUMBuilds a date from a year, month and day.
DATEDIFDATEDIFThe difference between two dates in years, months or days.
DATEVALUEDATWERTConverts a date written as text into a date serial number.
DAVERAGEDBMITTELWERTThe average of a column of a table for the rows that meet conditions written in cells.
DAYTAGThe day of the month (1-31).
DAYSTAGEThe number of days between two dates.
DAYS360TAGE360Days between two dates in a year of twelve 30-day months, as some accounts count them.
DBGDA2Depreciation for one period, losing the same percentage of the remaining value each period.
DCOUNTDBANZAHLCounts the numbers in a column of a table for the rows that meet conditions written in cells.
DCOUNTADBANZAHL2Counts the cells that are not empty in a column of a table for the rows that meet conditions written in cells.
DDBGDADepreciation for one period at double the straight-line rate (or another multiple).
DEC2BINDEZINBINWrites a whole number in binary.
DEC2HEXDEZINHEXWrites a whole number in hexadecimal.
DEC2OCTDEZINOKT
DECIMALDEZIMALTurns a number written in another base, as text, into an ordinary number.
DEGREESGRADTurns radians into degrees.
DELTADELTATests whether two numbers are equal: 1 when they are, 0 when they are not.
DEVSQSUMQUADABWThe sum of the squared distances of the values from their mean.
DGETDBAUSZUGThe 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.
DMAXDBMAXThe largest number in a column of a table among the rows that meet conditions written in cells.
DMINDBMINThe smallest number in a column of a table among the rows that meet conditions written in cells.
DOLLARDMA number as text in currency style: $1,234.57, with negatives in brackets.
DOLLARDENOTIERUNGDEZTurns a price written with a fraction, as bond prices are (1.02 meaning 1 and 2/16), into an ordinary decimal.
DOLLARFRNOTIERUNGBRUTurns a decimal price into one written with a fraction, as bond prices are: 1.125 in sixteenths is 1.02.
DPRODUCTDBPRODUKTMultiplies the numbers in a column of a table for the rows that meet conditions written in cells.
DROPWEGLASSENRemoves the first or last rows or columns of an array.
DSTDEVDBSTDABWThe standard deviation of a column of a table for the matching rows, treating them as a sample.
DSTDEVPDBSTDABWNThe standard deviation of a column of a table for the matching rows, treating them as the whole population.
DSUMDBSUMMEAdds up a column of a table for the rows that meet conditions written in cells.
DVARDBVARIANZThe variance of a column of a table for the matching rows, treating them as a sample.
DVARPDBVARIANZENThe variance of a column of a table for the matching rows, treating them as the whole population.
EDATEEDATUMThe same day a number of months before or after a date.
EFFECTEFFEKTIVThe yearly rate you really pay or earn, once interest is added several times a year.
ENCODEURLURLCODIERENText made safe to put in a web address: spaces become %20, and so on.
EOMONTHMONATSENDEThe last day of the month, a number of months away.
ERFGAUSSFEHLERThe error function between two limits. With one limit it runs from 0.
ERF.PRECISEGAUSSF.GENAUThe error function from 0 to x.
ERFCGAUSSFKOMPLThe complementary error function: 1 - ERF(x).
ERROR.TYPEFEHLER.TYPA number for the kind of error: 2 #DIV/0!, 3 #VALUE!, 4 #REF!, 5 #NAME?, 6 #NUM!, 7 #N/A.
EVENGERADERounds away from zero to the next even integer.
EXACTIDENTISCHTRUE if two text values are exactly the same, including case.
EXPEXPe raised to a power.
EXPANDERWEITERNGrows an array to a set number of rows and columns, filling the new cells.
EXPON.DISTEXPON.VERTThe exponential distribution, for the time between events that happen at a steady rate: the chance of waiting x or less.
EXPONDISTEXPONVERT
F.DISTF.VERTThe 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.VERT.REThe 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.INVThe value below which a given share of the F-distribution falls.
F.INV.RTF.INV.REThe 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.
FACTFAKULTÄTFactorial: 1 × 2 × … × n.
FACTDOUBLEZWEIFAKULTÄTThe double factorial: the number times every second whole number below it (7 × 5 × 3 × 1).
FDISTFVERT
FINDFINDENPosition of one text inside another (case-sensitive).
FINVFINV
FISHERFISHERThe Fisher transformation of a correlation, which makes it close to normally distributed so that it can be tested.
FISHERINVFISHERINVTurns a Fisher-transformed value back into a correlation.
FIXEDFESTA number as text, rounded to a set number of decimals, with or without commas.
FLOORUNTERGRENZERounds a number down to the nearest multiple (toward zero when both are negative).
FLOOR.MATHUNTERGRENZE.MATHEMATIKRounds a number down to the nearest multiple; mode rounds negative numbers toward zero.
FORECASTSCHÄTZERPredicts a y value for a new x from the best-fit straight line through known data.
FORMULATEXTFORMELTEXTShows the formula in a cell as text.
FREQUENCYHÄUFIGKEITCounts 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
FVZWThe future value of an investment with regular payments.
FVSCHEDULEZW2What an amount grows to when the interest rate changes from period to period.
GAMMAGAMMAThe gamma function, which stretches the factorial to numbers that are not whole: GAMMA(n) is (n-1)!
GAMMA.DISTGAMMA.VERTThe gamma distribution, for values that cannot be negative and lean to the right, such as waiting times.
GAMMA.INVGAMMA.INVThe value below which a given share of a gamma distribution falls.
GAMMADISTGAMMAVERT
GAMMAINVGAMMAINV
GAMMALNGAMMALNThe natural logarithm of the gamma function. It stays small where GAMMA itself would overflow.
GAMMALN.PRECISEGAMMALN.GENAU
GAUSSGAUSSThe chance that a standard normal value falls between the mean and z standard deviations above it.
GCDGGTGreatest common divisor.
GEOMEANGEOMITTELThe geometric mean: the right average for growth rates.
GESTEPGGANZZAHLTests whether a number reaches a threshold: 1 when it is greater than or equal to the step, 0 when it is not.
GETPIVOTDATAPIVOTDATENZUORDNENReads one value out of a PivotTable by naming it, so that the formula still finds it when the PivotTable grows or is sorted.
GROWTHVARIATIONValues on the best-fit exponential curve: predictions for something that grows by a steady percentage rather than a steady amount. Spills.
HARMEANHARMITTELThe harmonic mean: the right average for rates such as speeds.
HEX2BINHEXINBIN
HEX2DECHEXINDEZTurns a hexadecimal number into an ordinary one.
HEX2OCTHEXINOKT
HLOOKUPWVERWEISFinds a value in the first row of a table and returns a value from the same column.
HOURSTUNDEThe hour of a time (0-23).
HSTACKHSTAPELNPlaces arrays side by side into one wider array.
HYPERLINKHYPERLINKMakes 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.DISTHYPGEOM.VERTThe hypergeometric distribution: the chance of a number of successes in a sample drawn without putting anything back.
HYPGEOMDISTHYPGEOMVERTThe chance of exactly a number of successes in a sample drawn without putting anything back. The older form of HYPGEOM.DIST.
IFWENNReturns one value if a condition is TRUE and another if it is FALSE.
IFERRORWENNFEHLERReturns a fallback value if a formula results in an error.
IFNAWENNNVReturns a fallback value only for #N/A errors.
IFSWENNSChecks conditions in order and returns the value for the first TRUE one.
IMABSIMABS
IMAGINARYIMAGINÄRTEIL
IMARGUMENTIMARGUMENT
IMCONJUGATEIMKONJUGIERTE
IMCOSIMCOS
IMCOTIMCOT
IMDIVIMDIV
IMEXPIMEXP
IMLNIMLN
IMLOG10IMLOG10
IMLOG2IMLOG2
IMPOWERIMAPOTENZ
IMPRODUCTIMPRODUKT
IMREALIMREALTEIL
IMSECIMSEC
IMSINIMSIN
IMSQRTIMWURZEL
IMSUBIMSUB
IMSUMIMSUMME
IMTANIMTAN
INDEXINDEXThe value at a given row and column of a range.
INDIRECTINDIREKTTurns text such as "B2" into a real reference to that cell or range.
INFOINFO
INTGANZZAHLRounds down to the nearest whole number.
INTERCEPTACHSENABSCHNITTWhere the best-fit straight line crosses the y axis: the predicted y when x is 0.
IPMTZINSZThe interest part of one loan payment.
IRRIKVInternal rate of return for a series of cash flows.
ISBLANKISTLEERTRUE if the cell is empty.
ISERRISTFEHLTRUE if the value is any error except #N/A.
ISERRORISTFEHLERTRUE if the value is any error.
ISEVENISTGERADETRUE if the number is even.
ISFORMULAISTFORMELTRUE if the cell holds a formula.
ISLOGICALISTLOGTRUE if the value is TRUE or FALSE.
ISNAISTNVTRUE if the value is the #N/A error.
ISNONTEXTISTKTEXTTRUE if the value is not text.
ISNUMBERISTZAHLTRUE if the value is a number (dates count too).
ISODDISTUNGERADETRUE if the number is odd.
ISOWEEKNUMISOKALENDERWOCHEThe 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.
ISREFISTBEZUGTRUE if the value is a reference to a cell or range.
ISTEXTISTTEXTTRUE if the value is text.
KURTKURTKurtosis: how heavy the tails are compared with a normal distribution (0). Positive means more extreme values.
LARGEKGRÖSSTEThe k-th largest value (k = 1 is the maximum).
LCMKGVLeast common multiple.
LEFTLINKSThe first characters of a text value.
LENLÄNGEThe number of characters in a text value.
LINESTRGPFits 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.
LOGESTRKPFits 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.
LOGINVLOGINV
LOGNORM.DISTLOGNORM.VERTThe lognormal distribution, for values whose logarithm is normally distributed, such as prices and incomes.
LOGNORM.INVLOGNORM.INVThe value below which a given share of a lognormal distribution falls.
LOGNORMDISTLOGNORMVERTThe chance of x or less in a lognormal distribution. The older form of LOGNORM.DIST.
LOOKUPVERWEISFinds a value in a sorted row or column and returns the value in the same place in another. XLOOKUP is the modern choice.
LOWERKLEINConverts text to lowercase.
MATCHVERGLEICHThe position of a value in a row or column.
MAXMAXThe largest number.
MAXAMAXAThe largest value, counting text in a range as 0 and TRUE as 1.
MAXIFSMAXWENNSThe largest value among cells that meet conditions.
MDETERMMDETThe determinant of a square matrix.
MDURATIONMDURATION
MEDIANMEDIANThe middle number of a sorted list.
MIDTEILCharacters from the middle of a text value.
MINMINThe smallest number.
MINAMINAThe smallest value, counting text in a range as 0 and TRUE as 1.
MINIFSMINWENNSThe smallest value among cells that meet conditions.
MINUTEMINUTEThe minute of a time (0-59).
MINVERSEMINVThe inverse of a square matrix.
MIRRQIKVRate of return when money borrowed and money reinvested earn different rates.
MMULTMMULTMultiplies two matrices.
MODRESTThe remainder after division.
MODEMODALWERTThe most frequently occurring number.
MODE.MULTMODUS.VIELFEvery value that is tied for most common, as a list.
MODE.SNGLMODUS.EINF
MONTHMONATThe month of a date (1-12).
MROUNDVRUNDENRounds to the nearest multiple of a number.
MULTINOMIALPOLYNOMIALThe 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.
MUNITMEINHEITThe unit matrix of a given size: 1 down the diagonal and 0 everywhere else.
NNConverts a value to a number (text becomes 0).
NANVReturns the #N/A error on purpose.
NEGBINOM.DISTNEGBINOM.VERTThe negative binomial distribution: the chance of a number of failures before a given number of successes.
NEGBINOMDISTNEGBINOMVERTThe chance of exactly a number of failures before a given number of successes. The older form of NEGBINOM.DIST.
NETWORKDAYSNETTOARBEITSTAGEWorking days (Monday–Friday) between two dates, inclusive.
NETWORKDAYS.INTLNETTOARBEITSTAGE.INTLWorking days between two dates, inclusive, with the weekend on days you choose.
NOMINALNOMINALThe quoted yearly rate behind an effective rate. The reverse of EFFECT.
NORM.DISTNORM.VERTThe normal distribution: the chance of a value at or below x, or the height of the bell curve at x.
NORM.INVNORM.INVThe value below which a given share of a normal distribution falls.
NORM.S.DISTNORM.S.VERTThe standard normal distribution (mean 0, standard deviation 1) at a z-score.
NORM.S.INVNORM.S.INVThe z-score below which a given share of the standard normal distribution falls.
NORMDISTNORMVERT
NORMINVNORMINV
NORMSDISTSTANDNORMVERTThe chance of a z-score or less in the standard normal distribution. The older form of NORM.S.DIST.
NORMSINVSTANDNORMINV
NOTNICHTFlips TRUE to FALSE and FALSE to TRUE.
NOWJETZTThe current date and time.
NPERZZRHow many payment periods are needed to pay off a loan.
NPVNBWNet present value of future cash flows at a discount rate.
NUMBERVALUEZAHLENWERTTurns text into a number, whatever decimal and thousands marks it uses.
OCT2BINOKTINBIN
OCT2DECOKTINDEZ
OCT2HEXOKTINHEX
ODDUNGERADERounds away from zero to the next odd integer.
OFFSETBEREICH.VERSCHIEBENA range a set number of rows and columns away from a starting cell, of any size.
ORODERTRUE if at least one condition is TRUE.
PDURATIONPDURATIONHow many periods an investment needs to reach a target at a steady rate.
PEARSONPEARSONThe Pearson correlation coefficient, the same as CORREL.
PERCENTILEQUANTILThe value below which a given percentage of the data falls.
PERCENTILE.EXCQUANTIL.EXKLThe value below which a percentage of the data falls, excluding 0% and 100%.
PERCENTILE.INCQUANTIL.INKL
PERCENTRANK.EXCQUANTILSRANG.EXKLWhere a value stands in a list, between 0 and 1 without ever reaching either.
PERCENTRANK.INCQUANTILSRANG.INKLWhere a value stands in a list, from 0 (the lowest) to 1 (the highest).
PERMUTVARIATIONENHow many ways to pick a number of items from a group, when the order matters.
PERMUTATIONAVARIATIONEN2The 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.
PIPIThe number π (3.14159…).
PMTRMZThe payment for a loan with constant payments and a constant interest rate.
POISSONPOISSON
POISSON.DISTPOISSON.VERTThe chance of a number of events in a period, given how many happen on average.
POWERPOTENZRaises a number to a power (same as ^).
PPMTKAPZThe principal (pay-down) part of one loan payment.
PROBWAHRSCHBEREICHAdds up the probabilities of the outcomes that fall between two limits.
PRODUCTPRODUKTMultiplies all the numbers together.
PROPERGROSS2Capitalises The First Letter Of Each Word.
PVBWThe present value: what a series of future payments is worth now.
QUARTILEQUARTILEA quartile of the data (0 = min, 2 = median, 4 = max).
QUARTILE.EXCQUARTILE.EXKLA quartile of the data (1, 2 or 3), using the exclusive method.
QUARTILE.INCQUARTILE.INKL
QUOTIENTQUOTIENTThe whole-number part of a division.
RADIANSBOGENMASSTurns degrees into radians, which is what SIN, COS and TAN take.
RANDZUFALLSZAHLA random number between 0 and 1. Changes on every edit.
RANDARRAYZUFALLSMATRIXFills an array with random numbers.
RANDBETWEENZUFALLSBEREICHA random whole number between two limits.
RANKRANGThe position of a number in a list (1 = largest by default).
RANK.AVGRANG.MITTELWThe position of a number in a list. Tied values share the average of their positions.
RATEZINSThe interest rate per period of a loan or investment.
REPLACEERSETZENReplaces characters at a given position.
REPTWIEDERHOLENRepeats text a number of times.
RIGHTRECHTSThe last characters of a text value.
ROMANRÖMISCHWrites a number in Roman numerals.
ROUNDRUNDENRounds a number to a given number of digits.
ROUNDDOWNABRUNDENRounds a number towards zero.
ROUNDUPAUFRUNDENRounds a number away from zero.
ROWZEILEThe row number of a reference (or of the current cell).
ROWSZEILENHow many rows a range has.
RRIZSATZINVESTThe steady growth rate per period that turns one amount into another (CAGR).
RSQBESTIMMTHEITSMASSR squared: the share of the variation in y that the best-fit line explains, from 0 to 1.
RTDRTD
SEARCHSUCHENPosition of one text inside another (not case-sensitive, allows wildcards).
SECSECThe secant of an angle: 1 divided by its cosine.
SECHSECHYP
SECONDSEKUNDEThe second of a time (0-59).
SEQUENCESEQUENZGenerates a list of sequential numbers that spills into neighbouring cells.
SERIESSUMPOTENZREIHEThe sum of a power series: each coefficient times x raised to a power that grows by a fixed step.
SHEETBLATTThe number of a sheet, counting the tabs from the left: 1 for the first.
SHEETSBLÄTTERHow many sheets the workbook has.
SIGNVORZEICHEN1 for positive numbers, -1 for negative, 0 for zero.
SINSINThe sine of an angle given in radians.
SINHSINHYPThe hyperbolic sine of a number.
SKEWSCHIEFESkewness: how lopsided the data are. Positive means a longer tail of high values, negative a longer tail of low values.
SKEW.PSCHIEFE.PHow lopsided a whole population is: positive when the tail runs to the right, negative when it runs to the left.
SLNLIAStraight-line depreciation: the same loss of value every year.
SLOPESTEIGUNGThe slope of the straight line that best fits the data: how much y changes for each 1 added to x.
SMALLKKLEINSTEThe k-th smallest value (k = 1 is the minimum).
SORTSORTIERENSorts a range. The result spills.
SORTBYSORTIERENNACHSorts a range by the values in another range.
SQRTWURZELSquare root.
SQRTPIWURZELPIThe square root of a number multiplied by π.
STANDARDIZESTANDARDISIERUNGA z-score: how many standard deviations a value is above (or below) the mean.
STDEVSTABWStandard deviation of a sample.
STDEV.PSTABW.NStandard deviation of an entire population.
STDEV.SSTABW.S
STDEVASTABWAThe standard deviation of a sample, counting text and FALSE in a range as 0 and TRUE as 1. STDEV skips them.
STDEVPSTABWN
STDEVPASTABWNAThe standard deviation of a whole population, counting text and FALSE in a range as 0 and TRUE as 1. STDEVP skips them.
STEYXSTFEHLERYXThe standard error of the regression: the typical distance of a y value from the best-fit line.
SUBSTITUTEWECHSELNReplaces specific text with new text.
SUBTOTALTEILERGEBNISTotals a range, leaving out rows that a filter hides and other subtotals inside it.
SUMSUMMEAdds up numbers, cells and ranges.
SUMIFSUMMEWENNAdds the cells that meet one condition.
SUMIFSSUMMEWENNSAdds the cells that meet every one of several conditions.
SUMPRODUCTSUMMENPRODUKTMultiplies matching items in arrays, then adds the results.
SUMSQQUADRATESUMMEAdds the squares of the numbers.
SUMX2MY2SUMMEX2MY2Adds up the differences of the squares of matching values in two ranges.
SUMX2PY2SUMMEX2PY2Adds up the sums of the squares of matching values in two ranges.
SUMXMY2SUMMEXMY2Adds up the squares of the differences of matching values in two ranges.
SWITCHERSTERWERTCompares a value against a list and returns the matching result.
SYDDIASum-of-years’ digits depreciation: more in the early periods, less in the late ones.
TTReturns the value if it is text, otherwise empty text.
T.DISTT.VERTStudent's t-distribution: the chance of a t of x or less, or the height of the curve at x.
T.DIST.2TT.VERT.2SThe 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.VERT.REThe right tail of the t-distribution: the chance of a t greater than x.
T.INVT.INVThe t-value below which a given share of the t-distribution falls.
T.INV.2TT.INV.2SThe 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.
TAKEÜBERNEHMENKeeps the first or last rows or columns of an array.
TANTANThe tangent of an angle given in radians.
TANHTANHYPThe hyperbolic tangent of a number.
TBILLEQTBILLÄQUIV
TBILLPRICETBILLKURS
TBILLYIELDTBILLRENDITE
TDISTTVERTThe tail of the t-distribution beyond x, on one side or both. The older form of T.DIST.RT and T.DIST.2T.
TEXTTEXTFormats a number as text using a format code.
TEXTAFTERTEXTNACHThe text that comes after a delimiter.
TEXTBEFORETEXTVORThe text that comes before a delimiter.
TEXTJOINTEXTVERKETTENJoins text with a separator between each item.
TEXTSPLITTEXTTEILENSplits text into separate cells at a delimiter. The result spills.
TIMEZEITBuilds a time from hours, minutes and seconds.
TIMEVALUEZEITWERTConverts a time written as text into a fraction of a day.
TINVTINV
TOCOLZUSPALTETurns an array into a single column.
TODAYHEUTEToday's date. Updates automatically.
TOROWZUZEILETurns an array into a single row.
TRANSPOSEMTRANSFlips rows into columns and columns into rows.
TRENDTRENDValues on the best-fit straight line (least squares): fitted values for the known data, or predictions for new x values. Spills.
TRIMGLÄTTENRemoves extra spaces, leaving single spaces between words.
TRIMMEANGESTUTZTMITTELThe average with a share of the highest and lowest values left out.
TRUNCKÜRZENCuts off the decimal part of a number.
TTESTTTEST
TYPETYPA number for the kind of value: 1 number, 2 text, 4 TRUE or FALSE, 16 error, 64 array.
UNICHARUNIZEICHENThe character with a Unicode number: letters of any alphabet, symbols, emoji.
UNICODEUNICODEThe Unicode number of the first character of some text.
UNIQUEEINDEUTIGRemoves duplicates from a list. The result spills.
UPPERGROSSConverts text to UPPERCASE.
VALUEWERTConverts text that looks like a number into a number.
VALUETOTEXTWERTZUTEXTAny value as text. Text passes through unchanged, or in quotes in the strict format.
VARVARIANZVariance of a sample.
VAR.PVAR.PVariance of an entire population.
VAR.SVAR.S
VARAVARIANZAThe variance of a sample, counting text and FALSE in a range as 0 and TRUE as 1. VAR skips them.
VARPVARIANZEN
VARPAVARIANZENAThe variance of a whole population, counting text and FALSE in a range as 0 and TRUE as 1. VARP skips them.
VDBVDBDepreciation between any two points in an asset’s life, by declining balance that switches to straight-line once that gives more.
VLOOKUPSVERWEISFinds a value in the first column of a table and returns a value from the same row.
VSTACKVSTAPELNStacks arrays on top of each other into one taller array.
WEEKDAYWOCHENTAGThe day of the week as a number.
WEEKNUMKALENDERWOCHEThe week number of the year.
WEIBULLWEIBULL
WEIBULL.DISTWEIBULL.VERTThe Weibull distribution, used for how long things last before they fail.
WORKDAYARBEITSTAGThe date a number of working days before or after a date.
WORKDAY.INTLARBEITSTAG.INTLThe date a number of working days before or after a date, with the weekend on days you choose.
WRAPROWSZEILENUMBRUCHWraps a row or column of values into rows of a set length.
XIRRXINTZINSFUSSThe yearly rate of return for cash flows that fall on any dates.
XLOOKUPXVERWEISSearches a range and returns the matching item from another range. The modern replacement for VLOOKUP.
XMATCHXVERGLEICHThe position of a value in a list, with exact match by default.
XNPVXKAPITALWERTNet present value of cash flows that fall on any dates, not evenly spaced ones.
XORXODERTRUE if an odd number of conditions are TRUE.
YEARJAHRThe year of a date.
YEARFRACBRTEILJAHREThe fraction of a year between two dates, using a day-count basis.
YIELDRENDITE
Z.TESTG.TESTThe one-tailed z-test: the chance of a sample mean this far above a claimed population mean.
ZTESTGTEST

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 German 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