Excel Functions in Portuguese (Brazilian)

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

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

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 (BR)
ABSABS
ADDRESSENDEREÇO
AGGREGATEAGREGAR
ANDE
ARABICARÁBICO
AVERAGEMÉDIA
AVERAGEIFMÉDIASE
AVERAGEIFSMÉDIASES
BAHTTEXTBAHTTEXT
BIN2DECBINADEC
BIN2HEXBINAHEX
CEILINGTETO
CEILING.MATHTETO.MAT
CELLCÉL
CHARCARACT
CHOOSEESCOLHER
CODECÓDIGO
COLUMNCOL
COLUMNSCOLS
CONCATCONCAT
CONCATENATECONCATENAR
CONVERTCONVERTER
COUNTCONT.NÚM
COUNTACONT.VALORES
COUNTBLANKCONTAR.VAZIO
COUNTIFCONT.SE
COUNTIFSCONT.SES
DATEDATA
DATEVALUEDATA.VALOR
DAYDIA
DAYSDIAS
DEC2BINDECABIN
DEC2HEXDECAHEX
EOMONTHFIMMÊS
EVENPAR
EXACTEXATO
FACTFATORIAL
FILTERXMLFILTROXML
FINDPROCURAR
FLOORARREDMULTB
FLOOR.MATHARREDMULTB.MAT
FORMULATEXTFÓRMULATEXTO
FREQUENCYFREQÜÊNCIA
HEX2BINHEXABIN
HEX2DECHEXADEC
HLOOKUPPROCH
HYPERLINKHIPERLINK
IFSE
IFERRORSEERRO
IFSSES
INDEXÍNDICE
INDIRECTINDIRETO
INFOINFORMAÇÃO
INTINT
ISBLANKÉCÉL.VAZIA
ISERRORÉERROS
ISEVENÉPAR
ISLOGICALÉLÓGICO
ISNAÉ.NÃO.DISP
ISNONTEXTÉ.NÃO.TEXTO
ISNUMBERÉNÚM
ISODDÉIMPAR
ISOWEEKNUMNÚMSEMANAISO
ISTEXTÉTEXTO
LARGEMAIOR
LEFTESQUERDA
LENNÚM.CARACT
LOOKUPPROC
LOWERMINÚSCULA
MATCHCORRESP
MAXMÁXIMO
MAXIFSMÁXIMOSES
MEDIANMED
MIDEXT.TEXTO
MINMÍNIMO
MINIFSMÍNIMOSES
MODMOD
MODEMODO
MONTHMÊS
MROUNDMARRED
NN
NANÃO.DISP
NETWORKDAYSDIATRABALHOTOTAL
NETWORKDAYS.INTLDIATRABALHOTOTAL.INTL
NOTNÃO
NOWAGORA
ODDÍMPAR
OFFSETDESLOC
OROU
PERCENTILEPERCENTIL
PERCENTILE.EXCPERCENTIL.EXC
PERCENTILE.INCPERCENTIL.INC
PERCENTRANKORDEM.PORCENTUAL
PERCENTRANK.EXCORDEM.PORCENTUAL.EXC
PERCENTRANK.INCORDEM.PORCENTUAL.INC
PIPI
PMTPGTO
PROPERPRI.MAIÚSCULA
QUARTILEQUARTIL
QUARTILE.EXCQUARTIL.EXC
QUARTILE.INCQUARTIL.INC
RANDALEATÓRIO
RANDBETWEENALEATÓRIOENTRE
RANKORDEM
RANK.AVGORDEM.MÉD
RANK.EQORDEM.EQ
REPLACEMUDAR
REPTREPT
RIGHTDIREITA
ROMANROMANO
ROUNDARRED
ROUNDDOWNARREDONDAR.PARA.BAIXO
ROUNDUPARREDONDAR.PARA.CIMA
ROWLIN
ROWSLINS
SEARCHLOCALIZAR
SMALLMENOR
STDEVDESVPAD
STDEV.PDESVPAD.P
STDEV.SDESVPAD.A
SUBSTITUTESUBSTITUIR
SUBTOTALSUBTOTAL
SUMSOMA
SUMIFSOMASE
SUMIFSSOMASES
SUMPRODUCTSOMARPRODUTO
SWITCHPARÂMETRO
TEXTTEXTO
TEXTJOINUNIRTEXTO
TODAYHOJE
TRANSPOSETRANSPOR
TRIMARRUMAR
UNICHARCARACTUNICODE
UNICODEUNICODE
UPPERMAIÚSCULA
VLOOKUPPROCV
WEEKDAYDIA.DA.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 *


nine − = 6