Spreadsheet Practice

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.

Find a function

Translate a formula

Examples
=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.

LanguageBetween argumentsDecimalArray constantTRUE / 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.
EnglishSpanishGermanFrenchPortuguese (Brazil)ItalianDutchPolish
#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 172 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

EnglishSpanishGermanFrenchPortuguese (Brazil)ItalianDutchPolish
ADDRESSBuilds a cell address as text, like "$B$3".DIRECCIONADRESSEADRESSEENDEREÇOINDIRIZZOADRESADRES
COLUMNColumn number of a reference, or of this cell.COLUMNASPALTECOLONNECOLRIF.COLONNAKOLOMNR.KOLUMNY
COLUMNSNumber of columns in a range.COLUMNASSPALTENCOLONNESCOLSCOLONNEKOLOMMENLICZBA.KOLUMN
HLOOKUPHorizontal version of VLOOKUP.BUSCARHWVERWEISRECHERCHEHPROCHCERCA.ORIZZHORIZ.ZOEKENWYSZUKAJ.POZIOMO
INDEXValue at a given row and column of a range.INDICEINDEXINDEXÍNDICEINDICEINDEXINDEKS
INDIRECTTurns text such as "B3" or "A2:A10" into a reference.INDIRECTOINDIREKTINDIRECTINDIRETOINDIRETTOINDIRECTADR.POŚR
LOOKUPApproximate match in a sorted row or column; returns the value in the same position of another row or column.BUSCARVERWEISRECHERCHEPROCCERCAZOEKENWYSZUKAJ
MATCHPosition of a value in a list. 0 = exact match.COINCIDIRVERGLEICHEQUIVCORRESPCONFRONTAVERGELIJKENPODAJ.POZYCJĘ
OFFSETA range moved a number of rows and columns from a starting cell, and optionally resized.DESREFBEREICH.VERSCHIEBENDECALERDESLOCSCARTOVERSCHUIVINGPRZESUNIĘCIE
ROWRow number of a reference, or of this cell.FILAZEILELIGNELINRIF.RIGARIJWIERSZ
ROWSNumber of rows in a range.FILASZEILENLIGNESLINSRIGHERIJENILE.WIERSZY
VLOOKUPFinds a value in the first column and returns a value from the same row. Use FALSE for exact.BUSCARVSVERWEISRECHERCHEVPROCVCERCA.VERTVERT.ZOEKENWYSZUKAJ.PIONOWO
XLOOKUPSearches one range and returns the matching item from another.BUSCARXXVERWEISRECHERCHEXPROCXCERCA.XX.ZOEKENX.WYSZUKAJ†
XMATCHModern MATCH: exact by default.COINCIDIRXXVERGLEICH†EQUIVX†CORRESPXCONFRONTA.X†X.VERGELIJKEN†X.DOPASUJ†

Logic

EnglishSpanishGermanFrenchPortuguese (Brazil)ItalianDutchPolish
ANDTRUE if every argument is true.YUNDETEEENORAZ
CHOOSEPicks a value by its position in the list.ELEGIRWAHLCHOISIRESCOLHERSCEGLIKIEZENWYBIERZ
IFReturns one value if a test is true, another if false.SIWENNSISESEALSJEŻELI
IFERRORReturns a fallback when the value is any error.SI.ERRORWENNFEHLERSIERREURSEERROSE.ERROREALS.FOUTJEŻELI.BŁĄD
IFNAReturns a fallback only for #N/A.SI.NDWENNNVSI.NON.DISPSENÃODISPSE.NON.DISP.ALS.NBJEŻELI.ND
IFSReturns the value for the first true test.SI.CONJUNTOWENNSSI.CONDITIONSSESPIÙ.SEALS.VOORWAARDENWARUNKI
LETNames values inside a formula.LET†LET†LET†LET†LET†LET†LET†
NOTReverses TRUE and FALSE.NONICHTNONNÃONONNIETNIE
ORTRUE if any argument is true.OODEROUOUOOFLUB
SWITCHMatches an expression against a list of values.CAMBIARERSTERWERTSI.MULTIPLEPARÂMETROSWITCHSCHAKELENPRZEŁĄCZ
XORTRUE if an odd number of arguments are true.XOXODEROUXXORXOREX.OFXOR

Conditional

