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 |
| 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 |
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?!)