Excel Functions in German

These are the most common Excel functions with German translations.

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


English German
ABS ABS
ADDRESS ADRESSE
AND UND
AVERAGE MITTELWERT
AVERAGEIF MITTELWERTWENN
AVERAGEIFS MITTELWERTWENNS
BAHTTEXT BAHTTEXT
BIN2DEC BININDEZ
BIN2HEX BININHEX
CEILING OBERGRENZE
CHAR ZEICHEN
CHOOSE WAHL
CODE CODE
COLUMN SPALTE
COLUMNS SPALTEN
CONCATENATE VERKETTEN
COUNT ANZAHL
COUNTA ANZAHL2
COUNTBLANK ANZAHLLEEREZELLEN
COUNTIF ZÄHLENWENN
COUNTIFS ZÄHLENWENNS
DATE DATUM
DATEVALUE DATWERT
DAY TAG
DEC2BIN DEZINBIN
DEC2HEX DEZINHEX
EOMONTH MONATSENDE
EVEN GERADE
EXACT IDENTISCH
FACT FAKULTÄT
FIND FINDEN
FLOOR UNTERGRENZE
HEX2BIN HEXINBIN
HEX2DEC HEXINDEZ
HLOOKUP HVERWEIS
HYPERLINK HYPERLINK
IF WENN
IFERROR WENNFEHLER
INDEX INDEX
INDIRECT INDIREKT
INFO INFO
INT GANZZAHL
ISBLANK ISTLEER
ISERROR ISTFEHLER
ISEVEN ISTGERADE
ISNA ISTNV
ISNONTEXT ISTKTEXT
ISNUMBER ISTZAHL
ISODD ISTUNGERADE
ISTEXT ISTTEXT
LARGE KGRÖSSTE
LEFT LINKS
LEN LÄNGE
LOOKUP LOOKUP
LOWER KLEIN
MATCH VERGLEICH
MAX MAX
MEDIAN MEDIAN
MID TEIL
MIN MIN
MOD REST
MODE MODALWERT
MONTH MONAT
N N
NA NV
NETWORKDAYS NETTOARBEITSTAGE
NOT NICHT
NOW JETZT
ODD UNGERADE
OFFSET BEREICH.VERSCHIEBEN
OR ODER
PERCENTILE QUANTIL
PI PI
PROPER GROSS2
QUARTILE QUARTILE
RAND ZUFALLSZAHL
RANDBETWEEN ZUFALLSBEREICH
RANK RANG
REPLACE ERSETZEN
REPT WIEDERHOLEN
RIGHT RECHTS
ROMAN RÖMISCH
ROUND RUNDEN
ROUNDDOWN ABRUNDEN
ROUNDUP AUFRUNDEN
ROW ZEILE
ROWS ZEILEN
SEARCH SUCHEN
SMALL KKLEINSTE
STDEV STABW
SUBSTITUTE WECHSELN
SUM SUMME
SUMIF SUMMEWENN
SUMIFS SUMMEWENNS
SUMPRODUCT SUMMENPRODUKT
TEXT TEXT
TODAY HEUTE
TRANSPOSE MTRANS
TRIM GLÄTTEN
UPPER GROSS
VLOOKUP SVERWEIS
WEEKDAY WOCHENTAG
WEEKNUM KALENDERWOCHE
YEAR JAHR
TRUE WAHR


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 *


− 3 = four

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>