EnglishSpanishGermanFrenchPortuguese (Brazil)ItalianDutchPolish
AVERAGEIFAverage of values that meet a condition.PROMEDIO.SIMITTELWERTWENNMOYENNE.SIMÉDIASEMEDIA.SEGEMIDDELDE.ALSŚREDNIA.JEŻELI
AVERAGEIFSAverage of values that meet every condition.PROMEDIO.SI.CONJUNTOMITTELWERTWENNSMOYENNE.SI.ENSMÉDIASESMEDIA.PIÙ.SEGEMIDDELDEN.ALSŚREDNIA.WARUNKÓW
COUNTIFCounts cells that meet one condition.CONTAR.SIZÄHLENWENNNB.SICONT.SECONTA.SEAANTAL.ALSLICZ.JEŻELI
COUNTIFSCounts rows that meet every condition.CONTAR.SI.CONJUNTOZÄHLENWENNSNB.SI.ENSCONT.SESCONTA.PIÙ.SEAANTALLEN.ALSLICZ.WARUNKI
MAXIFSLargest value that meets every condition.MAX.SI.CONJUNTOMAXWENNSMAX.SI.ENSMÁXIMOSESMAX.PIÙ.SEMAX.ALS.VOORWAARDENMAKS.WARUNKÓW
MINIFSSmallest value that meets every condition.MIN.SI.CONJUNTOMINWENNSMIN.SI.ENSMÍNIMOSESMIN.PIÙ.SEMIN.ALS.VOORWAARDENMIN.WARUNKÓW
SUMIFAdds values where the range meets a condition.SUMAR.SISUMMEWENNSOMME.SISOMASESOMMA.SESOM.ALSSUMA.JEŻELI
SUMIFSAdds values that meet every condition.SUMAR.SI.CONJUNTOSUMMEWENNSSOMME.SI.ENSSOMASESSOMMA.PIÙ.SESOMMEN.ALSSUMA.WARUNKÓW

Math

