Excel functions in English and German: the translator

The most common ones: VLOOKUP = SVERWEIS, XLOOKUP = XVERWEIS, SUMIF = SUMMEWENN, COUNTIF = ZÄHLENWENN, IF = WENN, IFERROR = WENNFEHLER, MATCH = VERGLEICH, AVERAGE = MITTELWERT.

All functions

Find a function (English or German)

Math and rounding

English	German	What it does	Available
SUM	SUMME	Adds numbers	all versions
SUMIF	SUMMEWENN	Sum with one condition	all versions
SUMIFS	SUMMEWENNS	Sum with several conditions	all versions
SUMPRODUCT	SUMMENPRODUKT	Sum of the products of ranges	all versions
PRODUCT	PRODUKT	Multiplies numbers	all versions
ROUND	RUNDEN	Rounds to a number of digits	all versions
ROUNDUP	AUFRUNDEN	Always rounds up	all versions
ROUNDDOWN	ABRUNDEN	Always rounds down	all versions
CEILING.MATH	OBERGRENZE.MATHEMATIK	Rounds up to a multiple	all versions
FLOOR.MATH	UNTERGRENZE.MATHEMATIK	Rounds down to a multiple	all versions
INT	GANZZAHL	Rounds down to an integer	all versions
MOD	REST	Remainder of a division	all versions
ABS	ABS	Absolute value	all versions
POWER	POTENZ	Raises a number to a power	all versions
SQRT	WURZEL	Square root	all versions
SUBTOTAL	TEILERGEBNIS	Subtotal that ignores filtered rows	all versions
AGGREGATE	AGGREGAT	Aggregate that can ignore errors	all versions
RAND	ZUFALLSZAHL	Random number between 0 and 1	all versions
RANDBETWEEN	ZUFALLSBEREICH	Random integer in a range	all versions

Counting and statistics

English	German	What it does	Available
AVERAGE	MITTELWERT	Average	all versions
AVERAGEIF	MITTELWERTWENN	Average with one condition	all versions
AVERAGEIFS	MITTELWERTWENNS	Average with several conditions	all versions
MIN	MIN	Smallest value	all versions
MAX	MAX	Largest value	all versions
MINIFS	MINWENNS	Smallest value with conditions	Excel 2019 and later
MAXIFS	MAXWENNS	Largest value with conditions	Excel 2019 and later
MEDIAN	MEDIAN	Middle value	all versions
LARGE	KGRÖSSTE	k-th largest value	all versions
SMALL	KKLEINSTE	k-th smallest value	all versions
RANK.EQ	RANG.GLEICH	Rank of a number in a list	all versions
STDEV.S	STABW.S	Standard deviation of a sample	all versions
COUNT	ANZAHL	Counts cells with numbers	all versions
COUNTA	ANZAHL2	Counts non-empty cells	all versions
COUNTBLANK	ANZAHLLEEREZELLEN	Counts empty cells	all versions
COUNTIF	ZÄHLENWENN	Counts with one condition	all versions
COUNTIFS	ZÄHLENWENNS	Counts with several conditions	all versions

Logic and errors

English	German	What it does	Available
IF	WENN	If-then-else	all versions
IFS	WENNS	Checks several conditions in order	Excel 2019 and later
SWITCH	ERSTERWERT	Compares a value with a list	Excel 2019 and later
AND	UND	All conditions true	all versions
OR	ODER	At least one condition true	all versions
XOR	XODER	Exclusive or	all versions
NOT	NICHT	Reverses a logical value	all versions
IFERROR	WENNFEHLER	Fallback value on error	all versions
IFNA	WENNNV	Fallback value on #N/A	all versions
LET	LET	Names intermediate results	Excel 2021 and later, Microsoft 365
LAMBDA	LAMBDA	Defines custom functions	Excel 2024 and later, Microsoft 365

Lookup and references

English	German	What it does	Available
VLOOKUP	SVERWEIS	Vertical lookup	all versions
HLOOKUP	WVERWEIS	Horizontal lookup	all versions
XLOOKUP	XVERWEIS	Lookup in any direction	Excel 2021 and later, Microsoft 365
INDEX	INDEX	Value at a position	all versions
MATCH	VERGLEICH	Position of a value	all versions
XMATCH	XVERGLEICH	Position of a value, extended	Excel 2021 and later, Microsoft 365
CHOOSE	WAHL	Picks a value from a list by number	all versions
OFFSET	BEREICH.VERSCHIEBEN	Returns a shifted range	all versions
INDIRECT	INDIREKT	Reference from text	all versions
ROW	ZEILE	Row number	all versions
COLUMN	SPALTE	Column number	all versions
ROWS	ZEILEN	Number of rows	all versions
COLUMNS	SPALTEN	Number of columns	all versions
TRANSPOSE	MTRANS	Swaps rows and columns	all versions
HYPERLINK	HYPERLINK	Clickable link	all versions

Dynamic arrays

