Excel Function Name Converter — Between Languages

⇄ Deutsch → Türkçe

Convert any Excel function name between English, German, French, Turkish, Arabic, Azerbaijani and Persian — with Persian description and function link.

Result: Deutsch =SUMMEWENNS() → Türkçe =ÇOKETOPLA()

How to use the SUMIFS function in Excel, one of Excel’s math and trig functions, to add arguments that meet multiple criteria.

Syntax — =SUMIFS() Math & Trig

⇄ All mappings — 77

Convert any Excel function name between English, German, French, Turkish, Arabic, Azerbaijani and Persian — with Persian description and function link.

#	Slug	English	Deutsch	Français	Türkçe	العربية	Azərbaycanca	فارسی	Description
1	sum	SUM	SUMME	SOMME	TOPLA	مجموع	CƏM	SUM	How to use the SUM function in Excel to add individual values, cell references, ranges, or a mix of all three.
2	sumif	SUMIF	SUMMEWENN	SOMME.SI	ETOPLA	مجموع_بشرط	CƏMƏGƏR	SUMIF	How to use the SUMIF function in Excel to add the values in a range that meet criteria that you specify.
3	sumifs	SUMIFS	SUMMEWENNS	SOMME.SI.ENS	ÇOKETOPLA	مجموع_بشروط	ÇOX_CƏMƏGƏR	SUMIFS	How to use the SUMIFS function in Excel, one of Excel’s math and trig functions, to add arguments that meet multiple criteria.
4	sumproduct	SUMPRODUCT	SUMMENPRODUKT	SOMMEPROD	TOPLA.ÇARPIM	مجموع_حاصل_الضرب	CƏM_HASİL	SUMPRODUCT	How to use the SUMPRODUCT function in Excel, one of Excel’s math and trig functions, using multiplication, addition, subtraction, and/or division to return the sum of the products of corresponding ranges or arrays.
5	average	AVERAGE	MITTELWERT	MOYENNE	ORTALAMA	متوسط	ORTA	AVERAGE	Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula ⁠=⁠AVERAGE(A1:A20) returns the average of those numbers.
6	averageif	AVERAGEIF	MITTELWERTWENN	MOYENNE.SI	EĞERORTALAMA	متوسط_بشرط	ORTAƏGƏR	AVERAGEIF	Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.
7	averageifs	AVERAGEIFS	MITTELWERTWENNS	MOYENNE.SI.ENS	ÇOKORTALAMA	متوسط_بشروط	ÇOX_ORTAƏGƏR	AVERAGEIFS	Returns the average (arithmetic mean) of all cells that meet multiple criteria.
8	count	COUNT	ANZAHL	NB	BAĞ_DEĞ_SAY	عدد	SAY	COUNT	How to use the COUNT function in Excel to count the number of cells that contain numbers, and to count numbers within a list of arguments.
9	counta	COUNTA	ANZAHL2	NBVAL	BAĞ_DEĞ_DOLU_SAY	عدد_غير_فارغ	DOLU_SAY	COUNTA	The COUNTA function counts the number of cells that are not empty in a range.
10	countif	COUNTIF	ZÄHLENWENN	NB.SI	EĞERSAY	عدد_بشرط	SAYƏGƏR	COUNTIF	Conditional count (a single condition)
11	countifs	COUNTIFS	ZÄHLENWENNS	NB.SI.ENS	ÇOKEĞERSAY	عدد_بشروط	ÇOX_SAYƏGƏR	COUNTIFS	How to use the COUNTIFS function in Excel to apply criteria to cells, across multiple ranges, and count the number of times all criteria are met.
12	countblank	COUNTBLANK	ANZAHLLEEREZELLEN	NB.VIDE	BOŞLUKSAY	عدد_الفراغات	BOŞ_SAY	COUNTBLANK	Use the COUNTBLANK function, one of the Statistical functions, to count the number of empty cells in a range of cells.
13	max	MAX	MAX	MAX	MAK	حد_أقصى	MAKS	MAX	Returns the largest value in a set of values.
14	min	MIN	MIN	MIN	MİN	حد_أدنى	MİN	MIN	Returns the smallest number in a set of values.
15	large	LARGE	KGRÖSSTE	GRANDE.VALEUR	BÜYÜK	كبير	BÖYÜK	LARGE	Returns the k-th largest value in a data set. You can use this function to select a value based on its relative standing. For example, you can use LARGE to return the highest, runner-up, or third-place score.
16	small	SMALL	KKLEINSTE	PETITE.VALEUR	KÜÇÜK	صغير	KİÇİK	SMALL	Returns the k-th smallest value in a data set. Use this function to return values with a particular relative standing in a data set.
17	rank	RANK	RANG	RANG	SIRALAMA	ترتيب	RANQ	RANK	Returns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list. (If you were to sort the list, the rank of the number would be its position.) For more information about the new functions, see RANK.AVG function and RANK.EQ function.
18	rank-eq	RANK.EQ	RANG.GLEICH	RANG.EGALITE	RANK.EŞİT	ترتيب_مساو	RANQ.BƏRABƏR	RANK.EQ	Returns the rank of a number in a list of numbers. Its size is relative to other values in the list; if more than one value has the same rank, the top rank of that set of values is returned. If you were to sort the list, the rank of the number would be its position.
19	if	IF	WENN	SI	EĞER	إذا	ƏGƏR	IF	How to use the IF function in Excel to make logical comparisons between data values.
20	ifs	IFS	WENNS	SI.CONDITIONS	ÇOKEĞER	إذا_متعدد	ÇOX_ƏGƏR	IFS	The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS will allow you to include up to 127 pairs of conditions (the test if something is True and the result if something is true). IFS can take the place of multiple nested IF statements.
21	ifna	IFNA	WENNSNV	SI.NON.DISP	EĞERYOKSA	إذا_NA	ƏGƏRYOXSA	IFNA	The IFNA function returns the value you specify if a formula returns the #N/A error value; otherwise it returns the result of the formula.
22	isblank	ISBLANK	ISTLEER	ESTVIDE	BOŞMU	فراغ	BOŞDUR	ISBLANK	Checks whether a cell is empty or not?
23	isna	ISNA	ISTNV	ESTNA	EDEĞER	NA_خطأ	ND_XƏTA	ISNA	Whether it is the #N/A error or not
24	iserr	ISERR	ISTFEHL	ESTERREUR	EHATA	خطأ_عام	XƏTADIR	ISERR	Whether a formula is an error or not
25	and	AND	UND	ET	VE	و	VƏ	AND	Use the AND function, one of the logical functions, to determine if all conditions in a test are TRUE.
26	or	OR	ODER	OU	VEYA	أو	YA	OR	Use the OR function, one of the logical functions, to determine if any conditions in a test are TRUE.
27	not	NOT	NICHT	NON	DEĞİL	ليس	DEYİL	NOT	Use the NOT function, one of the logical functions, when you want to make sure one value is not equal to another. One common use for the NOT function is to expand the usefulness of other functions that perform logical tests. For example, the IF function performs a logical test and then returns one value if the test evaluates to TRUE and another value if the test evaluates to FALSE. By using the NOT function as the logical_test argument of the IF function, you can test many different conditions instead of just one.
28	vlookup	VLOOKUP	SVERWEIS	RECHERCHEV	DÜŞEYARA	بحث_عمودي	ŞAQULİ_AKTAR	VLOOKUP	Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.
29	hlookup	HLOOKUP	WVERWEIS	RECHERCHEH	YATAYARA	بحث_أفقي	ÜFİQİ_AKTAR	HLOOKUP	Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array. Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. Use VLOOKUP when your comparison values are located in a column to the left of the data you want to find. The H in HLOOKUP stands for "Horizontal."
30	xlookup	XLOOKUP	XVERWEIS	RECHERCHEX	ÇAPRAZARA	بحث_متقاطع	ÇARPАЗ_AKTAR	XLOOKUP	Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.
31	xmatch	XMATCH	XVERGLEICH	EQUIVX	ÇAPRAZKAÇINCI	مطابقة_متقاطعة	ÇARPАЗ_UYĞUN	XMATCH	The XMATCH function searches for a specified item in an array or range of cells, and then returns the relative position of the first match.
32	index	INDEX	INDEX	INDEX	İNDİS	فهرس	İNDEKS	INDEX	Returns the value of an element in a table or an array, selected by the row and column number indexes. Use the array form if the first argument to INDEX is an array constant. Returns the reference of the cell at the intersection of a particular row and column. If the reference is made up of non-adjacent selections, you can pick the selection to look in.
33	match	MATCH	VERGLEICH	EQUIV	KAÇINCI	مطابقة	UYĞUN	MATCH	How to use the MATCH function in Excel to search for a specified item in a range of cells, returning the relative position of that item in the range.
34	offset	OFFSET	BEREICH.VERSCHIEBEN	DECALER	KAYDIR	إزاحة	SÜRÜŞDÜR	OFFSET	Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference that is returned can be a single cell or a range of cells. You can specify the number of rows and the number of columns to be returned.
35	choose	CHOOSE	WAHL	CHOISIR	ELEMAN	اختيار	SEÇ	CHOOSE	Uses index_num to return a value from the list of value arguments. Use CHOOSE to select one of up to 254 values based on the index number. For example, if value1 through value7 are the days of the week, CHOOSE returns one of the days when a number between 1 and 7 is used as index_num.
36	address	ADDRESS	ADRESSE	ADRESSE	ADRES	عنوان	ÜNVAN	ADDRESS	You can use the ADDRESS function to obtain the address of a cell in a worksheet, given specified row and column numbers. For example, ADDRESS(2,3) returns $C$2. As another example, ADDRESS(77,300) returns $KN$77. You can use other functions, such as the ROW and COLUMN functions, to provide the row and column number arguments for the ADDRESS function.
37	column	COLUMN	SPALTE	COLONNE	SÜTUN	عمود	SÜTUN	COLUMN	Syntax: COLUMN([reference])
38	row	ROW	ZEILE	LIGNE	SATIR	صف	SƏTİR	ROW	Returns the row number of a reference.
39	indirect	INDIRECT	INDIREKT	INDIRECT	DOLAYLI	غير_مباشر	DOLAYI	INDIRECT	Returns the reference specified by a text string. References are immediately evaluated to display their contents. Use INDIRECT when you want to change the reference to a cell within a formula without changing the formula itself.
40	filter	FILTER	FILTER	FILTRE	FİLTRE	تصفية	FİLTR	FILTER	How to use the FILTER function in Excel to filter a range of data based on criteria you define.
41	sort	SORT	SORTIEREN	TRIER	SIRALA	فرز	SIRALA	SORT	Learn about the SORT function, which sorts the contents of a range or array. SORT is in a class of functions called dynamic arrays.
42	sortby	SORTBY	SORTIERENNACH	TRIERPAR	SIRALAÖLÇÜT	فرز_حسب	SIRALA_ÖLÇÜ	SORTBY	Learn about the SORTBY function, which sorts the contents of a range or array based on the values in a corresponding range or array. SORTBY is in a class of functions called dynamic arrays.
43	unique	UNIQUE	EINDEUTIG	UNIQUE	BENZERSİZ	فريد	UNİKAL	UNIQUE	Learn about the UNIQUE function, which returns a list of unique values in a list or range. UNIQUE is in a class of functions called dynamic arrays.
44	sequence	SEQUENCE	SEQUENZ	SEQUENCE	SEKANS	متتابعة	ARDICILLIQ	SEQUENCE	Learn more about the SEQUENCE function, which allows you to generate a list of sequential numbers in an array, such as 1, 2, 3, 4. SEQUENCE is in a class of functions called dynamic arrays.
45	transpose	TRANSPOSE	MTRANS	TRANSPOSE	DEVRİK_DÖNÜŞÜM	منقول	TRANSPON	TRANSPOSE	How to use the TRANSPOSE function in Excel to switch or rotate cells.
46	vstack	VSTACK	VSTAPELN	ASSEMB.V	DİKEYYIĞ	تكديس_عمودي	ŞAQULİ_YIĞ	VSTACK	The arrays to append.
47	hstack	HSTACK	HSTAPELN	ASSEMB.H	YATAYYIĞ	تكديس_أفقي	ÜFİQİ_YIĞ	HSTACK	The arrays to append.
48	left	LEFT	LINKS	GAUCHE	SOLDAN	يسار	SOLDAN	LEFT	LEFT returns the first character or characters in a text string, based on the number of characters you specify.
49	right	RIGHT	RECHTS	DROITE	SAĞDAN	يمين	SAĞDAN	RIGHT	RIGHT returns the last character or characters in a text string, based on the number of characters you specify.
50	mid	MID	TEIL	STXT	PARÇAAL	وسط	ORTA	MID	MID returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.
51	len	LEN	LÄNGE	NBCAR	UZUNLUK	طول	UZUNLUQ	LEN	LEN returns the number of characters in a text string.
52	trim	TRIM	GLÄTTEN	SUPPRESPACE	KIRP	تقليم	TƏMİZLƏ	TRIM	Removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular spacing.
53	find	FIND	FINDEN	TROUVE	BUL	بحث	TAP	FIND	Finds the position of a text inside another text (case-sensitive)
54	search	SEARCH	SUCHEN	CHERCHE	MBUL	بحث_متقدم	AXTAR	SEARCH	The SEARCH function locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string. For example, to find the position of the letter "n" in the word "printer", you can use the following function: =SEARCH("n","printer") This function returns 4 because "n" is the fourth character in the word "printer." You can also search for words within other words. For example, the function =SEARCH("base","database") returns 5, because the word "base" begins at the fifth character of the word "database". You can use the SEARCH to determine the location of a character or text string within another text string, and then use the MID to return the text, or use the REPLACE to change the text. These functions are demonstrated in Example 1 in this article.
55	substitute	SUBSTITUTE	WECHSELN	SUBSTITUE	YERİNEKOY	استبدال	ƏVƏZET	SUBSTITUTE	Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string.
56	text	TEXT	TEXT	TEXTE	METNEÇEVİR	نص	MƏTN	TEXT	The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It's useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols.
57	value	VALUE	WERT	CNUM	SAYIYAÇEVİR	قيمة	DƏYƏR	VALUE	Converts a text string that represents a number to a number.
58	concatenate	CONCATENATE	VERKETTEN	CONCATENER	BİRLEŞTİR	دمج	BİRLƏŞDİR	CONCATENATE	Learn how to concatenate text strings in Excel using the CONCATENATE function. Our step-by-step guide makes it easy to join two or more text strings into one.
59	concat	CONCAT	TEXTKETTE	CONCAT	BİRLEŞTİR	دمج_حديث	BİRLƏŞDİR_YENİ	CONCAT	The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide delimiter or IgnoreEmpty arguments.
60	textjoin	TEXTJOIN	TEXTVERKETTEN	JOINDRE.TEXTE	METİNBİRLEŞTİR	دمج_نصي	MƏTN_BİRLƏŞDİR	TEXTJOIN	The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.
61	let	LET	LET	LETTRE	DEĞİŞKEN	دع	LET	LET	LET function
62	round	ROUND	RUNDEN	ARRONDI	YUVARLA	تقريب	YUVARLA	ROUND	The ROUND function rounds a number to a specified number of digits. For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula: =ROUND(A1, 2) The result of this function is 23.78.
63	roundup	ROUNDUP	AUFRUNDEN	ARRONDI.SUP	YUKARIYUVARLA	تقريب_لأعلى	YUXARI_YUVARLA	ROUNDUP	Rounds a number up, away from 0 (zero).
64	rounddown	ROUNDDOWN	ABRUNDEN	ARRONDI.INF	AŞAĞIYUVARLA	تقريب_لأسفل	AŞAĞI_YUVARLA	ROUNDDOWN	Rounds a number down, toward zero.
65	int	INT	GANZZAHL	ENT	TAMSAYI	صحيح	TAM	INT	Rounds a number down to the nearest integer.
66	mod	MOD	REST	MOD	MOD	باقي	QALIQ	MOD	Returns the remainder after number is divided by divisor. The result has the same sign as divisor.
67	date	DATE	DATUM	DATE	TARİH	تاريخ	TARİX	DATE	Use Excel's DATE function when you need to take three separate values and combine them to form a date.
68	today	TODAY	HEUTE	AUJOURDHUI	BUGÜN	اليوم	BU_GÜN	TODAY	The TODAY function returns the serial number of the current date. The serial number is the date-time code used by Excel for date and time calculations. If the cell format was General before the function was entered, Excel changes the cell format to Date. If you want to view the serial number, you must change the cell format to General or Number. The TODAY function is useful when you need to have the current date displayed on a worksheet, regardless of when you open the workbook. It is also useful for calculating intervals. For example, if you know that someone was born in 1963, you might use the following formula to find that person's age as of this year's birthday: ⁠=⁠ YEAR( TODAY())-1963 This formula uses the TODAY function as an argument for the YEAR function to obtain the current year, and then subtracts 1963, returning the person's age.
69	now	NOW	JETZT	MAINTENANT	ŞİMDİ	الآن	İNDİ	NOW	Returns the serial number of the current date and time. If the cell format was General before the function was entered, Excel changes the cell format so that it matches the date and time format of your regional settings. You can change the date and time format for the cell by using the commands in the Number group of the Home tab on the Ribbon. The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet.
70	year	YEAR	JAHR	ANNEE	YIL	سنة	İL	YEAR	Returns the year corresponding to a date. The year is returned as an integer in the range 1900-9999.
71	month	MONTH	MONAT	MOIS	AY	شهر	AY	MONTH	Returns the month of a date represented by a serial number. The month is given as an integer, ranging from 1 (January) to 12 (December).
72	day	DAY	TAG	JOUR	GÜN	يوم	GÜN	DAY	Returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31.
73	weekday	WEEKDAY	WOCHENTAG	JOURSEM	HAFTANINGÜNÜ	يوم_الأسبوع	HƏFTƏ_GÜNÜ	WEEKDAY	Returns the day of the week corresponding to a date. The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday), by default.
74	eomonth	EOMONTH	MONATSENDE	FIN.MOIS	SERİAY	آخر_الشهر	AY_SONU	EOMONTH	Returns the serial number for the last day of the month that is the indicated number of months before or after start_date. Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.
75	datedif	DATEDIF	DATEDIF	DATEDIF	ETARİHLİ	فرق_التاريخ	TARİX_FƏRQİ	DATEDIF	Calculates the number of days, months, or years between two dates.
76	networkdays	NETWORKDAYS	NETTOARBEITSTAGE	NB.JOURS.OUVRES	TAMİŞGÜNÜ	أيام_العمل	İŞ_GÜNLƏRİ	NETWORKDAYS	Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during a specific term.
77	pmt	PMT	RMZ	VPM	DEVRESEL_ÖDEME	دفعة	ÖDƏNİŞ	PMT	How to use the PMT function in Excel to calculate monthly loan payments based on constant payments and a constant interest rate.