Function Translator

Excel function names in English, Spanish, German, French, Portuguese, Italian, Dutch and Polish. Search for a function in any of them, or paste a whole formula and convert it, separators included.

VLOOKUP XLOOKUP IF SUMIF SUMIFS COUNTIF IFERROR INDEX MATCH AVERAGE CONCATENATE TEXTJOIN

Find a function

Function name in any language

Translate a formula

Paste a formula in any language

Examples

From

=VLOOKUP(A2,$F$2:$G$9,2,FALSE)

Parses. Checked by running the English version through our formula engine.

Separators change too: in these 7 languages Excel puts ; between arguments and uses a decimal comma. Text in quotes is never changed.

Separators, TRUE and FALSE, and errors

The function names aren't the only thing that changes. These are the defaults for each country's regional settings.

Language	Between arguments	Decimal	Array constant	TRUE / FALSE
English	`,`	`.`	`{1,2;3,4}`	`TRUE` / `FALSE`
Spanish	`;`	`,`	`{1\2;3\4}`	`VERDADERO` / `FALSO`
German	`;`	`,`	`{1.2;3.4}`	`WAHR` / `FALSCH`
French	`;`	`,`	`{1.2;3.4}`	`VRAI` / `FAUX`
Portuguese (Brazil)	`;`	`,`	`{1\2;3\4}`	`VERDADEIRO` / `FALSO`
Italian	`;`	`,`	`{1\2.3\4}`	`VERO` / `FALSO`
Dutch	`;`	`,`	`{1\2;3\4}`	`WAAR` / `ONWAAR`
Polish	`;`	`,`	`{1\2;3\4}`	`PRAWDA` / `FAŁSZ`

Spanish: Separators shown are Spain's. Mexico and most of Latin America use a comma between arguments and a decimal point, with the same function names.
German: Array constants separate columns with a period and rows with a semicolon, for example {1.2.3;4.5.6}. Microsoft's German article on array constants shows English separators, so treat this one as likely rather than confirmed.
Portuguese (Brazil): These are the names in Brazilian Portuguese Excel. Portugal's Portuguese Excel uses many of the same names but not all of them.
Italian: Microsoft's Italian article on array constants separates columns with \ and rows with a period. Array separators follow your Windows regional settings, so check yours if an array constant is rejected.

Error values. #SPILL! and #CALC! are left out until we can confirm their names.
English	Spanish	German	French	Portuguese (Brazil)	Italian	Dutch	Polish
`#N/A`	`#N/A`	`#NV`	`#N/A`	`#N/D`	`#N/D`	`#N/B`	`#N/D!`
`#VALUE!`	`#¡VALOR!`	`#WERT!`	`#VALEUR!`	`#VALOR!`	`#VALORE!`	`#WAARDE!`	`#ARG!`
`#REF!`	`#¡REF!`	`#BEZUG!`	`#REF!`	`#REF!`	`#RIF!`	`#VERW!`	`#ADR!`
`#DIV/0!`	`#¡DIV/0!`	`#DIV/0!`	`#DIV/0!`	`#DIV/0!`	`#DIV/0!`	`#DEEL/0!`	`#DZIEL/0!`
`#NAME?`	`#¿NOMBRE?`	`#NAME?`	`#NOM?`	`#NOME?`	`#NOME?`	`#NAAM?`	`#NAZWA?`
`#NUM!`	`#¡NUM!`	`#ZAHL!`	`#NOMBRE!`	`#NÚM!`	`#NUM!`	`#GETAL!`	`#LICZBA!`
`#NULL!`	`#¡NULO!`	`#NULL!`	`#NUL!`	`#NULO!`	`#NULLO!`	`#LEEG!`	`#ZERO!`

All 164 functions in 8 languages

Grouped by what they do. † means the name was confirmed by one source rather than two; a dash means we couldn't confirm it yet, so use the English name with care.

Lookup

English	Spanish	German	French	Portuguese (Brazil)	Italian	Dutch	Polish
`ADDRESS`Builds a cell address as text, like "$B$3".	`DIRECCION`	`ADRESSE`	`ADRESSE`	`ENDEREÇO`	`INDIRIZZO`	`ADRES`	`ADRES`
`COLUMN`Column number of a reference, or of this cell.	`COLUMNA`	`SPALTE`	`COLONNE`	`COL`	`RIF.COLONNA`	`KOLOM`	`NR.KOLUMNY`
`COLUMNS`Number of columns in a range.	`COLUMNAS`	`SPALTEN`	`COLONNES`	`COLS`	`COLONNE`	`KOLOMMEN`	`LICZBA.KOLUMN`
`HLOOKUP`Horizontal version of VLOOKUP.	`BUSCARH`	`WVERWEIS`	`RECHERCHEH`	`PROCH`	`CERCA.ORIZZ`	`HORIZ.ZOEKEN`	`WYSZUKAJ.POZIOMO`
`INDEX`Value at a given row and column of a range.	`INDICE`	`INDEX`	`INDEX`	`ÍNDICE`	`INDICE`	`INDEX`	`INDEKS`
`INDIRECT`Turns text such as "B3" into a reference.	`INDIRECTO`	`INDIREKT`	`INDIRECT`	`INDIRETO`	`INDIRETTO`	`INDIRECT`	`ADR.POŚR`
`LOOKUP`Finds a value in a sorted row or column and returns the matching one (approximate match).	`BUSCAR`	`VERWEIS`	`RECHERCHE`	`PROC`	`CERCA`	`ZOEKEN`	`WYSZUKAJ`
`MATCH`Position of a value in a list. 0 = exact match.	`COINCIDIR`	`VERGLEICH`	`EQUIV`	`CORRESP`	`CONFRONTA`	`VERGELIJKEN`	`PODAJ.POZYCJĘ`
`OFFSET`A reference moved a given number of rows and columns.	`DESREF`	`BEREICH.VERSCHIEBEN`	`DECALER`	`DESLOC`	`SCARTO`	`VERSCHUIVING`	`PRZESUNIĘCIE`
`ROW`Row number of a reference, or of this cell.	`FILA`	`ZEILE`	`LIGNE`	`LIN`	`RIF.RIGA`	`RIJ`	`WIERSZ`
`ROWS`Number of rows in a range.	`FILAS`	`ZEILEN`	`LIGNES`	`LINS`	`RIGHE`	`RIJEN`	`ILE.WIERSZY`
`VLOOKUP`Finds a value in the first column and returns a value from the same row. Use FALSE for exact.	`BUSCARV`	`SVERWEIS`	`RECHERCHEV`	`PROCV`	`CERCA.VERT`	`VERT.ZOEKEN`	`WYSZUKAJ.PIONOWO`
`XLOOKUP`Searches one range and returns the matching item from another.	`BUSCARX`	`XVERWEIS`	`RECHERCHEX`	`PROCX`	`CERCA.X`	`X.ZOEKEN`	`X.WYSZUKAJ`†
`XMATCH`Modern MATCH: exact by default.	`COINCIDIRX`	`XVERGLEICH`†	`EQUIVX`†	`CORRESPX`	`CONFRONTA.X`†	`X.VERGELIJKEN`†	`X.DOPASUJ`†

