Excel formula translator
Excel shows function names in its own language: VLOOKUP is SVERWEIS in German, PROCV in Portuguese and BUSCARV in Spanish. Paste a formula from a tutorial or a colleague and get it in your language, or in English.
An example
English: =IF(VLOOKUP(A2, Prices!A:C, 3, FALSE)>=1.5, "High", "Low")
- German:
=WENN(SVERWEIS(A2; Prices!A:C; 3; FALSCH)>=1,5; "High"; "Low") - Spanish:
=SI(BUSCARV(A2; Prices!A:C; 3; FALSO)>=1,5; "High"; "Low") - French:
=SI(RECHERCHEV(A2; Prices!A:C; 3; FAUX)>=1,5; "High"; "Low") - Portuguese (Brazil):
=SE(PROCV(A2; Prices!A:C; 3; FALSO)>=1,5; "High"; "Low") - Italian:
=SE(CERCA.VERT(A2; Prices!A:C; 3; FALSO)>=1,5; "High"; "Low") - Russian:
=ЕСЛИ(ВПР(A2; Prices!A:C; 3; ЛОЖЬ)>=1,5; "High"; "Low")
How it works
A workbook is not tied to a language. Excel stores every formula the same way and shows it in the language of whoever opens the file, so a file made in German Excel works in English Excel without changes. The names only get in the way when a formula travels as text: in a tutorial, a forum answer, an email or a chat.
The translator changes four things: function names, the separator between arguments, the decimal point, and TRUE, FALSE and error values such as #N/A. Text in quotes, cell references and sheet names stay exactly as you wrote them. Every name was checked against two sources before it was added; where a name could not be confirmed, the translator leaves the English one and tells you.
Function names by language
- Czech (Čeština): SVYHLEDAT, KDYŽ, SUMIF
- Danish (Dansk): LOPSLAG, HVIS, SUM.HVIS
- Dutch (Nederlands): VERT.ZOEKEN, ALS, SOM.ALS
- Finnish (Suomi): PHAKU, JOS, SUMMA.JOS
- French (Français): RECHERCHEV, SI, SOMME.SI
- German (Deutsch): SVERWEIS, WENN, SUMMEWENN
- Hungarian (Magyar): FKERES, HA, SZUMHA
- Italian (Italiano): CERCA.VERT, SE, SOMMA.SE
- Norwegian (Norsk): FINN.RAD, HVIS, SUMMERHVIS
- Polish (Polski): WYSZUKAJ.PIONOWO, JEŻELI, SUMA.JEŻELI
- Portuguese (Brazil) (Português (Brasil)): PROCV, SE, SOMASE
- Portuguese (Portugal) (Português (Portugal)): PROCV, SE, SOMA.SE
- Russian (Русский): ВПР, ЕСЛИ, СУММЕСЛИ
- Spanish (Español): BUSCARV, SI, SUMAR.SI
- Swedish (Svenska): LETARAD, OM, SUMMA.OM
- Turkish (Türkçe): DÜŞEYARA, EĞER, ETOPLA
The most used functions in every language
| English | Czech | Danish | Dutch | Finnish | French | German | Hungarian | Italian | Norwegian | Polish | Portuguese (Brazil) | Portuguese (Portugal) | Russian | Spanish | Swedish | Turkish |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| VLOOKUP | SVYHLEDAT | LOPSLAG | VERT.ZOEKEN | PHAKU | RECHERCHEV | SVERWEIS | FKERES | CERCA.VERT | FINN.RAD | WYSZUKAJ.PIONOWO | PROCV | PROCV | ВПР | BUSCARV | LETARAD | DÜŞEYARA |
| XLOOKUP | XOPSLAG | X.ZOEKEN | XHAKU | RECHERCHEX | XVERWEIS | XKERES | CERCA.X | XOPPSLAG | X.WYSZUKAJ | PROCX | ПРОСМОТРX | BUSCARX | XLETAUPP | ÇAPRAZARA | ||
| IF | KDYŽ | HVIS | ALS | JOS | SI | WENN | HA | SE | HVIS | JEŻELI | SE | SE | ЕСЛИ | SI | OM | EĞER |
| SUMIFS | SUMIFS | SUM.HVISER | SOMMEN.ALS | SUMMA.JOS.JOUKKO | SOMME.SI.ENS | SUMMEWENNS | SZUMHATÖBB | SOMMA.PIÙ.SE | SUMMER.HVIS.SETT | SUMA.WARUNKÓW | SOMASES | SOMA.SE.S | СУММЕСЛИМН | SUMAR.SI.CONJUNTO | SUMMA.OMF | ÇOKETOPLA |
| COUNTIF | COUNTIF | TÆL.HVIS | AANTAL.ALS | LASKE.JOS | NB.SI | ZÄHLENWENN | DARABTELI | CONTA.SE | ANTALL.HVIS | LICZ.JEŻELI | CONT.SE | CONTAR.SE | СЧЁТЕСЛИ | CONTAR.SI | ANTAL.OM | EĞERSAY |
| COUNT | POČET | TÆL | AANTAL | LASKE | NB | ANZAHL | DARAB | CONTA.NUMERI | ANTALL | ILE.LICZB | CONT.NÚM | CONTAR | СЧЁТ | CONTAR | ANTAL | BAĞ_DEĞ_SAY |
| INDEX | INDEX | INDEKS | INDEX | INDEKSI | INDEX | INDEX | INDEX | INDICE | INDEKS | INDEKS | ÍNDICE | ÍNDICE | ИНДЕКС | INDICE | INDEX | İNDİS |
| MATCH | POZVYHLEDAT | SAMMENLIGN | VERGELIJKEN | VASTINE | EQUIV | VERGLEICH | HOL.VAN | CONFRONTA | SAMMENLIGNE | PODAJ.POZYCJĘ | CORRESP | CORRESP | ПОИСКПОЗ | COINCIDIR | PASSA | KAÇINCI |
| FILTER | FILTRER | FILTER | SUODATA | FILTRE | SZŰRŐ | FILTRO | FILTRAR | ФИЛЬТР | FILTRAR | FİLTRE | ||||||
| IFERROR | IFERROR | HVIS.FEJL | ALS.FOUT | JOSVIRHE | SIERREUR | WENNFEHLER | HAHIBA | SE.ERRORE | HVISFEIL | JEŻELI.BŁĄD | SEERRO | SE.ERRO | ЕСЛИОШИБКА | SI.ERROR | OMFEL | EĞERHATA |
| TEXTJOIN | TEXTJOIN | TEKST.KOMBINER | TEKST.COMBINEREN | TEKSTI.YHDISTÄ | JOINDRE.TEXTE | TEXTVERKETTEN | SZÖVEGÖSSZEFŰZÉS | TESTO.UNISCI | TEKST.KOMBINER | POŁĄCZ.TEKSTY | UNIRTEXTO | UNIRTEXTO | ОБЪЕДИНИТЬ | UNIRCADENAS | TEXTJOIN | METİNBİRLEŞTİR |
| ROUND | ZAOKROUHLIT | AFRUND | AFRONDEN | PYÖRISTÄ | ARRONDI | RUNDEN | KEREKÍTÉS | ARROTONDA | AVRUND | ZAOKR | ARRED | ARRED | ОКРУГЛ | REDONDEAR | AVRUNDA | YUVARLA |
| SEQUENCE | SEQUENCE | SEKVENS | REEKS | SEQUENCE | SEQUENZ | SEQUENZA | SEKVENS | SEKWENCJA | SEQUÊNCIA | SEQUÊNCIA | ПОСЛЕДОВ | SECUENCIA | SEKVENS | |||
| RANK | RANK | PLADS | RANG | ARVON.MUKAAN | RANG | RANG | SORSZÁM | RANGO | RANG | POZYCJA | ORDEM | ORDEM | РАНГ | JERARQUIA | RANG | RANK |
| WEEKNUM | WEEKNUM | UGE.NR | WEEKNUMMER | VIIKKO.NRO | NO.SEMAINE | KALENDERWOCHE | HÉT.SZÁMA | NUM.SETTIMANA | UKENR | NUM.TYG | NÚMSEMANA | NÚMSEMANA | НОМНЕДЕЛИ | NUM.DE.SEMANA | VECKONR | HAFTASAY |
| EDATE | EDATE | EDATO | ZELFDE.DAG | PÄIVÄ.KUUKAUSI | MOIS.DECALER | EDATUM | KALK.DÁTUM | DATA.MESE | DAG.ETTER | NR.SER.DATY | DATAM | DATAM | ДАТАМЕС | FECHA.MES | EDATUM | SERİTARİH |