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.
English | German |
---|---|
ABS | ABS |
ADDRESS | ADRESSE |
AGGREGATE | AGGREGAT |
AND | UND |
ARABIC | ARABISCH |
AVERAGE | MITTELWERT |
AVERAGEIF | MITTELWERTWENN |
AVERAGEIFS | MITTELWERTWENNS |
BAHTTEXT | BAHTTEXT |
BIN2DEC | BININDEZ |
BIN2HEX | BININHEX |
CEILING | OBERGRENZE |
CEILING.MATH | OBERGRENZE.MATHEMATIK |
CELL | ZELLE |
CHAR | ZEICHEN |
CHOOSE | WAHL |
CODE | CODE |
COLUMN | SPALTE |
COLUMNS | SPALTEN |
CONCAT | TEXTKETTE |
CONCATENATE | VERKETTEN |
CONVERT | UMWANDELN |
COUNT | ANZAHL |
COUNTA | ANZAHL2 |
COUNTBLANK | ANZAHLLEEREZELLEN |
COUNTIF | ZÄHLENWENN |
COUNTIFS | ZÄHLENWENNS |
DATE | DATUM |
DATEVALUE | DATWERT |
DAY | TAG |
DAYS | TAGE |
DEC2BIN | DEZINBIN |
DEC2HEX | DEZINHEX |
EOMONTH | MONATSENDE |
EVEN | GERADE |
EXACT | IDENTISCH |
FACT | FAKULTÄT |
FILTERXML | XMLFILTERN |
FIND | FINDEN |
FLOOR | UNTERGRENZE |
FLOOR.MATH | UNTERGRENZE.MATHEMATIK |
FORMULATEXT | FORMELTEXT |
FREQUENCY | HÄUFIGKEIT |
HEX2BIN | HEXINBIN |
HEX2DEC | HEXINDEZ |
HLOOKUP | WVERWEIS |
HYPERLINK | HYPERLINK |
IF | WENN |
IFERROR | WENNFEHLER |
IFS | WENNS |
INDEX | INDEX |
INDIRECT | INDIREKT |
INFO | INFO |
INT | GANZZAHL |
ISBLANK | ISTLEER |
ISERROR | ISTFEHLER |
ISEVEN | ISTGERADE |
ISLOGICAL | ISTLOG |
ISNA | ISTNV |
ISNONTEXT | ISTKTEXT |
ISNUMBER | ISTZAHL |
ISODD | ISTUNGERADE |
ISOWEEKNUM | ISOKALENDERWOCHE |
ISTEXT | ISTTEXT |
LARGE | KGRÖSSTE |
LEFT | LINKS |
LEN | LÄNGE |
LOOKUP | VERWEIS |
LOWER | KLEIN |
MATCH | VERGLEICH |
MAX | MAX |
MAXIFS | MAXWENNS |
MEDIAN | MEDIAN |
MID | TEIL |
MIN | MIN |
MINIFS | MINWENNS |
MOD | REST |
MODE | MODALWERT |
MONTH | MONAT |
MROUND | VRUNDEN |
N | N |
NA | NV |
NETWORKDAYS | NETTOARBEITSTAGE |
NETWORKDAYS.INTL | NETTOARBEITSTAGE.INTL |
NOT | NICHT |
NOW | JETZT |
ODD | UNGERADE |
OFFSET | BEREICH.VERSCHIEBEN |
OR | ODER |
PERCENTILE | QUANTIL |
PERCENTILE.EXC | QUANTIL.EXKL |
PERCENTILE.INC | QUANTIL.INKL |
PERCENTRANK | QUANTILSRANG |
PERCENTRANK.EXC | QUANTILSRANG.EXKL |
PERCENTRANK.INC | QUANTILSRANG.INKL |
PI | PI |
PMT | RMZ |
PROPER | GROSS2 |
QUARTILE | QUARTILE |
QUARTILE.EXC | QUARTILE.EXKL |
QUARTILE.INC | QUARTILE.INKL |
RAND | ZUFALLSZAHL |
RANDBETWEEN | ZUFALLSBEREICH |
RANK | RANG |
RANK.AVG | RANG.MITTELW |
RANK.EQ | RANG.GLEICH |
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 |
STDEV.P | STABW.N |
STDEV.S | STABW.S |
SUBSTITUTE | WECHSELN |
SUBTOTAL | TEILERGEBNIS |
SUM | SUMME |
SUMIF | SUMMEWENN |
SUMIFS | SUMMEWENNS |
SUMPRODUCT | SUMMENPRODUKT |
SWITCH | ERSTERWERT |
TEXT | TEXT |
TEXTJOIN | TEXTVERKETTEN |
TODAY | HEUTE |
TRANSPOSE | MTRANS |
TRIM | GLÄTTEN |
UNICHAR | UNIZEICHEN |
UNICODE | UNICODE |
UPPER | GROSS |
VLOOKUP | SVERWEIS |
WEEKDAY | WOCHENTAG |
WEEKNUM | KALENDERWOCHE |
YEAR | JAHR |
FALSE | FALSCH |
TRUE | WAHR |
Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Office Excel.
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?!)
Amazing!!! Very usefull. Thank You so much!