Logic

English	Spanish	German	French	Portuguese (Brazil)	Italian	Dutch	Polish
`AND`TRUE if every argument is true.	`Y`	`UND`	`ET`	`E`	`E`	`EN`	`ORAZ`
`CHOOSE`Picks a value by its position in the list.	`ELEGIR`	`WAHL`	`CHOISIR`	`ESCOLHER`	`SCEGLI`	`KIEZEN`	`WYBIERZ`
`IF`Returns one value if a test is true, another if false.	`SI`	`WENN`	`SI`	`SE`	`SE`	`ALS`	`JEŻELI`
`IFERROR`Returns a fallback when the value is any error.	`SI.ERROR`	`WENNFEHLER`	`SIERREUR`	`SEERRO`	`SE.ERRORE`	`ALS.FOUT`	`JEŻELI.BŁĄD`
`IFNA`Returns a fallback only for #N/A.	`SI.ND`	`WENNNV`	`SI.NON.DISP`	`SENÃODISP`	`SE.NON.DISP.`	`ALS.NB`	`JEŻELI.ND`
`IFS`Returns the value for the first true test.	`SI.CONJUNTO`	`WENNS`	`SI.CONDITIONS`	`SES`	`PIÙ.SE`	`ALS.VOORWAARDEN`	`WARUNKI`
`LET`Names values inside a formula.	`LET`†	`LET`†	`LET`†	`LET`†	`LET`†	`LET`†	`LET`†
`NOT`Reverses TRUE and FALSE.	`NO`	`NICHT`	`NON`	`NÃO`	`NON`	`NIET`	`NIE`
`OR`TRUE if any argument is true.	`O`	`ODER`	`OU`	`OU`	`O`	`OF`	`LUB`
`SWITCH`Matches an expression against a list of values.	`CAMBIAR`	`ERSTERWERT`	`SI.MULTIPLE`	`PARÂMETRO`	`SWITCH`	`SCHAKELEN`	`PRZEŁĄCZ`
`XOR`TRUE if an odd number of arguments are true.	`XO`	`XODER`	`OUX`	`XOR`	`XOR`	`EX.OF`	`XOR`

Conditional

English	Spanish	German	French	Portuguese (Brazil)	Italian	Dutch	Polish
`AVERAGEIF`Average of values that meet a condition.	`PROMEDIO.SI`	`MITTELWERTWENN`	`MOYENNE.SI`	`MÉDIASE`	`MEDIA.SE`	`GEMIDDELDE.ALS`	`ŚREDNIA.JEŻELI`
`AVERAGEIFS`Average of values that meet every condition.	`PROMEDIO.SI.CONJUNTO`	`MITTELWERTWENNS`	`MOYENNE.SI.ENS`	`MÉDIASES`	`MEDIA.PIÙ.SE`	`GEMIDDELDEN.ALS`	`ŚREDNIA.WARUNKÓW`
`COUNTIF`Counts cells that meet one condition.	`CONTAR.SI`	`ZÄHLENWENN`	`NB.SI`	`CONT.SE`	`CONTA.SE`	`AANTAL.ALS`	`LICZ.JEŻELI`
`COUNTIFS`Counts rows that meet every condition.	`CONTAR.SI.CONJUNTO`	`ZÄHLENWENNS`	`NB.SI.ENS`	`CONT.SES`	`CONTA.PIÙ.SE`	`AANTALLEN.ALS`	`LICZ.WARUNKI`
`MAXIFS`Largest value that meets every condition.	`MAX.SI.CONJUNTO`	`MAXWENNS`	`MAX.SI.ENS`	`MÁXIMOSES`	`MAX.PIÙ.SE`	`MAX.ALS.VOORWAARDEN`	`MAKS.WARUNKÓW`
`MINIFS`Smallest value that meets every condition.	`MIN.SI.CONJUNTO`	`MINWENNS`	`MIN.SI.ENS`	`MÍNIMOSES`	`MIN.PIÙ.SE`	`MIN.ALS.VOORWAARDEN`	`MIN.WARUNKÓW`
`SUMIF`Adds values where the range meets a condition.	`SUMAR.SI`	`SUMMEWENN`	`SOMME.SI`	`SOMASE`	`SOMMA.SE`	`SOM.ALS`	`SUMA.JEŻELI`
`SUMIFS`Adds values that meet every condition.	`SUMAR.SI.CONJUNTO`	`SUMMEWENNS`	`SOMME.SI.ENS`	`SOMASES`	`SOMMA.PIÙ.SE`	`SOMMEN.ALS`	`SUMA.WARUNKÓW`