EnglishSpanishGermanFrenchPortuguese (Brazil)ItalianDutchPolish
ABSAbsolute value.ABSABSABSABSASSABSMODUŁ.LICZBY
AGGREGATENineteen calculations that can skip errors, hidden rows and other subtotals.AGREGARAGGREGATAGREGATAGREGARAGGREGAAGGREGAATAGREGUJ
CEILINGRounds up to a multiple.MULTIPLO.SUPERIOROBERGRENZEPLAFONDTETOARROTONDA.ECCESSOAFRONDEN.BOVENZAOKR.W.GÓRĘ
CEILING.MATHRounds a number up to the nearest multiple.MULTIPLO.SUPERIOR.MATOBERGRENZE.MATHEMATIKPLAFOND.MATHTETO.MATARROTONDA.ECCESSO.MATAFRONDEN.BOVEN.WISKZAOKR.W.GÓRĘ.MATEMATYCZNE
EXPe raised to a power.EXPEXPEXPEXPEXPEXPEXP
FLOORRounds down to a multiple.MULTIPLO.INFERIORUNTERGRENZEPLANCHERARREDMULTBARROTONDA.DIFETTOAFRONDEN.BENEDENZAOKR.W.DÓŁ
FLOOR.MATHRounds a number down to the nearest multiple.MULTIPLO.INFERIOR.MATUNTERGRENZE.MATHEMATIKPLANCHER.MATHARREDMULTB.MATARROTONDA.DIFETTO.MATAFRONDEN.BENEDEN.WISKZAOKR.W.DÓŁ.MATEMATYCZNE
INTRounds down to the nearest integer.ENTEROGANZZAHLENTINTINTINTEGERZAOKR.DO.CAŁK
LNNatural logarithm.LNLNLNLNLNLNLN
LOGLogarithm, base 10 by default.LOGLOGLOGLOGLOGLOGLOG
LOG10Base-10 logarithm.LOG10LOG10LOG10LOG10LOG10LOG10LOG10
MODRemainder after division.RESIDUORESTMODMODRESTORESTMOD
MROUNDRounds to the nearest multiple.REDOND.MULTVRUNDENARRONDI.AU.MULTIPLEMARREDARROTONDA.MULTIPLOAFRONDEN.N.VEELVOUDZAOKR.DO.WIELOKR
PIThe constant π.PIPIPIPIPI.GRECOPIPI
POWERRaises a number to a power (same as ^).POTENCIAPOTENZPUISSANCEPOTÊNCIAPOTENZAMACHTPOTĘGA
PRODUCTMultiplies all the numbers.PRODUCTOPRODUKTPRODUITMULTPRODOTTOPRODUCTILOCZYN
QUOTIENTThe whole-number part of a division, with the remainder dropped.COCIENTEQUOTIENTQUOTIENTQUOCIENTEQUOZIENTEQUOTIENTCZ.CAŁK.DZIELENIA
RANDA random number between 0 and 1.ALEATORIOZUFALLSZAHLALEAALEATÓRIOCASUALEASELECTLOS
RANDBETWEENA random whole number between two values.ALEATORIO.ENTREZUFALLSBEREICHALEA.ENTRE.BORNESALEATÓRIOENTRECASUALE.TRAASELECTTUSSENLOS.ZAKR
ROUNDRounds to a number of digits; negative digits round left of the decimal.REDONDEARRUNDENARRONDIARREDARROTONDAAFRONDENZAOKR
ROUNDDOWNRounds toward zero.REDONDEAR.MENOSABRUNDENARRONDI.INFARREDONDAR.PARA.BAIXOARROTONDA.PER.DIFAFRONDEN.NAAR.BENEDENZAOKR.DÓŁ
ROUNDUPRounds away from zero.REDONDEAR.MASAUFRUNDENARRONDI.SUPARREDONDAR.PARA.CIMAARROTONDA.PER.ECCAFRONDEN.NAAR.BOVENZAOKR.GÓRA
SIGN1, 0 or -1 depending on the sign.SIGNOVORZEICHENSIGNESINALSEGNOPOS.NEGZNAK.LICZBY
SQRTSquare root.RAIZWURZELRACINERAIZRADQWORTELPIERWIASTEK
SUBTOTALSum, average, count and more that skip other SUBTOTALs; 101–111 also skip hidden rows.SUBTOTALESTEILERGEBNISSOUS.TOTALSUBTOTALSUBTOTALESUBTOTAALSUMY.CZĘŚCIOWE
SUMAdds numbers and ranges. Skips text and blanks.SUMASUMMESOMMESOMASOMMASOMSUMA
SUMPRODUCTMultiplies arrays row by row and adds the results.SUMAPRODUCTOSUMMENPRODUKTSOMMEPRODSOMARPRODUTOMATR.SOMMA.PRODOTTOSOMPRODUCTSUMA.ILOCZYNÓW
SUMSQSum of squares.SUMA.CUADRADOSQUADRATESUMMESOMME.CARRESSOMAQUADSOMMA.QKWADRATENSOMSUMA.KWADRATÓW
TRUNCCuts off decimals without rounding.TRUNCARKÜRZENTRONQUETRUNCARTRONCAGEHEELLICZBA.CAŁK

Stats

