Translating Excel Formulas

0
3284
Translating Excel Formulas
Excel Spreadsheets

That Excel is one of the most used tools for calculations, charts, reports and statistics is already everyone's knowledge. And in this case, its use is comprehensive not only in Brazil, but also in other countries.

In addition, it is common for foreign companies operating in Brazil to use Office in the English version, either by standardization or even by purchasing a single license. However, when working with Excel in English, there is a need to know the functions in the same language. Thus, we separate the translation of the Excel formulas from English to Portuguese.

Function in English

Function in Portuguese

ABS ABS
ACOS ACOS
ACOSH ACOSH
NOW NOW
RAND RANDOM
RANDBETWEEN RANDOMLY
AMORDEGRC AMORDEGRC
AMORLINC AMORLINC
YEAR YEAR
AREAS AREAS
ROUND ARRED
FLOOR ARREDMULTB
ROUNDDOWN ARREDONDAR.TO.BE
ROUNDUP ROUND UP
TRIM STRAIGHTEN
ASC ASC
ASIN ASEN
ASINH ASENH
ATAN ATAN
ATAN2 ATAN2
ATANH ATANH
BAHTTEXT BAHTTEXT
DB BD
DCOUNT BOARDING
DUNE BDCONTARA
DDB BDD
DSTDEVP BDDESVPA
DSTDEV BDEST
DGET BDEXTRAIR
DMAX BDMAX
DAVERAGE BDMEDIA
DMIN BDMÍN
DPRODUCT BDMULTIPL
DSUM BDSOMA
VDB BDV
DVAR BDVAREST
DVARP BDVARP
BESSELI BESSELI
BESSELJ BESSELJ
BESSELK BESSELK
BESSELY BESSELY
BETAINV BETA.ACUM.INV
BIN2DEC BINADEC
BIN2HEX BINAHEX
BIN2OCT BINAOCT
Char CARACT
CELL Cel
CODE CODE
COLUMN COL
COLUMNS COLS
COMBIN COMBIN
COMPLEX COMPLEX
CONCATENATE CONCATENATE
COUNTIF CONT.SE
COUNTIFS CONT.SES
COUNTA CONT VALUES
COUNT CONTNUM
COUNTBLANK To say empty
CONVERT TO CONVERT
CORREL CORREL
MATCH CORRESP
COS COS
COSH COSH
COVAR COVAR
GROWTH GROWTH
CRITBINOM CRIT.BINOM
COUPPCD CUPDATAANT
COUPNCD CUPDATAPRÓX
COUPDAYS CUPDIAS
COUPDAYBS CUPDIASINLIQ
COUPDAYSNC CUPDIASPRÓX
COUPNUM CUPNUM
KURT CURT
DATE DATE
DATEVALUE DATE VALUE
EDATE DATAM
DEC2BIN DECABIN
DEC2HEX DECAHEX
DEC2OCT DECAOCT
FIXED DEF.NUM.DEC
GESTEP STEP
DELTA DELTA
DISC DESC
OFFSET OFF
AVEDEV AVERAGE DEVICE
STDEV STDEV
STDEVA STARTED
STDEVP STDEVP
STDEVPA STDEV
DEVSQ DESVQ
DAY DAY
WEEKDAY DAY OF THE WEEK
DAYS360 DIAS360
WORKDAY DIATRABALHO
NETWORKDAYS DIATRABALHOTOTAL
RIGHT RIGHT
NEGBINOMDIST DIST.BIN.NEG
HYPGEOMDIST HYPERGEOM DIST
LOGNORMDIST LOGNORMAL DIST
NORMDIST NORMDIST
NORMSDIST NORMSDIST
CHIDIST DIST.QUI
BETADIST DISTBETA
EXPONDIST DISTEXPON
FDIST DISTF
GAMMADIST DISTGAMA
SKEW DISTORTION
BINOMDIST DISTRBINOM
TDIST DISTT
SLN DPD
DURATION DURATION
AND E
ISNA It is not
ISNONTEXT IS NOT.
ISBLANK It is empty
ISERR ERROR
ISERROR SEASONS
EFFECT EFFECTIVE
ISODD EVENING
ISLOGICAL IT IS LOGICAL
ADDRESS ADDRESS
ISNUMBER It's ok
STEYX EPADYX
ISEVEN IT'S PAIR
ISPMT EPT
ISREF ÉREF
CHOOSE CHOOSE
LEFT LEFT
ISTEXT ÉTEXTO
EXACT EXACT
EXP EXP
MID EXT.TEXTO
FALSE FALSE
FACTDOUBLE FATDUPLO
FACT FACTORIAL
EOMONTH FIMMÊS
FISHER FISHER
FISHERINV FISHERINV
PHONETIC PHONETICS
YEARFRAC FRAMANAN
FREQUENCY FREQUENCY
ERF FUNERRO
ERFC FUNERROCOMPL
DEGREES DEGREES
HEX2BIN HEXABIN
HEX2DEC HEXADEC
HEX2OCT HEXAOCT
HYPERLINK HIPERLINK
TODAY TODAY
HOUR HORA
IMABS IMABS
IMAGINARY IMAGINARY
IMARGUMENT IMARG
IMCONJUGATE IMCONJ
IMCOS IMCOS
IMDIV IMDIV
IMEXP IMEXP
IMLN IMLN
IMLOG10 IMLOG10
IMLOG2 IMLOG2
ODD ODD
IMPOWER IMPOT
IMPRODUCT IMPROD
IMSQRT IMRAIZ
IMREAL IMREAL
IMSIN IMSENO
IMSUM IMSOMA
IMSUB IMSUBTR
SLOPE INCLINATION
INDEX CONTENTS
INDIRECT INDIRECT
GETPIVOTDATA INFODADOSTABELADINÂMICA
INFO INFORMATION
INT INT
CONFIDENCE INT. CONFIDENCE
INTERCEPT INTERCEPTION
NORMINV NORM INV
NORMSINV NORMSINV
CHIINV INV.QUI
FINV INVF
GAMMAINV INVGAMA
LOGINV INVLOG
TINV INVT
IPMT IPGTO
JIS JIS
ACCRINT Privacy Policy
ACCRINTM JUROSACUMV
ROW LIN
ROWS LINS
LN LN
GAMMALN LNGAMA
FIND TO LOCATE
LOG LOG
LOG10 LOG10
YIELD PROFIT
YIELDDISC LUCRODESC
ODDFYIELD LUCROPRIMINC
ODDLYIELD LUCROÚLTINC
YIELDMAT LUCROVENC
LARGE BIGGER
UPPER UPPERCASE
MROUND MARRED
MDETERM MATRIZ.DETERM
MINVERSE MATRIX.INVERSO
MMULT MATRIX.MULT
MAX MAXIMUM
MAXA MAXIMUM
GCD MDC
MDURATION MOLDING
MEDIAN MED
AVERAGE AVERAGE
GEOMEAN MEDIUM.GEOMETRIC
HARMEAN AVERAGE.HARMONIC
TRIMMEAN MIDDLE.INTERNAL
AVERAGEA AVERAGE
AVERAGEIF AVERAGE
AVERAGEIFS AVERAGE
SMALL SMALLER
MONTH MONTH
MIN MINIMUM
MINA MINIMUM
LOWER LOWER
MINUTE MINUTE
LCM MMC
MODE MODE
FASHION MODE
DOLLAR COIN
DOLLARDE MOEDADEC
DOLLARFR Currency
MIRR MTIR
REPLACE CHANGE
PRODUCT MORE
MULTINOMIAL MULTINOMIAL
N N
NOT NO
NA NO DISP
NOMINAL NOMINAL
NPER NPER
LEN ACCOUNT NUMBER
WEEKNUM NUMBER
OCT2BIN OCTABIN
OCT2DEC OCTADEC
OCT2HEX OCTAHEX
RANK ORDER
PERCENTRANK SPANISH ORDER
TBILLEQ OTN
TBILLYIELD OTNLUCRO
TBILLPRICE OTNVALOR
OR OU
STANDARDIZE STANDARDIZE
EVEN BY
PEARSON PEARSON
PERCENTILE Percentile
PERMUT PERMUT
PMT PTO
CUMPRINC PGTOCAPACUM
CUMIPMT PGTOJURACUM
PI PI
POISSON POISSON
POWER POWER
PPMT PPGTO
PRICE PRICE
PRICEDISC PRICEODESC
ODDFPRICE PRICEOPRIMINC
ODDLPRICE PRICE
PRICEMAT PRICE
FORECAST PREDICTION
PROPER PRI MASTER
PROB PROB
LOOKUP PROC
HLOOKUP PROCH
SEARCH SEARCH
VLOOKUP PROCV
LINEST LINEST
LOGEST PROJ.LOG
QUARTILE QUARTILE
QUOTIENT QUOTIENT
RADIANS RADIANS
SQRT ROOT
SQRTPI RAIZPI
RECEIVED RECEIVE
REPT REPT
ROMAN ROMANO
RSQ RQUAD
RTD RTD
SYD SDA
IF SE
IFERROR SEERRO
SECOND SECOND
SIN SEN
SINH SENH
SIGN SIGNAL
SUM SOMA
SUMSQ SOMAQUAD
SUMPRODUCT SOMARPRODUCT
SUMIF I SOMASE
SERIESSUM SOMASEQÜÊNCIA
SUMIFS SOMASES
SUMX2MY2 SOMAX2DY2
SUMX2PY2 SOMAX2SY2
SUMXMY2 SOMAXMY2
REPLACE REPLACE
SUBTOTAL SUBTOTAL
T T
TAN TAN
TANH TANH
RATE FEE
INTRATE TAXAJUROS
TEAM TIME
TREND TREND
CHITEST TEST.QUI
FTEST TESTEF
TTEST TESTET
ZTEST TESTEZ
CEILING CEILING
TEXT TEXT
TYPE TYPE
ERROR.TYPE TIPO.ERRO
IRR TIR
CLEAN Take out
TRANSPOSE TRANSPORTATION
TRUNC TRUNCATE
VALUE VALUE
TIMEVALUE VALUE.TEMPO
VAR VAR
STICK STICK
VARP VARP
VARPA VARPA
TRUE TRUE
FV VF
FVSCHEDULE VFPLANO
PV VP
NPV VPL
WEIBULL WEIBULL
XIRR XTIR
XNPV XVPL

Based on the functions translated above, it is now easier to work with Excel in both Portuguese and English. In addition, this tip can help you not only in learning Excel but also to practice English.

Excel Spreadsheets

If you have Excel in the English version, start practicing the listed functions!

Did you like the tip? Leave your comment and check it out tips on Excel on our site!

Excel Spreadsheets

LEAVE AN ANSWER

Please, write your comment
Please enter your name