Math

English	Spanish	German	French	Portuguese (Brazil)	Italian	Dutch	Polish
`ABS`Absolute value.	`ABS`	`ABS`	`ABS`	`ABS`	`ASS`	`ABS`	`MODUŁ.LICZBY`
`AGGREGATE`Sum, average, count and more, optionally skipping hidden rows and errors.	`AGREGAR`	`AGGREGAT`	`AGREGAT`	`AGREGAR`	`AGGREGA`	`AGGREGAAT`	`AGREGUJ`
`CEILING`Rounds up to a multiple.	`MULTIPLO.SUPERIOR`	`OBERGRENZE`	`PLAFOND`	`TETO`	`ARROTONDA.ECCESSO`	`AFRONDEN.BOVEN`	`ZAOKR.W.GÓRĘ`
`CEILING.MATH`Rounds a number up to the nearest multiple.	`MULTIPLO.SUPERIOR.MAT`	`OBERGRENZE.MATHEMATIK`	`PLAFOND.MATH`	`TETO.MAT`	`ARROTONDA.ECCESSO.MAT`	`AFRONDEN.BOVEN.WISK`	`ZAOKR.W.GÓRĘ.MATEMATYCZNE`
`EXP`e raised to a power.	`EXP`	`EXP`	`EXP`	`EXP`	`EXP`	`EXP`	`EXP`
`FLOOR`Rounds down to a multiple.	`MULTIPLO.INFERIOR`	`UNTERGRENZE`	`PLANCHER`	`ARREDMULTB`	`ARROTONDA.DIFETTO`	`AFRONDEN.BENEDEN`	`ZAOKR.W.DÓŁ`
`FLOOR.MATH`Rounds a number down to the nearest multiple.	`MULTIPLO.INFERIOR.MAT`	`UNTERGRENZE.MATHEMATIK`	`PLANCHER.MATH`	`ARREDMULTB.MAT`	`ARROTONDA.DIFETTO.MAT`	`AFRONDEN.BENEDEN.WISK`	`ZAOKR.W.DÓŁ.MATEMATYCZNE`
`INT`Rounds down to the nearest integer.	`ENTERO`	`GANZZAHL`	`ENT`	`INT`	`INT`	`INTEGER`	`ZAOKR.DO.CAŁK`
`LN`Natural logarithm.	`LN`	`LN`	`LN`	`LN`	`LN`	`LN`	`LN`
`LOG`Logarithm, base 10 by default.	`LOG`	`LOG`	`LOG`	`LOG`	`LOG`	`LOG`	`LOG`
`LOG10`Base-10 logarithm.	`LOG10`	`LOG10`	`LOG10`	`LOG10`	`LOG10`	`LOG10`	`LOG10`
`MOD`Remainder after division.	`RESIDUO`	`REST`	`MOD`	`MOD`	`RESTO`	`REST`	`MOD`
`MROUND`Rounds to the nearest multiple.	`REDOND.MULT`	`VRUNDEN`	`ARRONDI.AU.MULTIPLE`	`MARRED`	`ARROTONDA.MULTIPLO`	`AFRONDEN.N.VEELVOUD`	`ZAOKR.DO.WIELOKR`
`PI`The constant π.	`PI`	`PI`	`PI`	`PI`	`PI.GRECO`	`PI`	`PI`
`POWER`Raises a number to a power (same as ^).	`POTENCIA`	`POTENZ`	`PUISSANCE`	`POTÊNCIA`	`POTENZA`	`MACHT`	`POTĘGA`
`PRODUCT`Multiplies all the numbers.	`PRODUCTO`	`PRODUKT`	`PRODUIT`	`MULT`	`PRODOTTO`	`PRODUCT`	`ILOCZYN`
`RAND`A random number between 0 and 1.	`ALEATORIO`	`ZUFALLSZAHL`	`ALEA`	`ALEATÓRIO`	`CASUALE`	`ASELECT`	`LOS`
`RANDBETWEEN`A random whole number between two values.	`ALEATORIO.ENTRE`	`ZUFALLSBEREICH`	`ALEA.ENTRE.BORNES`	`ALEATÓRIOENTRE`	`CASUALE.TRA`	`ASELECTTUSSEN`	`LOS.ZAKR`
`ROUND`Rounds to a number of digits; negative digits round left of the decimal.	`REDONDEAR`	`RUNDEN`	`ARRONDI`	`ARRED`	`ARROTONDA`	`AFRONDEN`	`ZAOKR`
`ROUNDDOWN`Rounds toward zero.	`REDONDEAR.MENOS`	`ABRUNDEN`	`ARRONDI.INF`	`ARREDONDAR.PARA.BAIXO`	`ARROTONDA.PER.DIF`	`AFRONDEN.NAAR.BENEDEN`	`ZAOKR.DÓŁ`
`ROUNDUP`Rounds away from zero.	`REDONDEAR.MAS`	`AUFRUNDEN`	`ARRONDI.SUP`	`ARREDONDAR.PARA.CIMA`	`ARROTONDA.PER.ECC`	`AFRONDEN.NAAR.BOVEN`	`ZAOKR.GÓRA`
`SIGN`1, 0 or -1 depending on the sign.	`SIGNO`	`VORZEICHEN`	`SIGNE`	`SINAL`	`SEGNO`	`POS.NEG`	`ZNAK.LICZBY`
`SQRT`Square root.	`RAIZ`	`WURZEL`	`RACINE`	`RAIZ`	`RADQ`	`WORTEL`	`PIERWIASTEK`
`SUBTOTAL`A total that ignores other subtotals and can skip hidden rows.	`SUBTOTALES`	`TEILERGEBNIS`	`SOUS.TOTAL`	`SUBTOTAL`	`SUBTOTALE`	`SUBTOTAAL`	`SUMY.CZĘŚCIOWE`
`SUM`Adds numbers and ranges. Skips text and blanks.	`SUMA`	`SUMME`	`SOMME`	`SOMA`	`SOMMA`	`SOM`	`SUMA`
`SUMPRODUCT`Multiplies arrays row by row and adds the results.	`SUMAPRODUCTO`	`SUMMENPRODUKT`	`SOMMEPROD`	`SOMARPRODUTO`	`MATR.SOMMA.PRODOTTO`	`SOMPRODUCT`	`SUMA.ILOCZYNÓW`
`SUMSQ`Sum of squares.	`SUMA.CUADRADOS`	`QUADRATESUMME`	`SOMME.CARRES`	`SOMAQUAD`	`SOMMA.Q`	`KWADRATENSOM`	`SUMA.KWADRATÓW`
`TRUNC`Cuts off decimals without rounding.	`TRUNCAR`	`KÜRZEN`	`TRONQUE`	`TRUNCAR`	`TRONCA`	`GEHEEL`	`LICZBA.CAŁK`

