Excel Functions in German

Excel-funktionen auf Deutsch

These are the 140 most common functions in Excel with German translations. This list is very useful if you are used to the English version of Excel, and you are working with a German version that only accepts the German function names in the formulas. Or the other way around!

Normally you would also have to replace all the commas in my example formulas with semi-colon.

Do you need a complete list of all the function names in German in Excel? Scroll down to the bottom of this page to read more about Microsoft’s Functions Translator add-in.

EnglishGerman
ABSABS
ADDRESSADRESSE
AGGREGATEAGGREGAT
ANDUND
ARABICARABISCH
AVERAGEMITTELWERT
AVERAGEIFMITTELWERTWENN
AVERAGEIFSMITTELWERTWENNS
BAHTTEXTBAHTTEXT
BIN2DECBININDEZ
BIN2HEXBININHEX
CEILINGOBERGRENZE
CEILING.MATHOBERGRENZE.MATHEMATIK
CELLZELLE
CHARZEICHEN
CHOOSEWAHL
CODECODE
COLUMNSPALTE
COLUMNSSPALTEN
CONCATTEXTKETTE
CONCATENATEVERKETTEN
CONVERTUMWANDELN
COUNTANZAHL
COUNTAANZAHL2
COUNTBLANKANZAHLLEEREZELLEN
COUNTIFZÄHLENWENN
COUNTIFSZÄHLENWENNS
DATEDATUM
DATEVALUEDATWERT
DAYTAG
DAYSTAGE
DEC2BINDEZINBIN
DEC2HEXDEZINHEX
EOMONTHMONATSENDE
EVENGERADE
EXACTIDENTISCH
FACTFAKULTÄT
FILTERXMLXMLFILTERN
FINDFINDEN
FLOORUNTERGRENZE
FLOOR.MATHUNTERGRENZE.MATHEMATIK
FORMULATEXTFORMELTEXT
FREQUENCYHÄUFIGKEIT
HEX2BINHEXINBIN
HEX2DECHEXINDEZ
HLOOKUPWVERWEIS
HYPERLINKHYPERLINK
IFWENN
IFERRORWENNFEHLER
IFSWENNS
INDEXINDEX
INDIRECTINDIREKT
INFOINFO
INTGANZZAHL
ISBLANKISTLEER
ISERRORISTFEHLER
ISEVENISTGERADE
ISLOGICALISTLOG
ISNAISTNV
ISNONTEXTISTKTEXT
ISNUMBERISTZAHL
ISODDISTUNGERADE
ISOWEEKNUMISOKALENDERWOCHE
ISTEXTISTTEXT
LARGEKGRÖSSTE
LEFTLINKS
LENLÄNGE
LOOKUPVERWEIS
LOWERKLEIN
MATCHVERGLEICH
MAXMAX
MAXIFSMAXWENNS
MEDIANMEDIAN
MIDTEIL
MINMIN
MINIFSMINWENNS
MODREST
MODEMODALWERT
MONTHMONAT
MROUNDVRUNDEN
NN
NANV
NETWORKDAYSNETTOARBEITSTAGE
NETWORKDAYS.INTLNETTOARBEITSTAGE.INTL
NOTNICHT
NOWJETZT
ODDUNGERADE
OFFSETBEREICH.VERSCHIEBEN
ORODER
PERCENTILEQUANTIL
PERCENTILE.EXCQUANTIL.EXKL
PERCENTILE.INCQUANTIL.INKL
PERCENTRANKQUANTILSRANG
PERCENTRANK.EXCQUANTILSRANG.EXKL
PERCENTRANK.INCQUANTILSRANG.INKL
PIPI
PMTRMZ
PROPERGROSS2
QUARTILEQUARTILE
QUARTILE.EXCQUARTILE.EXKL
QUARTILE.INCQUARTILE.INKL
RANDZUFALLSZAHL
RANDBETWEENZUFALLSBEREICH
RANKRANG
RANK.AVGRANG.MITTELW
RANK.EQRANG.GLEICH
REPLACEERSETZEN
REPTWIEDERHOLEN
RIGHTRECHTS
ROMANRÖMISCH
ROUNDRUNDEN
ROUNDDOWNABRUNDEN
ROUNDUPAUFRUNDEN
ROWZEILE
ROWSZEILEN
SEARCHSUCHEN
SMALLKKLEINSTE
STDEVSTABW
STDEV.PSTABW.N
STDEV.SSTABW.S
SUBSTITUTEWECHSELN
SUBTOTALTEILERGEBNIS
SUMSUMME
SUMIFSUMMEWENN
SUMIFSSUMMEWENNS
SUMPRODUCTSUMMENPRODUKT
SWITCHERSTERWERT
TEXTTEXT
TEXTJOINTEXTVERKETTEN
TODAYHEUTE
TRANSPOSEMTRANS
TRIMGLÄTTEN
UNICHARUNIZEICHEN
UNICODEUNICODE
UPPERGROSS
VLOOKUPSVERWEIS
WEEKDAYWOCHENTAG
WEEKNUMKALENDERWOCHE
YEARJAHR
FALSEFALSCH
TRUEWAHR

Does Excel have a translate function?

Yes, there is an add-in called the Functions Translator add-in that you can install in a few seconds:

Go to Insert > Get Add-ins to open the add-in dialog. Choose Productivity under Category, find the Functions Translator add-in and click on the Add button.

Click on picture to magnify

Now you will find the Functions Translator on the Home tab to the right.

Use it to look up a functions name in a list (Reference):

Or use the Translator feature to translate a whole formula:

1 thought on “Excel Functions in German

  1. Very useful, thank you.

    Related question… I have a dashboard powered by pivot tables which I want to sent to my team in Germany.

    Could you tell me what the equivalents of “(All)” and “(Multiple Items)” are in a Pivot Table in German Excel?

    The reason for this is that I have “if” statements which convert “(All)” from the pivot table to “total” in the dashboard and “(Multiple Items)” to “Selected sites”. I plan to use “=IF(OR(…” to include the German alternatives.

    (I also need the French and Italian equivalents if any one can help?!)

Leave a Reply

Your email address will not be published. Required fields are marked *


− three = 4