EnglishSpanishGermanFrenchPortuguese (Brazil)ItalianDutchPolish
AVERAGEArithmetic mean of the numbers.PROMEDIOMITTELWERTMOYENNEMÉDIAMEDIAGEMIDDELDEŚREDNIA
COUNTCounts cells that contain numbers.CONTARANZAHLNBCONT.NÚMCONTA.NUMERIAANTALILE.LICZB
COUNTACounts cells that are not empty.CONTARAANZAHL2NBVALCONT.VALORESCONTA.VALORIAANTALARGILE.NIEPUSTYCH
COUNTBLANKCounts empty cells.CONTAR.BLANCOANZAHLLEEREZELLENNB.VIDECONTAR.VAZIOCONTA.VUOTEAANTAL.LEGE.CELLENLICZ.PUSTE
LARGEk-th largest value.K.ESIMO.MAYORKGRÖSSTEGRANDE.VALEURMAIORGRANDEGROOTSTEMAX.K
MAXLargest number.MAXMAXMAXMÁXIMOMAXMAXMAX
MEDIANMiddle value of the numbers.MEDIANAMEDIANMEDIANEMEDMEDIANAMEDIAANMEDIANA
MINSmallest number.MINMINMINMÍNIMOMINMINMIN
MODEMost frequently occurring number.MODAMODALWERTMODEMODOMODAMODUSWYST.NAJCZĘŚCIEJ
MODE.SNGLMost frequently occurring number.MODA.UNOMODUS.EINFMODE.SIMPLEMODO.ÚNICOMODA.SNGLMODUS.ENKELVWYST.NAJCZĘŚCIEJ.WART
PERCENTILE.EXCPercentile that leaves out 0 and 1, so k must fall strictly inside the data.PERCENTIL.EXCQUANTIL.EXKLCENTILE.EXCLUREPERCENTIL.EXCESC.PERCENTILEPERCENTIEL.EXCPERCENTYL.PRZEDZ.OTW
PERCENTILE.INCThe value at percentile k (0 to 1), interpolating between values. PERCENTILE is the older name.PERCENTIL.INCQUANTIL.INKLCENTILE.INCLUREPERCENTIL.INCINC.PERCENTILEPERCENTIEL.INCPERCENTYL.PRZEDZ.ZAMK
RANKRank of a number in a list. 0 or omitted = largest is 1.JERARQUIARANGRANGORDEMRANGORANGPOZYCJA
RANK.EQRank of a number in a list. 0 or omitted = largest is 1.JERARQUIA.EQVRANG.GLEICHEQUATION.RANGORDEM.EQRANGO.UGRANG.GELIJKPOZYCJA.NAJW
SMALLk-th smallest value.K.ESIMO.MENORKKLEINSTEPETITE.VALEURMENORPICCOLOKLEINSTEMIN.K
STDEVSample standard deviation (same as STDEV.S).DESVESTSTABWECARTYPEDESVPADDEV.STSTDEVODCH.STANDARDOWE
STDEV.PPopulation standard deviation.DESVEST.PSTABW.NECARTYPE.PEARSONDESVPAD.PDEV.ST.PSTDEV.PODCH.STAND.POPUL
STDEV.SSample standard deviation (same as STDEV.S).DESVEST.MSTABW.SECARTYPE.STANDARDDESVPAD.ADEV.ST.CSTDEV.SODCH.STANDARD.PRÓBKI
VARSample variance (same as VAR.S).VARVARIANZVARVARVARVARWARIANCJA
VAR.PPopulation variance.VAR.PVAR.PVAR.P.NVAR.PVAR.PVAR.PWARIANCJA.POP
VAR.SSample variance (same as VAR.S).VAR.SVAR.SVAR.SVAR.AVAR.CVAR.SWARIANCJA.PRÓBKI

Text