Stats

English	Spanish	German	French	Portuguese (Brazil)	Italian	Dutch	Polish
`AVERAGE`Arithmetic mean of the numbers.	`PROMEDIO`	`MITTELWERT`	`MOYENNE`	`MÉDIA`	`MEDIA`	`GEMIDDELDE`	`ŚREDNIA`
`COUNT`Counts cells that contain numbers.	`CONTAR`	`ANZAHL`	`NB`	`CONT.NÚM`	`CONTA.NUMERI`	`AANTAL`	`ILE.LICZB`
`COUNTA`Counts cells that are not empty.	`CONTARA`	`ANZAHL2`	`NBVAL`	`CONT.VALORES`	`CONTA.VALORI`	`AANTALARG`	`ILE.NIEPUSTYCH`
`COUNTBLANK`Counts empty cells.	`CONTAR.BLANCO`	`ANZAHLLEEREZELLEN`	`NB.VIDE`	`CONTAR.VAZIO`	`CONTA.VUOTE`	`AANTAL.LEGE.CELLEN`	`LICZ.PUSTE`
`LARGE`k-th largest value.	`K.ESIMO.MAYOR`	`KGRÖSSTE`	`GRANDE.VALEUR`	`MAIOR`	`GRANDE`	`GROOTSTE`	`MAX.K`
`MAX`Largest number.	`MAX`	`MAX`	`MAX`	`MÁXIMO`	`MAX`	`MAX`	`MAX`
`MEDIAN`Middle value of the numbers.	`MEDIANA`	`MEDIAN`	`MEDIANE`	`MED`	`MEDIANA`	`MEDIAAN`	`MEDIANA`
`MIN`Smallest number.	`MIN`	`MIN`	`MIN`	`MÍNIMO`	`MIN`	`MIN`	`MIN`
`MODE`Most frequently occurring number.	`MODA`	`MODALWERT`	`MODE`	`MODO`	`MODA`	`MODUS`	`WYST.NAJCZĘŚCIEJ`
`MODE.SNGL`Most frequently occurring number.	`MODA.UNO`	`MODUS.EINF`	`MODE.SIMPLE`	`MODO.ÚNICO`	`MODA.SNGL`	`MODUS.ENKELV`	`WYST.NAJCZĘŚCIEJ.WART`
`RANK`Rank of a number in a list. 0 or omitted = largest is 1.	`JERARQUIA`	`RANG`	`RANG`	`ORDEM`	`RANGO`	`RANG`	`POZYCJA`
`RANK.EQ`Rank of a number in a list. 0 or omitted = largest is 1.	`JERARQUIA.EQV`	`RANG.GLEICH`	`EQUATION.RANG`	`ORDEM.EQ`	`RANGO.UG`	`RANG.GELIJK`	`POZYCJA.NAJW`
`SMALL`k-th smallest value.	`K.ESIMO.MENOR`	`KKLEINSTE`	`PETITE.VALEUR`	`MENOR`	`PICCOLO`	`KLEINSTE`	`MIN.K`
`STDEV`Sample standard deviation (same as STDEV.S).	`DESVEST`	`STABW`	`ECARTYPE`	`DESVPAD`	`DEV.ST`	`STDEV`	`ODCH.STANDARDOWE`
`STDEV.P`Population standard deviation.	`DESVEST.P`	`STABW.N`	`ECARTYPE.PEARSON`	`DESVPAD.P`	`DEV.ST.P`	`STDEV.P`	`ODCH.STAND.POPUL`
`STDEV.S`Sample standard deviation (same as STDEV.S).	`DESVEST.M`	`STABW.S`	`ECARTYPE.STANDARD`	`DESVPAD.A`	`DEV.ST.C`	`STDEV.S`	`ODCH.STANDARD.PRÓBKI`
`VAR`Sample variance (same as VAR.S).	`VAR`	`VARIANZ`	`VAR`	`VAR`	`VAR`	`VAR`	`WARIANCJA`
`VAR.P`Population variance.	`VAR.P`	`VAR.P`	`VAR.P.N`	`VAR.P`	`VAR.P`	`VAR.P`	`WARIANCJA.POP`
`VAR.S`Sample variance (same as VAR.S).	`VAR.S`	`VAR.S`	`VAR.S`	`VAR.A`	`VAR.C`	`VAR.S`	`WARIANCJA.PRÓBKI`

