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
ANDUND
AVERAGEMITTELWERT
AVERAGEIFMITTELWERTWENN
AVERAGEIFSMITTELWERTWENNS
BAHTTEXTBAHTTEXT
BIN2DECBININDEZ
BIN2HEXBININHEX
CEILINGOBERGRENZE
CHARZEICHEN
CHOOSEWAHL
CODECODE
COLUMNSPALTE
COLUMNSSPALTEN
CONCATENATEVERKETTEN
COUNTANZAHL
COUNTAANZAHL2
COUNTBLANKANZAHLLEEREZELLEN
COUNTIFZÄHLENWENN
COUNTIFSZÄHLENWENNS
DATEDATUM
DATEVALUEDATWERT
DAYTAG
DEC2BINDEZINBIN
DEC2HEXDEZINHEX
EOMONTHMONATSENDE
EVENGERADE
EXACTIDENTISCH
FACTFAKULTÄT
FINDFINDEN
FLOORUNTERGRENZE
HEX2BINHEXINBIN
HEX2DECHEXINDEZ
HLOOKUPHVERWEIS
HYPERLINKHYPERLINK
IFWENN
IFERRORWENNFEHLER
INDEXINDEX
INDIRECTINDIREKT
INFOINFO
INTGANZZAHL
ISBLANKISTLEER
ISERRORISTFEHLER
ISEVENISTGERADE
ISNAISTNV
ISNONTEXTISTKTEXT
ISNUMBERISTZAHL
ISODDISTUNGERADE
ISTEXTISTTEXT
LARGEKGRÖSSTE
LEFTLINKS
LENLÄNGE
LOOKUPLOOKUP
LOWERKLEIN
MATCHVERGLEICH
MAXMAX
MEDIANMEDIAN
MIDTEIL
MINMIN
MODREST
MODEMODALWERT
MONTHMONAT
NN
NANV
NETWORKDAYSNETTOARBEITSTAGE
NOTNICHT
NOWJETZT
ODDUNGERADE
OFFSETBEREICH.VERSCHIEBEN
ORODER
PERCENTILEQUANTIL
PIPI
PROPERGROSS2
QUARTILEQUARTILE
RANDZUFALLSZAHL
RANDBETWEENZUFALLSBEREICH
RANKRANG
REPLACEERSETZEN
REPTWIEDERHOLEN
RIGHTRECHTS
ROMANRÖMISCH
ROUNDRUNDEN
ROUNDDOWNABRUNDEN
ROUNDUPAUFRUNDEN
ROWZEILE
ROWSZEILEN
SEARCHSUCHEN
SMALLKKLEINSTE
STDEVSTABW
SUBSTITUTEWECHSELN
SUMSUMME
SUMIFSUMMEWENN
SUMIFSSUMMEWENNS
SUMPRODUCTSUMMENPRODUKT
TEXTTEXT
TODAYHEUTE
TRANSPOSEMTRANS
TRIMGLÄTTEN
UPPERGROSS
VLOOKUPSVERWEIS
WEEKDAYWOCHENTAG
WEEKNUMKALENDERWOCHE
YEARJAHR
TRUEWAHR

2 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 *


two × 1 =