EnglishSpanishGermanFrenchPortuguese (Brazil)ItalianDutchPolish
CHARCharacter for a code number.CARACTERZEICHENCARCARACTCODICE.CARATTTEKENZNAK
CLEANRemoves non-printing characters.LIMPIARSÄUBERNEPURAGETIRARLIBERAWISSEN.CONTROLOCZYŚĆ
CODECode number of the first character.CODIGOCODECODECÓDIGOCODICECODEKOD
CONCATJoins text and ranges.CONCATTEXTKETTECONCATCONCATCONCATTEKST.SAMENVZŁĄCZ.TEKST
CONCATENATEJoins text (older version of CONCAT).CONCATENARVERKETTENCONCATENERCONCATENARCONCATENATEKST.SAMENVOEGENZŁĄCZ.TEKSTY
DOLLARFormats a number as currency text.MONEDADMDEVISEMOEDAVALUTAEUROKWOTA
EXACTTRUE if two texts match exactly, including case.IGUALIDENTISCHEXACTEXATOIDENTICOGELIJKPORÓWNAJ
FINDPosition of text, case-sensitive.ENCONTRAR†FINDEN†TROUVE†PROCURAR†TROVA†VIND.ALLES†ZNAJDʆ
FIXEDRounds a number and returns it as text with a fixed number of decimals.DECIMALFESTCTXTDEF.NÚM.DECFISSOVASTZAOKR.DO.TEKST
LEFTCharacters from the start of text.IZQUIERDALINKSGAUCHEESQUERDASINISTRALINKSLEWY
LENNumber of characters.LARGOLÄNGENBCARNÚM.CARACTLUNGHEZZALENGTEDŁ
LOWERConverts to lowercase.MINUSCKLEINMINUSCULEMINÚSCULAMINUSCKLEINE.LETTERSLITERY.MAŁE
MIDCharacters from the middle of text.EXTRAETEILSTXTEXT.TEXTOSTRINGA.ESTRAIDEELFRAGMENT.TEKSTU
NUMBERVALUEConverts text to a number using the separators you name, whatever the locale.VALOR.NUMEROZAHLENWERTVALEURNOMBREVALORNUMÉRICONUMERO.VALORENUMERIEKE.WAARDEWARTOŚĆ.LICZBOWA
PROPERCapitalizes the first letter of each word.NOMPROPIOGROSS2NOMPROPREPRI.MAIÚSCULAMAIUSC.INIZBEGINLETTERSZ.WIELKIEJ.LITERY
REGEXEXTRACTText that matches a regular expression: the first match, every match, or the capture groups.———————
REGEXREPLACEReplaces text that matches a regular expression; $1 puts back a captured group.———————
REGEXTESTTRUE if the text contains a match for a regular expression.———————
REPLACEReplaces characters by position.REEMPLAZAR†ERSETZENREMPLACERMUDARRIMPIAZZAVERVANGENZASTĄP
REPTRepeats text.REPETIRWIEDERHOLENREPTREPTRIPETIHERHALINGPOWT
SUBSTITUTEReplaces matching text.SUSTITUIRWECHSELNSUBSTITUESUBSTITUIRSOSTITUISCISUBSTITUERENPODSTAW
TText unchanged, and empty text for anything else.TTTTTTT
TEXTFormats a number or date as text, e.g. "mmm" or "$#,##0".TEXTOTEXTTEXTETEXTOTESTOTEKSTTEKST
TEXTAFTERText after a delimiter.TEXTODESPUES†TEXTNACHTEXTE.APRES†TEXTODEPOISTESTO.DOPO†TEKST.NA†TEKST.PO†
TEXTBEFOREText before a delimiter.TEXTOANTES†TEXTVOR†TEXTE.AVANT†TEXTOANTESTESTO.PRIMA†TEKST.VOOR†TEKST.PRZED†
TEXTJOINJoins text with a delimiter between items.UNIRCADENASTEXTVERKETTENJOINDRE.TEXTEUNIRTEXTOTESTO.UNISCITEKST.COMBINERENPOŁĄCZ.TEKSTY
TRIMRemoves extra spaces, leaving single spaces between words.ESPACIOSGLÄTTENSUPPRESPACEARRUMARANNULLA.SPAZISPATIES.WISSENUSUŃ.ZBĘDNE.ODSTĘPY
UNICHARThe Unicode character for a number.UNICARUNIZEICHENUNICARCARACTUNICODECARATT.UNIUNITEKENZNAK.UNICODE
UNICODEThe Unicode number of the first character.UNICODEUNICODEUNICODEUNICODEUNICODEUNICODEUNICODE
UPPERConverts to uppercase.MAYUSCGROSSMAJUSCULEMAIÚSCULAMAIUSCHOOFDLETTERSLITERY.WIELKIE
VALUEConverts text that looks like a number into a number.VALORWERTCNUMVALORVALOREWAARDEWARTOŚĆ

Date