Text

English	Spanish	German	French	Portuguese (Brazil)	Italian	Dutch	Polish
`CHAR`Character for a code number.	`CARACTER`	`ZEICHEN`	`CAR`	`CARACT`	`CODICE.CARATT`	`TEKEN`	`ZNAK`
`CLEAN`Removes non-printing characters.	`LIMPIAR`	`SÄUBERN`	`EPURAGE`	`TIRAR`	`LIBERA`	`WISSEN.CONTROL`	`OCZYŚĆ`
`CODE`Code number of the first character.	`CODIGO`	`CODE`	`CODE`	`CÓDIGO`	`CODICE`	`CODE`	`KOD`
`CONCAT`Joins text and ranges.	`CONCAT`	`TEXTKETTE`	`CONCAT`	`CONCAT`	`CONCAT`	`TEKST.SAMENV`	`ZŁĄCZ.TEKST`
`CONCATENATE`Joins text (older version of CONCAT).	`CONCATENAR`	`VERKETTEN`	`CONCATENER`	`CONCATENAR`	`CONCATENA`	`TEKST.SAMENVOEGEN`	`ZŁĄCZ.TEKSTY`
`DOLLAR`Formats a number as currency text.	`MONEDA`	`DM`	`DEVISE`	`MOEDA`	`VALUTA`	`EURO`	`KWOTA`
`EXACT`TRUE if two texts match exactly, including case.	`IGUAL`	`IDENTISCH`	`EXACT`	`EXATO`	`IDENTICO`	`GELIJK`	`PORÓWNAJ`
`FIND`Position of text, case-sensitive.	`ENCONTRAR`†	`FINDEN`†	`TROUVE`†	`PROCURAR`†	`TROVA`†	`VIND.ALLES`†	`ZNAJDŹ`†
`FIXED`Rounds a number and returns it as text with a fixed number of decimals.	`DECIMAL`	`FEST`	`CTXT`	`DEF.NÚM.DEC`	`FISSO`	`VAST`	`ZAOKR.DO.TEKST`
`LEFT`Characters from the start of text.	`IZQUIERDA`	`LINKS`	`GAUCHE`	`ESQUERDA`	`SINISTRA`	`LINKS`	`LEWY`
`LEN`Number of characters.	`LARGO`	`LÄNGE`	`NBCAR`	`NÚM.CARACT`	`LUNGHEZZA`	`LENGTE`	`DŁ`
`LOWER`Converts to lowercase.	`MINUSC`	`KLEIN`	`MINUSCULE`	`MINÚSCULA`	`MINUSC`	`KLEINE.LETTERS`	`LITERY.MAŁE`
`MID`Characters from the middle of text.	`EXTRAE`	`TEIL`	`STXT`	`EXT.TEXTO`	`STRINGA.ESTRAI`	`DEEL`	`FRAGMENT.TEKSTU`
`NUMBERVALUE`Converts text to a number using the separators you give.	`VALOR.NUMERO`	`ZAHLENWERT`	`VALEURNOMBRE`	`VALORNUMÉRICO`	`NUMERO.VALORE`	`NUMERIEKE.WAARDE`	`WARTOŚĆ.LICZBOWA`
`PROPER`Capitalizes the first letter of each word.	`NOMPROPIO`	`GROSS2`	`NOMPROPRE`	`PRI.MAIÚSCULA`	`MAIUSC.INIZ`	`BEGINLETTERS`	`Z.WIELKIEJ.LITERY`
`REPLACE`Replaces characters by position.	`REEMPLAZAR`†	`ERSETZEN`	`REMPLACER`	`MUDAR`	`RIMPIAZZA`	`VERVANGEN`	`ZASTĄP`
`REPT`Repeats text.	`REPETIR`	`WIEDERHOLEN`	`REPT`	`REPT`	`RIPETI`	`HERHALING`	`POWT`
`RIGHT`Characters from the end of text.	`DERECHA`	`RECHTS`	`DROITE`	`DIREITA`	`DESTRA`	`RECHTS`	`PRAWY`
`SEARCH`Position of text, not case-sensitive, allows wildcards.	`HALLAR`	`SUCHEN`	`CHERCHE`	`LOCALIZAR`	`RICERCA`	`VIND.SPEC`	`SZUKAJ.TEKST`
`SUBSTITUTE`Replaces matching text.	`SUSTITUIR`	`WECHSELN`	`SUBSTITUE`	`SUBSTITUIR`	`SOSTITUISCI`	`SUBSTITUEREN`	`PODSTAW`
`T`Text unchanged, and empty text for anything else.	`T`	`T`	`T`	`T`	`T`	`T`	`T`
`TEXT`Formats a number or date as text, e.g. "mmm" or "$#,##0".	`TEXTO`	`TEXT`	`TEXTE`	`TEXTO`	`TESTO`	`TEKST`	`TEKST`
`TEXTAFTER`Text after a delimiter.	`TEXTODESPUES`†	`TEXTNACH`	`TEXTE.APRES`†	`TEXTODEPOIS`	`TESTO.DOPO`†	`TEKST.NA`†	`TEKST.PO`†
`TEXTBEFORE`Text before a delimiter.	`TEXTOANTES`†	`TEXTVOR`†	`TEXTE.AVANT`†	`TEXTOANTES`	`TESTO.PRIMA`†	`TEKST.VOOR`†	`TEKST.PRZED`†
`TEXTJOIN`Joins text with a delimiter between items.	`UNIRCADENAS`	`TEXTVERKETTEN`	`JOINDRE.TEXTE`	`UNIRTEXTO`	`TESTO.UNISCI`	`TEKST.COMBINEREN`	`POŁĄCZ.TEKSTY`
`TRIM`Removes extra spaces, leaving single spaces between words.	`ESPACIOS`	`GLÄTTEN`	`SUPPRESPACE`	`ARRUMAR`	`ANNULLA.SPAZI`	`SPATIES.WISSEN`	`USUŃ.ZBĘDNE.ODSTĘPY`
`UNICHAR`The Unicode character for a number.	`UNICAR`	`UNIZEICHEN`	`UNICAR`	`CARACTUNICODE`	`CARATT.UNI`	`UNITEKEN`	`ZNAK.UNICODE`
`UNICODE`The Unicode number of the first character.	`UNICODE`	`UNICODE`	`UNICODE`	`UNICODE`	`UNICODE`	`UNICODE`	`UNICODE`
`UPPER`Converts to uppercase.	`MAYUSC`	`GROSS`	`MAJUSCULE`	`MAIÚSCULA`	`MAIUSC`	`HOOFDLETTERS`	`LITERY.WIELKIE`
`VALUE`Converts text that looks like a number into a number.	`VALOR`	`WERT`	`CNUM`	`VALOR`	`VALORE`	`WAARDE`	`WARTOŚĆ`

