Excel Functions in German

Excel-funktionen auf Deutsch

These are the most common Excel functions with German translations.

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

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

3 thoughts 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 *


eight + = 17