Home › Excel Function Name Converter — Between Languages

Excel Function Name Converter — Between Languages

⇄ English → فارسی

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

URL: ?from=en&to=fa&q=SUMIFS
مثال: SUMIFS → SUMMEWENNS (de) · VLOOKUP → RECHERCHEV (fr) · SUMMEWENNS → ÇOKETOPLA (tr)

⇄ All mappings — 77

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

# Slug EnglishDeutschFrançaisTü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.