Date

English	Spanish	German	French	Portuguese (Brazil)	Italian	Dutch	Polish
`DATE`Builds a date from parts.	`FECHA`	`DATUM`	`DATE`	`DATA`	`DATA`	`DATUM`	`DATA`
`DATEDIF`Difference in "Y", "M", "D", "YM", "MD" or "YD".	`SIFECHA`	`DATEDIF`	`DATEDIF`	`DATADIF`	`DATA.DIFF`	`DATUMVERSCHIL`	`DATA.RÓŻNICA`
`DATEVALUE`Converts date text to a date.	`FECHANUMERO`	`DATWERT`	`DATEVAL`	`DATA.VALOR`	`DATA.VALORE`	`DATUMWAARDE`	`DATA.WARTOŚĆ`
`DAY`Day of the month, 1–31.	`DIA`	`TAG`	`JOUR`	`DIA`	`GIORNO`	`DAG`	`DZIEŃ`
`DAYS`Days between two dates.	`DIAS`	`TAGE`	`JOURS`	`DIAS`	`GIORNI`	`DAGEN`	`DNI`
`EDATE`Date a number of months before or after.	`FECHA.MES`	`EDATUM`	`MOIS.DECALER`	`DATAM`	`DATA.MESE`	`ZELFDE.DAG`	`NR.SER.DATY`
`EOMONTH`Last day of the month, months away.	`FIN.MES`	`MONATSENDE`	`FIN.MOIS`	`FIMMÊS`	`FINE.MESE`	`LAATSTE.DAG`	`NR.SER.OST.DN.MIES`
`HOUR`The hour of a time, 0 to 23.	`HORA`	`STUNDE`	`HEURE`	`HORA`	`ORA`	`UUR`	`GODZINA`
`ISOWEEKNUM`The ISO week number of a date.	`ISO.NUM.DE.SEMANA`	`ISOKALENDERWOCHE`	`NO.SEMAINE.ISO`	`NÚMSEMANAISO`	`NUM.SETTIMANA.ISO`	`ISO.WEEKNUMMER`	`ISO.NUM.TYG`
`MINUTE`The minute of a time, 0 to 59.	`MINUTO`	`MINUTE`	`MINUTE`	`MINUTO`	`MINUTO`	`MINUUT`	`MINUTA`
`MONTH`Month of a date, 1–12.	`MES`	`MONAT`	`MOIS`	`MÊS`	`MESE`	`MAAND`	`MIESIĄC`
`NETWORKDAYS`Weekdays between two dates, inclusive.	`DIAS.LAB`	`NETTOARBEITSTAGE`	`NB.JOURS.OUVRES`	`DIATRABALHOTOTAL`	`GIORNI.LAVORATIVI.TOT`	`NETTO.WERKDAGEN`	`DNI.ROBOCZE`
`NOW`The current date and time.	`AHORA`	`JETZT`	`MAINTENANT`	`AGORA`	`ADESSO`	`NU`	`TERAZ`
`SECOND`The second of a time, 0 to 59.	`SEGUNDO`	`SEKUNDE`	`SECONDE`	`SEGUNDO`	`SECONDO`	`SECONDE`	`SEKUNDA`
`TIME`A time built from hours, minutes and seconds.	`NSHORA`	`ZEIT`	`TEMPS`	`TEMPO`	`ORARIO`	`TIJD`	`CZAS`
`TIMEVALUE`A time typed as text, as a time value.	`HORANUMERO`	`ZEITWERT`	`TEMPSVAL`	`VALOR.TEMPO`	`ORARIO.VALORE`	`TIJDWAARDE`	`CZAS.WARTOŚĆ`
`TODAY`Today's date. Recalculates every day.	`HOY`	`HEUTE`	`AUJOURDHUI`	`HOJE`	`OGGI`	`VANDAAG`	`DZIŚ`
`WEEKDAY`Day of the week as a number; Sunday = 1 by default.	`DIASEM`	`WOCHENTAG`	`JOURSEM`	`DIA.DA.SEMANA`	`GIORNO.SETTIMANA`	`WEEKDAG`†	`DZIEŃ.TYG`
`WEEKNUM`The week number of a date within its year.	`NUM.DE.SEMANA`	`KALENDERWOCHE`	`NO.SEMAINE`	`NÚMSEMANA`	`NUM.SETTIMANA`	`WEEKNUMMER`	`NUM.TYG`
`WORKDAY`Date a number of workdays away.	`DIA.LAB`	`ARBEITSTAG`	`SERIE.JOUR.OUVRE`	`DIATRABALHO`	`GIORNO.LAVORATIVO`	`WERKDAG`	`DZIEŃ.ROBOCZY`
`YEAR`Year of a date.	`AÑO`	`JAHR`	`ANNEE`	`ANO`	`ANNO`	`JAAR`	`ROK`
`YEARFRAC`The fraction of a year between two dates.	`FRAC.AÑO`	`BRTEILJAHRE`	`FRACTION.ANNEE`	`FRAÇÃOANO`	`FRAZIONE.ANNO`	`JAAR.DEEL`	`CZĘŚĆ.ROKU`