EnglishSpanishGermanFrenchPortuguese (Brazil)ItalianDutchPolish
DATEBuilds a date from parts.FECHADATUMDATEDATADATADATUMDATA
DATEDIFDifference in "Y", "M", "D", "YM", "MD" or "YD".SIFECHADATEDIFDATEDIFDATADIFDATA.DIFFDATUMVERSCHILDATA.RÓŻNICA
DATEVALUEConverts date text to a date.FECHANUMERODATWERTDATEVALDATA.VALORDATA.VALOREDATUMWAARDEDATA.WARTOŚĆ
DAYDay of the month, 1–31.DIATAGJOURDIAGIORNODAGDZIEŃ
DAYSDays between two dates.DIASTAGEJOURSDIASGIORNIDAGENDNI
EDATEDate a number of months before or after.FECHA.MESEDATUMMOIS.DECALERDATAMDATA.MESEZELFDE.DAGNR.SER.DATY
EOMONTHLast day of the month, months away.FIN.MESMONATSENDEFIN.MOISFIMMÊSFINE.MESELAATSTE.DAGNR.SER.OST.DN.MIES
HOURThe hour of a time, 0–23.HORASTUNDEHEUREHORAORAUURGODZINA
ISOWEEKNUMISO week number: weeks start on Monday and week 1 holds the year's first Thursday.ISO.NUM.DE.SEMANAISOKALENDERWOCHENO.SEMAINE.ISONÚMSEMANAISONUM.SETTIMANA.ISOISO.WEEKNUMMERISO.NUM.TYG
MINUTEThe minute of a time, 0–59.MINUTOMINUTEMINUTEMINUTOMINUTOMINUUTMINUTA
MONTHMonth of a date, 1–12.MESMONATMOISMÊSMESEMAANDMIESIĄC
NETWORKDAYSWeekdays between two dates, inclusive.DIAS.LABNETTOARBEITSTAGENB.JOURS.OUVRESDIATRABALHOTOTALGIORNI.LAVORATIVI.TOTNETTO.WERKDAGENDNI.ROBOCZE
NETWORKDAYS.INTLWorking days between two dates, with the weekend days you choose.DIAS.LAB.INTLNETTOARBEITSTAGE.INTLNB.JOURS.OUVRES.INTLDIATRABALHOTOTAL.INTLGIORNI.LAVORATIVI.TOT.INTLNETWERKDAGEN.INTLDNI.ROBOCZE.NIESTAND
NOWThe current date and time. Recalculates.AHORAJETZTMAINTENANTAGORAADESSONUTERAZ
SECONDThe second of a time, 0–59.SEGUNDOSEKUNDESECONDESEGUNDOSECONDOSECONDESEKUNDA
TIMEA time built from hours, minutes and seconds.NSHORAZEITTEMPSTEMPOORARIOTIJDCZAS
TIMEVALUEConverts time text such as "1:30 PM" into a time.HORANUMEROZEITWERTTEMPSVALVALOR.TEMPOORARIO.VALORETIJDWAARDECZAS.WARTOŚĆ
TODAYToday's date. Recalculates every day.HOYHEUTEAUJOURDHUIHOJEOGGIVANDAAGDZIŚ
WEEKDAYDay of the week as a number; Sunday = 1 by default.DIASEMWOCHENTAGJOURSEMDIA.DA.SEMANAGIORNO.SETTIMANAWEEKDAG†DZIEŃ.TYG
WEEKNUMWeek number of a date in its year. Weeks start on Sunday unless you choose another day.NUM.DE.SEMANAKALENDERWOCHENO.SEMAINENÚMSEMANANUM.SETTIMANAWEEKNUMMERNUM.TYG
WORKDAYDate a number of workdays away.DIA.LABARBEITSTAGSERIE.JOUR.OUVREDIATRABALHOGIORNO.LAVORATIVOWERKDAGDZIEŃ.ROBOCZY
WORKDAY.INTLThe date a number of working days away, with the weekend days you choose.DIA.LAB.INTLARBEITSTAG.INTLSERIE.JOUR.OUVRE.INTLDIATRABALHO.INTLGIORNO.LAVORATIVO.INTLWERKDAG.INTLDZIEŃ.ROBOCZY.NIESTAND
YEARYear of a date.AÑOJAHRANNEEANOANNOJAARROK
YEARFRACThe fraction of a year between two dates, by a day-count basis.FRAC.AÑOBRTEILJAHREFRACTION.ANNEEFRAÇÃOANOFRAZIONE.ANNOJAAR.DEELCZĘŚĆ.ROKU

Dynamic arrays

EnglishSpanishGermanFrenchPortuguese (Brazil)ItalianDutchPolish
DROPRemoves rows or columns from the start or end.EXCLUIR†WEGLASSEN†EXCLURE†—ESCLUDI†WEGLATEN†UPUŚĆ†
FILTERRows that pass a TRUE/FALSE test. Spills.FILTRAR†FILTER†FILTREFILTRO†FILTRO†FILTER†FILTRUJ†
HSTACKPlaces ranges side by side.APILARH†HSTAPELN†ASSEMB.H†EMPILHARH†STACK.ORIZ†HOR.STAPELEN†STOS.POZ†
SEQUENCEA grid of sequential numbers. Spills.SECUENCIA†SEQUENZ†SEQUENCE†SEQUÊNCIA†SEQUENZA†REEKS†SEKWENCJA†
SORTSorted copy of a range. -1 = descending. Spills.ORDENAR†SORTIEREN†TRIERCLASSIFICAR†DATI.ORDINA†SORTEREN†SORTUJ†
SORTBYSorts a range by other ranges. Spills.ORDENARPOR†SORTIERENNACH†TRIERPAR†CLASSIFICARPOR†DATI.ORDINA.PER†SORTEREN.OP†SORTUJ.WEDŁUG†
TAKEFirst (or last, if negative) rows or columns.TOMAR†ÜBERNEHMEN†———NEMEN†—
TRANSPOSEFlips rows and columns.TRANSPONERMTRANSTRANSPOSETRANSPORMATR.TRASPOSTATRANSPONERENTRANSPONUJ
UNIQUEDistinct rows of a range. Spills.UNICOSEINDEUTIG†UNIQUEÚNICOUNICI†UNIEK†UNIKATOWE†
VSTACKStacks ranges on top of each other.APILARV†VSTAPELNASSEMB.V†EMPILHARV†STACK.VERT†VERT.STAPELEN†STOS.PION†