English	German	What it does	Available
FILTER	FILTER	Filters rows by condition	Excel 2021 and later, Microsoft 365
SORT	SORTIEREN	Sorts a range	Excel 2021 and later, Microsoft 365
UNIQUE	EINDEUTIG	Removes duplicates	Excel 2021 and later, Microsoft 365
SEQUENCE	SEQUENZ	Creates a sequence of numbers	Excel 2021 and later, Microsoft 365
VSTACK	VSTAPELN	Stacks ranges vertically	Excel 2024 and later, Microsoft 365
HSTACK	HSTAPELN	Stacks ranges horizontally	Excel 2024 and later, Microsoft 365

Text

English	German	What it does	Available
LEFT	LINKS	Characters from the left	all versions
RIGHT	RECHTS	Characters from the right	all versions
MID	TEIL	Characters from the middle	all versions
LEN	LÄNGE	Number of characters	all versions
FIND	FINDEN	Position of text (case-sensitive)	all versions
SEARCH	SUCHEN	Position of text	all versions
SUBSTITUTE	WECHSELN	Replaces text	all versions
REPLACE	ERSETZEN	Replaces characters at a position	all versions
UPPER	GROSS	To upper case	all versions
LOWER	KLEIN	To lower case	all versions
PROPER	GROSS2	Capitalizes each word	all versions
TRIM	GLÄTTEN	Removes extra spaces	all versions
CLEAN	SÄUBERN	Removes non-printable characters	all versions
CONCAT	TEXTKETTE	Joins texts	Excel 2019 and later
CONCATENATE	VERKETTEN	Joins texts (older function)	all versions
TEXTJOIN	TEXTVERKETTEN	Joins texts with a delimiter	Excel 2019 and later
TEXTSPLIT	TEXTTEILEN	Splits text at a delimiter	Excel 2024 and later, Microsoft 365
TEXTBEFORE	TEXTVOR	Text before a delimiter	Excel 2024 and later, Microsoft 365
TEXTAFTER	TEXTNACH	Text after a delimiter	Excel 2024 and later, Microsoft 365
TEXT	TEXT	Number as formatted text	all versions
VALUE	WERT	Converts text to a number	all versions
NUMBERVALUE	ZAHLENWERT	Converts text with separators to a number	all versions
EXACT	IDENTISCH	Compares texts exactly	all versions
REPT	WIEDERHOLEN	Repeats text	all versions
CHAR	ZEICHEN	Character from a code	all versions

Date and time

English	German	What it does	Available
TODAY	HEUTE	Today's date	all versions
NOW	JETZT	Current date and time	all versions
DATE	DATUM	Date from year, month, day	all versions
TIME	ZEIT	Time from hour, minute, second	all versions
YEAR	JAHR	Year of a date	all versions
MONTH	MONAT	Month of a date	all versions
DAY	TAG	Day of a date	all versions
HOUR	STUNDE	Hour of a time	all versions
MINUTE	MINUTE	Minute of a time	all versions
WEEKDAY	WOCHENTAG	Day of the week as a number	all versions
WEEKNUM	KALENDERWOCHE	Week number	all versions
ISOWEEKNUM	ISOKALENDERWOCHE	ISO week number	all versions
EDATE	EDATUM	Date plus months	all versions
EOMONTH	MONATSENDE	Last day of a month	all versions
WORKDAY	ARBEITSTAG	Date after working days	all versions
NETWORKDAYS	NETTOARBEITSTAGE	Working days between two dates	all versions
DATEDIF	DATEDIF	Difference of two dates in years, months or days	all versions

Information

English	German	What it does	Available
ISBLANK	ISTLEER	Is the cell empty?	all versions
ISNUMBER	ISTZAHL	Is the value a number?	all versions
ISTEXT	ISTTEXT	Is the value text?	all versions
ISERROR	ISTFEHLER	Is the value an error?	all versions
ISNA	ISTNV	Is the value #N/A?	all versions

Finance

English	German	What it does	Available
PMT	RMZ	Loan payment	all versions
FV	ZW	Future value	all versions
PV	BW	Present value	all versions
NPV	NBW	Net present value	all versions
IRR	IKV	Internal rate of return	all versions

Not only the names differ

	English Excel	German Excel
Argument separator	comma ,	semicolon ;
Decimal separator	point 1.5	comma 1,5
Logical values	TRUE, FALSE	WAHR, FALSCH
Error values	#N/A, #VALUE!, #REF!, #SPILL!	#NV, #WERT!, #BEZUG!, #ÜBERLAUF!

Example: =VLOOKUP(E2,A2:C6,3,FALSE) becomes =SVERWEIS(E2;A2:C6;3;FALSCH) in German Excel.

Excel translates files automatically

When you open a workbook created in German Excel in an English Excel, all formulas are shown with English names. You only need to translate when you copy a formula as text, for example from a German tutorial, forum or colleague's email.

Practice in either language

Our exercises accept both. =SUMIF(A2:A6,"Berlin",C2:C6) and =SUMMEWENN(A2:A6;"Berlin";C2:C6) both count as correct, and you set your Excel language below each exercise. Start with XLOOKUP or the full Excel course.

Frequently asked questions