Dynamic arrays

English	Spanish	German	French	Portuguese (Brazil)	Italian	Dutch	Polish
`DROP`Removes rows or columns from the start or end.	`EXCLUIR`†	`WEGLASSEN`†	`EXCLURE`†	—	`ESCLUDI`†	`WEGLATEN`†	`UPUŚĆ`†
`FILTER`Rows that pass a TRUE/FALSE test. Spills.	`FILTRAR`†	`FILTER`†	`FILTRE`	`FILTRO`†	`FILTRO`†	`FILTER`†	`FILTRUJ`†
`HSTACK`Places ranges side by side.	`APILARH`†	`HSTAPELN`†	`ASSEMB.H`†	`EMPILHARH`†	`STACK.ORIZ`†	`HOR.STAPELEN`†	`STOS.POZ`†
`SEQUENCE`A grid of sequential numbers. Spills.	`SECUENCIA`†	`SEQUENZ`†	`SEQUENCE`†	`SEQUÊNCIA`†	`SEQUENZA`†	`REEKS`†	`SEKWENCJA`†
`SORT`Sorted copy of a range. -1 = descending. Spills.	`ORDENAR`†	`SORTIEREN`†	`TRIER`	`CLASSIFICAR`†	`DATI.ORDINA`†	`SORTEREN`†	`SORTUJ`†
`SORTBY`Sorts a range by other ranges. Spills.	`ORDENARPOR`†	`SORTIERENNACH`†	`TRIERPAR`†	`CLASSIFICARPOR`†	`DATI.ORDINA.PER`†	`SORTEREN.OP`†	`SORTUJ.WEDŁUG`†
`TAKE`First (or last, if negative) rows or columns.	`TOMAR`†	`ÜBERNEHMEN`†	—	—	—	`NEMEN`†	—
`TRANSPOSE`Flips rows and columns.	`TRANSPONER`	`MTRANS`	`TRANSPOSE`	`TRANSPOR`	`MATR.TRASPOSTA`	`TRANSPONEREN`	`TRANSPONUJ`
`UNIQUE`Distinct rows of a range. Spills.	`UNICOS`	`EINDEUTIG`†	`UNIQUE`	`ÚNICO`	`UNICI`†	`UNIEK`†	`UNIKATOWE`†
`VSTACK`Stacks ranges on top of each other.	`APILARV`†	`VSTAPELN`	`ASSEMB.V`†	`EMPILHARV`†	`STACK.VERT`†	`VERT.STAPELEN`†	`STOS.PION`†

Finance

English	Spanish	German	French	Portuguese (Brazil)	Italian	Dutch	Polish
`FV`Future value of an investment.	`VF`	`ZW`	`VC`	`VF`	`VAL.FUT`	`TW`	`FV`
`IRR`Internal rate of return.	`TIR`	`IKV`	`TRI`†	`TIR`	`TIR.COST`	`IR`	`IRR`
`NPER`Number of periods to pay off or reach a target.	`NPER`	`ZZR`	`NPM`	`NPER`	`NUM.RATE`	`NPER`	`NPER`
`NPV`Net present value of future cash flows (first flow one period out).	`VNA`	`NBW`	`VAN`	`VPL`	`VAN`	`NHW`	`NPV`
`PMT`Payment per period for a loan or annuity.	`PAGO`	`RMZ`	`VPM`	`PGTO`	`RATA`	`BET`	`PMT`
`PV`Present value of future payments.	`VA`	`BW`	`VA`	`VP`	`VA`	`HW`	`PV`
`RATE`Interest rate per period.	`TASA`	`ZINS`	`TAUX`	`TAXA`	`TASSO`	`RENTE`	`RATE`

Info