Finance

EnglishSpanishGermanFrenchPortuguese (Brazil)ItalianDutchPolish
FVFuture value of an investment.VFZWVCVFVAL.FUTTWFV
IRRInternal rate of return.TIRIKVTRI†TIRTIR.COSTIRIRR
NPERNumber of periods to pay off or reach a target.NPERZZRNPMNPERNUM.RATENPERNPER
NPVNet present value of future cash flows (first flow one period out).VNANBWVANVPLVANNHWNPV
PMTPayment per period for a loan or annuity.PAGORMZVPMPGTORATABETPMT
PVPresent value of future payments.VABWVAVPVAHWPV
RATEInterest rate per period.TASAZINSTAUXTAXATASSORENTERATE

Info

EnglishSpanishGermanFrenchPortuguese (Brazil)ItalianDutchPolish
CELLInformation about a cell: its address, format, contents or width.CELDAZELLECELLULECÉLCELLACELKOMÓRKA
FORMULATEXTThe formula in a cell, as text.FORMULATEXTOFORMELTEXTFORMULETEXTEFÓRMULATEXTOTESTO.FORMULAFORMULETEKSTFORMUŁA.TEKST
ISBLANKTRUE if the cell is empty.ESBLANCOISTLEERESTVIDEÉCÉL.VAZIAVAL.VUOTOISLEEGCZY.PUSTA
ISERRTRUE for any error except #N/A.ESERRISTFEHLESTERRÉERROVAL.ERRISFOUT2CZY.BŁ
ISERRORTRUE for any error.ESERRORISTFEHLERESTERREURÉERROSVAL.ERROREISFOUTCZY.BŁĄD
ISEVENTRUE if the number is even.ES.PARISTGERADEEST.PAIRÉPARVAL.PARIIS.EVENCZY.PARZYSTE
ISFORMULATRUE if the cell contains a formula.ESFORMULAISTFORMELESTFORMULEÉFÓRMULAVAL.FORMULAISFORMULECZY.FORMUŁA
ISLOGICALTRUE if the value is TRUE or FALSE.ESLOGICOISTLOGESTLOGIQUEÉLÓGICOVAL.LOGICOISLOGISCHCZY.LOGICZNA
ISNATRUE for #N/A.ESNODISTNVESTNAÉ.NÃO.DISPVAL.NON.DISPISNBCZY.BRAK
ISNUMBERTRUE if the value is a number.ESNUMEROISTZAHLESTNUMÉNÚMVAL.NUMEROISGETALCZY.LICZBA
ISODDTRUE if the number is odd.ES.IMPARISTUNGERADEEST.IMPAIRÉIMPARVAL.DISPARIIS.ONEVENCZY.NIEPARZYSTE
ISTEXTTRUE if the value is text.ESTEXTOISTTEXTESTTEXTEÉTEXTOVAL.TESTOISTEKSTCZY.TEKST
NA value as a number: text becomes 0 and TRUE becomes 1.NNNNNUMNN
NAReturns #N/A on purpose.NODNVNANÃO.DISPNON.DISPNBBRAK
TYPEThe kind of value as a number: 1 number, 2 text, 4 logical, 16 error, 64 array.TIPOTYPTYPETIPOTIPOTYPETYP

How the names were checked

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 1178 names rest on one source and are marked †. Where we couldn't confirm a name, the table shows a dash rather than a guess.