Excel Functions in Portuguese (European)

These are the 140 most common functions in Excel with Portuguese (PT) translations. This list is very useful if you are used to the English version of Excel, and you are working with a Portuguese version that only accepts the Portuguese function names in the formulas. Or the other way around!

Tradução das fórmulas Excel Inglês – Português (Portugal)

Normally you would also have to replace all the commas in my example formulas with semi-colon.

Do you need a complete list of all the function names in Portuguese in Excel? Scroll down to the bottom of this page to read more about Microsoft’s Functions Translator add-in.

EnglishPortuguese (PT)
ABSABS
ADDRESSENDEREÇO
AGGREGATEAGREGAR
ANDE
ARABICÁRABE
AVERAGEMÉDIA
AVERAGEIFMÉDIA.SE
AVERAGEIFSMÉDIA.SE.S
BAHTTEXTTEXTO.BAHT
BIN2DECBINADEC
BIN2HEXBINAHEX
CEILINGARRED.EXCESSO
CEILING.MATHARRED.EXCESSO.MAT
CELLCÉL
CHARCARÁT
CHOOSESELECIONAR
CODECÓDIGO
COLUMNCOL
COLUMNSCOLS
CONCATCONCAT
CONCATENATECONCATENAR
CONVERTCONVERTER
COUNTCONTAR
COUNTACONTAR.VAL
COUNTBLANKCONTAR.VAZIO
COUNTIFCONTAR.SE
COUNTIFSCONTAR.SE.S
DATEDATA
DATEVALUEDATA.VALOR
DAYDIA
DAYSDIAS
DEC2BINDECABIN
DEC2HEXDECAHEX
EOMONTHFIMMÊS
EVENPAR
EXACTEXATO
FACTFATORIAL
FILTERXMLFILTRARXML
FINDLOCALIZAR
FLOORARRED.DEFEITO
FLOOR.MATHARRED.DEFEITO.MAT
FORMULATEXTFÓRMULA.TEXTO
FREQUENCYFREQUÊNCIA
HEX2BINHEXABIN
HEX2DECHEXADEC
HLOOKUPPROCH
HYPERLINKHIPERLIGAÇÃO
IFSE
IFERRORSE.ERRO
IFSSE.S
INDEXÍNDICE
INDIRECTINDIRETO
INFOINFORMAÇÃO
INTINT
ISBLANKÉ.CÉL.VAZIA
ISERRORÉ.ERRO
ISEVENÉPAR
ISLOGICALÉ.LÓGICO
ISNAÉ.NÃO.DISP
ISNONTEXTÉ.NÃO.TEXTO
ISNUMBERÉ.NÚM
ISODDÉÍMPAR
ISOWEEKNUMNUMSEMANAISO
ISTEXTÉ.TEXTO
LARGEMAIOR
LEFTESQUERDA
LENNÚM.CARAT
LOOKUPPROC
LOWERMINÚSCULAS
MATCHCORRESP
MAXMÁXIMO
MAXIFSMÁXIMO.SE.S
MEDIANMED
MIDSEG.TEXTO
MINMÍNIMO
MINIFSMÍNIMO.SE.S
MODRESTO
MODEMODA
MONTHMÊS
MROUNDMARRED
NN
NANÃO.DISP
NETWORKDAYSDIATRABALHOTOTAL
NETWORKDAYS.INTLDIATRABALHOTOTAL.INTL
NOTNÃO
NOWAGORA
ODDÍMPAR
OFFSETDESLOCAMENTO
OROU
PERCENTILEPERCENTIL
PERCENTILE.EXCPERCENTIL.EXC
PERCENTILE.INCPERCENTIL.INC
PERCENTRANKORDEM.PERCENTUAL
PERCENTRANK.EXCORDEM.PERCENTUAL.EXC
PERCENTRANK.INCORDEM.PERCENTUAL.INC
PIPI
PMTPGTO
PROPERINICIAL.MAIÚSCULA
QUARTILEQUARTIL
QUARTILE.EXCQUARTIL.EXC
QUARTILE.INCQUARTIL.INC
RANDALEATÓRIO
RANDBETWEENALEATÓRIOENTRE
RANKORDEM
RANK.AVGORDEM.MÉD
RANK.EQORDEM.EQ
REPLACESUBSTITUIR
REPTREPETIR
RIGHTDIREITA
ROMANROMANO
ROUNDARRED
ROUNDDOWNARRED.PARA.BAIXO
ROUNDUPARRED.PARA.CIMA
ROWLIN
ROWSLINS
SEARCHPROCURAR
SMALLMENOR
STDEVDESVPAD
STDEV.PDESVPAD.P
STDEV.SDESVPAD.S
SUBSTITUTESUBST
SUBTOTALSUBTOTAL
SUMSOMA
SUMIFSOMA.SE
SUMIFSSOMA.SE.S
SUMPRODUCTSOMARPRODUTO
SWITCHPARÂMETRO
TEXTTEXTO
TEXTJOINUNIRTEXTO
TODAYHOJE
TRANSPOSETRANSPOR
TRIMCOMPACTAR
UNICHARUNICARÁT
UNICODEUNICODE
UPPERMAIÚSCULAS
VLOOKUPPROCV
WEEKDAYDIA.SEMANA
WEEKNUMNÚMSEMANA
YEARANO
FALSEFALSO
TRUEVERDADEIRO

Does Excel have a translate function?

Yes, there is an add-in called the Functions Translator add-in that you can install in a few seconds:

Go to Insert > Get Add-ins to open the add-in dialog. Choose Productivity under Category, find the Functions Translator add-in and click on the Add button.

Click on picture to magnify

Now you will find the Functions Translator on the Home tab to the right.

Use it to look up a functions name in a list (Reference):

Or use the Translator feature to translate a whole formula:

Leave a Reply

Your email address will not be published. Required fields are marked *


seven − 2 =