English	Spanish	German	French	Portuguese (Brazil)	Italian	Dutch	Polish
`CELL`Information about a cell: its address, format, contents or width.	`CELDA`	`ZELLE`	`CELLULE`	`CÉL`	`CELLA`	`CEL`	`KOMÓRKA`
`FORMULATEXT`The formula in a cell, as text.	`FORMULATEXTO`	`FORMELTEXT`	`FORMULETEXTE`	`FÓRMULATEXTO`	`TESTO.FORMULA`	`FORMULETEKST`	`FORMUŁA.TEKST`
`ISBLANK`TRUE if the cell is empty.	`ESBLANCO`	`ISTLEER`	`ESTVIDE`	`ÉCÉL.VAZIA`	`VAL.VUOTO`	`ISLEEG`	`CZY.PUSTA`
`ISERR`TRUE for any error except #N/A.	`ESERR`	`ISTFEHL`	`ESTERR`	`ÉERRO`	`VAL.ERR`	`ISFOUT2`	`CZY.BŁ`
`ISERROR`TRUE for any error.	`ESERROR`	`ISTFEHLER`	`ESTERREUR`	`ÉERROS`	`VAL.ERRORE`	`ISFOUT`	`CZY.BŁĄD`
`ISEVEN`TRUE if the number is even.	`ES.PAR`	`ISTGERADE`	`EST.PAIR`	`ÉPAR`	`VAL.PARI`	`IS.EVEN`	`CZY.PARZYSTE`
`ISFORMULA`TRUE if the cell contains a formula.	`ESFORMULA`	`ISTFORMEL`	`ESTFORMULE`	`ÉFÓRMULA`	`VAL.FORMULA`	`ISFORMULE`	`CZY.FORMUŁA`
`ISLOGICAL`TRUE if the value is TRUE or FALSE.	`ESLOGICO`	`ISTLOG`	`ESTLOGIQUE`	`ÉLÓGICO`	`VAL.LOGICO`	`ISLOGISCH`	`CZY.LOGICZNA`
`ISNA`TRUE for #N/A.	`ESNOD`	`ISTNV`	`ESTNA`	`É.NÃO.DISP`	`VAL.NON.DISP`	`ISNB`	`CZY.BRAK`
`ISNUMBER`TRUE if the value is a number.	`ESNUMERO`	`ISTZAHL`	`ESTNUM`	`ÉNÚM`	`VAL.NUMERO`	`ISGETAL`	`CZY.LICZBA`
`ISODD`TRUE if the number is odd.	`ES.IMPAR`	`ISTUNGERADE`	`EST.IMPAIR`	`ÉIMPAR`	`VAL.DISPARI`	`IS.ONEVEN`	`CZY.NIEPARZYSTE`
`ISTEXT`TRUE if the value is text.	`ESTEXTO`	`ISTTEXT`	`ESTTEXTE`	`ÉTEXTO`	`VAL.TESTO`	`ISTEKST`	`CZY.TEKST`
`N`A value as a number: text becomes 0 and TRUE becomes 1.	`N`	`N`	`N`	`N`	`NUM`	`N`	`N`
`NA`Returns #N/A on purpose.	`NOD`	`NV`	`NA`	`NÃO.DISP`	`NON.DISP`	`NB`	`BRAK`
`TYPE`The kind of value as a number: 1 number, 2 text, 4 logical, 16 error, 64 array.	`TIPO`	`TYP`	`TYPE`	`TIPO`	`TIPO`	`TYPE`	`TYP`

How the names were checked

Excel Function Translator (excel-translator.de): Names taken from Excel's own localized resources, for functions that existed before Excel 2019.
Microsoft Support function articles in each language: Each name was checked against the syntax and examples of Microsoft's localized article, and functions added in Excel 2019 and later come from those articles.
Microsoft Support: ERROR.TYPE in each language: The localized error values.
Microsoft Support: Use array constants in array formulas: Separators inside array constants.

Last checked 2026-10-29. Spot a wrong name? Tell us on the support page and we'll fix it.

Questions

What is VLOOKUP called in other languages?

VLOOKUP is Spanish BUSCARV, German SVERWEIS, French RECHERCHEV, Portuguese (Brazil) PROCV, Italian CERCA.VERT, Dutch VERT.ZOEKEN, Polish WYSZUKAJ.PIONOWO. Its newer replacement XLOOKUP is Spanish BUSCARX, German XVERWEIS, French RECHERCHEX, Portuguese (Brazil) PROCX, Italian CERCA.X, Dutch X.ZOEKEN, Polish X.WYSZUKAJ.

Why do I get #NAME? when I copy a formula from an English tutorial?

Excel only recognizes function names in the language it runs in, so SUMIF typed into a German Excel is an unknown name. Type the local name (SUMMEWENN in German), or paste the formula into the translator above. Change the commas between arguments to semicolons as well.

Why does Excel use semicolons instead of commas in my language?

Where the decimal separator is a comma, as in most of Europe and Brazil, a comma can't also separate arguments, so Excel uses a semicolon: =ROUND(A1,2) becomes =ARRONDI(A1;2) in French. The separators follow your Windows or Mac regional settings, not the language of Excel itself.

If I send a workbook to someone whose Excel is in another language, do the formulas break?

No. Excel saves formulas with the English names and shows them in each person's language when the file is opened. Only formulas you type, or copy as text, need translating.

Does Google Sheets translate function names too?

Google Sheets can show translated function names too, depending on your language settings, and it uses the separators of the spreadsheet's locale (File → Settings). Its translated names usually match Excel's, but not always.

How were these names checked?

Each name comes from the Excel Function Translator data, which was taken from Excel's own localized resources, and was checked against the syntax and examples in Microsoft's support article for that function in that language. Functions added since Excel 2019 come from Microsoft's localized articles, with a second source where we could find one. 86 of the 1143 names rest on one source and are marked †. Where we couldn't confirm a name, the table shows a dash rather than a guess.