Formula translator / Portuguese (Portugal)

Excel functions in Portuguese (Portugal) and English

Funções do Excel em português e inglês

Excel in Portuguese (Portugal) has its own name for most functions: VLOOKUP is PROCV and IF is SE. Paste a formula to translate it either way, or look a function up in the list below.

An example

English: =IF(VLOOKUP(A2, Prices!A:C, 3, FALSE)>=1.5, "High", "Low")

Portuguese (Portugal): =SE(PROCV(A2; Prices!A:C; 3; FALSO)>=1,5; "High"; "Low")

In Portuguese (Portugal), Excel usually separates arguments with a semicolon and writes decimals with a comma (1,5). Excel takes both from your computer's region settings.

All 459 functions in Portuguese (Portugal) and English

TRUE is VERDADEIRO and FALSE is FALSO.

EnglishPortuguese (Portugal)What it does
ABSABSThe absolute value: the number without its sign.
ACCRINTJUROSACUM
ACCRINTMJUROSACUMV
ACOSACOSThe angle, in radians, whose cosine is the number.
ACOSHACOSHThe inverse hyperbolic cosine of a number.
ACOTACOTThe angle, in radians, whose cotangent is the number. The result is between 0 and π.
ACOTHACOTH
ADDRESSENDEREÇOBuilds a cell address as text from a row number and a column number.
AGGREGATEAGREGARLike SUBTOTAL with more calculations, and it can ignore errors in the range.
AMORDEGRCAMORDEGRC
AMORLINCAMORLINC
ANDETRUE only if every condition is TRUE.
ARABICÁRABETurns Roman numerals into a number.
AREASÁREAS
ASINASENThe angle, in radians, whose sine is the number. Wrap it in DEGREES() for degrees.
ASINHASENHThe inverse hyperbolic sine of a number.
ATANATANThe angle, in radians, whose tangent is the number.
ATAN2ATAN2The angle, in radians, from the x-axis to the point (x, y). Unlike ATAN it knows which quarter of the circle the point is in.
ATANHATANHThe inverse hyperbolic tangent of a number.
AVEDEVDESV.MÉDIOThe average distance of the values from their mean: a plain measure of how spread out they are.
AVERAGEMÉDIAThe arithmetic mean of the numbers.
AVERAGEAMÉDIAAThe average, counting text in a range as 0 and TRUE as 1.
AVERAGEIFMÉDIA.SEAverages the cells that meet a condition.
AVERAGEIFSMÉDIA.SE.SAverages the cells that meet every one of several conditions.
BASEBASEWrites a number in another base, such as binary (2) or hexadecimal (16), as text.
BESSELIBESSELI
BESSELJBESSELJ
BESSELKBESSELK
BESSELYBESSELY
BETA.DISTDIST.BETAThe beta distribution, for shares and percentages that vary between two bounds.
BETADISTDISTBETAThe chance of x or less in a beta distribution. The older form of BETA.DIST.
BETAINVBETA.ACUM.INV
BIN2DECBINADECTurns a binary number into an ordinary one.
BIN2HEXBINAHEX
BIN2OCTBINAOCT
BINOM.DISTDISTR.BINOMThe chance of a number of successes in a set number of tries, each with the same chance.
BINOM.DIST.RANGEDIST.BINOM.INTERVALOThe chance that the number of successes in a set of tries lands between two counts.
BINOM.INVINV.BINOMThe smallest number of successes whose cumulative binomial chance reaches a target: how many to plan for.
BINOMDISTDISTRBINOM
BITANDBIT.ECompares two whole numbers bit by bit and keeps the bits that are set in both.
BITLSHIFTBITDESL.ESQMoves the bits of a whole number to the left, which doubles it for every bit moved.
BITORBIT.OUCompares two whole numbers bit by bit and keeps the bits that are set in either.
BITRSHIFTBITDESL.DIRMoves the bits of a whole number to the right, which halves it for every bit moved and drops the remainder.
BITXORBIT.XOUCompares two whole numbers bit by bit and keeps the bits that are set in one but not the other.
CEILINGARRED.EXCESSORounds a number up to the nearest multiple (away from zero when both are negative).
CEILING.MATHARRED.EXCESSO.MATRounds a number up to the nearest multiple; mode rounds negative numbers away from zero.
CEILING.PRECISEARRED.EXCESSO.PRECISO
CELLCÉLTells you something about a cell: its address, row, column, contents, number format or the type of value in it.
CHARCARÁTThe character for a character code.
CHIDISTDIST.CHI
CHIINVINV.CHI
CHISQ.DISTDIST.CHIQThe chi-square distribution: the chance of a value of x or less, or the height of the curve at x.
CHISQ.DIST.RTDIST.CHIQ.DIRThe right tail of the chi-square distribution: the chance of a value greater than x. This is the p-value of a chi-square statistic.
CHISQ.INVINV.CHIQThe value below which a given share of the chi-square distribution falls.
CHISQ.INV.RTINV.CHIQ.DIRThe chi-square value with a given share of the distribution above it: the critical value of a chi-square test.
CHISQ.TESTTESTE.CHIQThe chi-square test of independence: the chance of counts this far from the expected ones if nothing but chance were at work.
CHITESTTESTE.CHI
CHOOSESELECIONARPicks a value from a list by its position.
CHOOSECOLSESCOLHERCOLSReturns the columns you name from an array, in the order you name them.
CLEANLIMPARBRemoves non-printable characters.
CODECÓDIGOThe character code of the first character.
COLUMNCOLThe column number of a reference (A = 1).
COLUMNSCOLSHow many columns a range has.
COMBINCOMBINHow many ways to choose a number of items from a group, when the order does not matter.
COMBINACOMBIN.RThe number of ways to choose items when the same item may be chosen more than once and the order does not matter.
COMPLEXCOMPLEXO
CONCATCONCATJoins text from several values or ranges.
CONCATENATECONCATENARJoins several text values (older version of CONCAT).
CONFIDENCEINT.CONFIANÇA
CONFIDENCE.NORMINT.CONFIANÇA.NORMThe margin of error for an average: add and subtract it to get the confidence interval.
CONFIDENCE.TINT.CONFIANÇA.TThe margin of error of a sample mean, using Student's t-distribution. Add it to and subtract it from the mean for the confidence interval.
CONVERTCONVERTERConverts a number from one unit of measurement to another: miles to kilometres, pounds to kilograms, Fahrenheit to Celsius.
CORRELCORRELThe correlation coefficient of two data sets: from −1 (opposite) through 0 (unrelated) to 1 (move together).
COSCOSThe cosine of an angle given in radians.
COSHCOSHThe hyperbolic cosine of a number.
COTCOTThe cotangent of an angle: 1 divided by its tangent.
COTHCOTH
COUNTCONTARCounts cells that contain numbers.
COUNTACONTAR.VALCounts cells that are not empty.
COUNTBLANKCONTAR.VAZIOCounts empty cells in a range.
COUNTIFCONTAR.SECounts the cells that meet a condition.
COUNTIFSCONTAR.SE.SCounts the rows that meet every one of several conditions.
COUPDAYBSCUPDIASINLIQ
COUPDAYSCUPDIAS
COUPDAYSNCCUPDIASPRÓX
COUPNCDCUPDATAPRÓX
COUPNUMCUPNÚM
COUPPCDCUPDATAANT
COVARCOVAR
COVARIANCE.PCOVARIÂNCIA.PPopulation covariance: the average product of the deviations of each pair from their means.
COVARIANCE.SCOVARIÂNCIA.SSample covariance: like COVARIANCE.P, but divides by n − 1 for a sample.
CRITBINOMCRIT.BINOM
CSCCSCThe cosecant of an angle: 1 divided by its sine.
CSCHCSCH
CUBEKPIMEMBERMEMBROKPICUBO
CUBEMEMBERMEMBROCUBO
CUBEMEMBERPROPERTYPROPRIEDADEMEMBROCUBO
CUBERANKEDMEMBERMEMBROCLASSIFICADOCUBO
CUBESETCONJUNTOCUBO
CUBESETCOUNTCONTARCONJUNTOCUBO
CUBEVALUEVALORCUBO
CUMIPMTPGTOJURACUMTotal interest paid between two payment numbers.
CUMPRINCPGTOCAPACUMTotal paid off the loan itself (not interest) between two payment numbers.
DATEDATABuilds a date from a year, month and day.
DATEDIFDATADIFThe difference between two dates in years, months or days.
DATEVALUEDATA.VALORConverts a date written as text into a date serial number.
DAVERAGEBDMÉDIAThe average of a column of a table for the rows that meet conditions written in cells.
DAYDIAThe day of the month (1-31).
DAYSDIASThe number of days between two dates.
DAYS360DIAS360Days between two dates in a year of twelve 30-day months, as some accounts count them.
DBBDDepreciation for one period, losing the same percentage of the remaining value each period.
DCOUNTBDCONTARCounts the numbers in a column of a table for the rows that meet conditions written in cells.
DCOUNTABDCONTAR.VALCounts the cells that are not empty in a column of a table for the rows that meet conditions written in cells.
DDBBDDDepreciation for one period at double the straight-line rate (or another multiple).
DEC2BINDECABINWrites a whole number in binary.
DEC2HEXDECAHEXWrites a whole number in hexadecimal.
DEC2OCTDECAOCT
DECIMALDECIMALTurns a number written in another base, as text, into an ordinary number.
DEGREESGRAUSTurns radians into degrees.
DELTADELTATests whether two numbers are equal: 1 when they are, 0 when they are not.
DEVSQDESVQThe sum of the squared distances of the values from their mean.
DGETBDOBTERThe one value in a column of a table from the single row that meets the conditions. Two matching rows are an error, which makes it a strict lookup.
DISCDESC
DMAXBDMÁXThe largest number in a column of a table among the rows that meet conditions written in cells.
DMINBDMÍNThe smallest number in a column of a table among the rows that meet conditions written in cells.
DOLLARMOEDAA number as text in currency style: $1,234.57, with negatives in brackets.
DOLLARDEMOEDADECTurns a price written with a fraction, as bond prices are (1.02 meaning 1 and 2/16), into an ordinary decimal.
DOLLARFRMOEDAFRATurns a decimal price into one written with a fraction, as bond prices are: 1.125 in sixteenths is 1.02.
DPRODUCTBDMULTIPLMultiplies the numbers in a column of a table for the rows that meet conditions written in cells.
DSTDEVBDDESVPADThe standard deviation of a column of a table for the matching rows, treating them as a sample.
DSTDEVPBDDESVPADPThe standard deviation of a column of a table for the matching rows, treating them as the whole population.
DSUMBDSOMAAdds up a column of a table for the rows that meet conditions written in cells.
DURATIONDURAÇÃO
DVARBDVARThe variance of a column of a table for the matching rows, treating them as a sample.
DVARPBDVARPThe variance of a column of a table for the matching rows, treating them as the whole population.
EDATEDATAMThe same day a number of months before or after a date.
EFFECTEFETIVAThe yearly rate you really pay or earn, once interest is added several times a year.
ENCODEURLCODIFICAÇÃOURLText made safe to put in a web address: spaces become %20, and so on.
EOMONTHFIMMÊSThe last day of the month, a number of months away.
ERFFUNCERROThe error function between two limits. With one limit it runs from 0.
ERF.PRECISEFUNCERRO.PRECISOThe error function from 0 to x.
ERFCFUNCERROCOMPLThe complementary error function: 1 - ERF(x).
ERROR.TYPETIPO.ERROA number for the kind of error: 2 #DIV/0!, 3 #VALUE!, 4 #REF!, 5 #NAME?, 6 #NUM!, 7 #N/A.
EVENPARRounds away from zero to the next even integer.
EXACTEXATOTRUE if two text values are exactly the same, including case.
EXPEXPe raised to a power.
EXPON.DISTDIST.EXPONThe exponential distribution, for the time between events that happen at a steady rate: the chance of waiting x or less.
EXPONDISTDISTEXPON
F.DISTDIST.FThe F-distribution: the chance of a ratio of two variances of x or less, or the height of the curve at x.
F.DIST.RTDIST.F.DIRThe right tail of the F-distribution: the chance of a ratio greater than x. This is the p-value of an F statistic.
F.INVINV.FThe value below which a given share of the F-distribution falls.
F.INV.RTINV.F.DIRThe F value with a given share of the distribution above it: the critical value of an F-test.
F.TESTTESTE.FThe F-test: the chance that two samples would have variances this different if their populations varied equally. Two-tailed.
FACTFATORIALFactorial: 1 × 2 × … × n.
FDISTDISTF
FILTERFILTRARKeeps only the rows that meet a condition. The result spills.
FILTERXMLFILTRARXML
FINVINVF
FISHERFISHERThe Fisher transformation of a correlation, which makes it close to normally distributed so that it can be tested.
FISHERINVFISHERINVTurns a Fisher-transformed value back into a correlation.
FIXEDFIXAA number as text, rounded to a set number of decimals, with or without commas.
FLOORARRED.DEFEITORounds a number down to the nearest multiple (toward zero when both are negative).
FLOOR.MATHARRED.DEFEITO.MATRounds a number down to the nearest multiple; mode rounds negative numbers toward zero.
FLOOR.PRECISEARRED.DEFEITO.PRECISO
FORECASTPREVISÃOPredicts a y value for a new x from the best-fit straight line through known data.
FORMULATEXTFÓRMULA.TEXTOShows the formula in a cell as text.
FREQUENCYFREQUÊNCIACounts how many values fall into each bin, for a histogram. Spills one more count than there are bins: the last counts values above the top bin.
FTESTTESTEF
FVVFThe future value of an investment with regular payments.
FVSCHEDULEVFPLANOWhat an amount grows to when the interest rate changes from period to period.
GAMMAGAMAThe gamma function, which stretches the factorial to numbers that are not whole: GAMMA(n) is (n-1)!
GAMMA.DISTDIST.GAMAThe gamma distribution, for values that cannot be negative and lean to the right, such as waiting times.
GAMMA.INVINV.GAMAThe value below which a given share of a gamma distribution falls.
GAMMADISTDISTGAMA
GAMMAINVINVGAMA
GAMMALNLNGAMAThe natural logarithm of the gamma function. It stays small where GAMMA itself would overflow.
GAUSSGAUSSThe chance that a standard normal value falls between the mean and z standard deviations above it.
GCDMDCGreatest common divisor.
GEOMEANMÉDIA.GEOMÉTRICAThe geometric mean: the right average for growth rates.
GESTEPDEGRAUTests whether a number reaches a threshold: 1 when it is greater than or equal to the step, 0 when it is not.
GETPIVOTDATAOBTERDADOSDINReads one value out of a PivotTable by naming it, so that the formula still finds it when the PivotTable grows or is sorted.
GROWTHCRESCIMENTOValues on the best-fit exponential curve: predictions for something that grows by a steady percentage rather than a steady amount. Spills.
HARMEANMÉDIA.HARMÓNICAThe harmonic mean: the right average for rates such as speeds.
HEX2BINHEXABIN
HEX2DECHEXADECTurns a hexadecimal number into an ordinary one.
HEX2OCTHEXAOCT
HLOOKUPPROCHFinds a value in the first row of a table and returns a value from the same column.
HOURHORAThe hour of a time (0-23).
HSTACKJUNTARHPlaces arrays side by side into one wider array.
HYPERLINKHIPERLIGAÇÃOMakes a cell a link: to a web page, an email address, or another cell ("#Sheet2!A1"). Select the cell and click its link button, or Ctrl+click it, to follow the link.
HYPGEOM.DISTDIST.HIPGEOMThe hypergeometric distribution: the chance of a number of successes in a sample drawn without putting anything back.
HYPGEOMDISTDIST.HIPERGEOMThe chance of exactly a number of successes in a sample drawn without putting anything back. The older form of HYPGEOM.DIST.
IFSEReturns one value if a condition is TRUE and another if it is FALSE.
IFERRORSE.ERROReturns a fallback value if a formula results in an error.
IFNASENDReturns a fallback value only for #N/A errors.
IFSSE.SChecks conditions in order and returns the value for the first TRUE one.
IMABSIMABS
IMAGINARYIMAGINÁRIO
IMARGUMENTIMARG
IMCONJUGATEIMCONJ
IMCOSIMCOS
IMCOSHIMCOSH
IMCOTIMCOT
IMCSCIMCSC
IMCSCHIMCSCH
IMDIVIMDIV
IMEXPIMEXP
IMLNIMLN
IMLOG10IMLOG10
IMLOG2IMLOG2
IMPOWERIMPOT
IMPRODUCTIMPROD
IMREALIMREAL
IMSECIMSEC
IMSECHIMSECH
IMSINIMSENO
IMSINHIMSENOH
IMSQRTIMRAIZ
IMSUBIMSUBTR
IMSUMIMSOMA
IMTANIMTAN
INDEXÍNDICEThe value at a given row and column of a range.
INDIRECTINDIRETOTurns text such as "B2" into a real reference to that cell or range.
INTINTRounds down to the nearest whole number.
INTERCEPTINTERCETARWhere the best-fit straight line crosses the y axis: the predicted y when x is 0.
INTRATETAXAJUROS
IPMTIPGTOThe interest part of one loan payment.
IRRTIRInternal rate of return for a series of cash flows.
ISBLANKÉ.CÉL.VAZIATRUE if the cell is empty.
ISERRÉ.ERROSTRUE if the value is any error except #N/A.
ISERRORÉ.ERROTRUE if the value is any error.
ISEVENÉPARTRUE if the number is even.
ISFORMULAÉ.FORMULATRUE if the cell holds a formula.
ISLOGICALÉ.LÓGICOTRUE if the value is TRUE or FALSE.
ISNAÉ.NÃO.DISPTRUE if the value is the #N/A error.
ISNONTEXTÉ.NÃO.TEXTOTRUE if the value is not text.
ISNUMBERÉ.NÚMTRUE if the value is a number (dates count too).
ISODDÉÍMPARTRUE if the number is odd.
ISOWEEKNUMNUMSEMANAISOThe ISO 8601 week number: weeks start on Monday, and week 1 contains the first Thursday of the year.
ISPMTÉ.PGTOThe interest paid in a period of a loan that is repaid in equal amounts of principal, so the interest falls every period.
ISREFÉ.REFTRUE if the value is a reference to a cell or range.
ISTEXTÉ.TEXTOTRUE if the value is text.
KURTCURTKurtosis: how heavy the tails are compared with a normal distribution (0). Positive means more extreme values.
LARGEMAIORThe k-th largest value (k = 1 is the maximum).
LCMMMCLeast common multiple.
LEFTESQUERDAThe first characters of a text value.
LENNÚM.CARATThe number of characters in a text value.
LINESTPROJ.LINFits a straight line by least squares and returns its slope(s) and intercept, with the full regression statistics (standard errors, R², F, sums of squares) if you ask. Spills.
LNLNNatural logarithm.
LOGLOGLogarithm to a base (default 10).
LOG10LOG10Base-10 logarithm.
LOGESTPROJ.LOGFits an exponential curve, y = b × m^x, and returns the growth factor m and the starting value b, with the regression statistics if you ask. Spills.
LOGINVINVLOG
LOGNORM.DISTDIST.NORMLOGThe lognormal distribution, for values whose logarithm is normally distributed, such as prices and incomes.
LOGNORM.INVINV.NORMALLOGThe value below which a given share of a lognormal distribution falls.
LOGNORMDISTDIST.NORMALLOGThe chance of x or less in a lognormal distribution. The older form of LOGNORM.DIST.
LOOKUPPROCFinds a value in a sorted row or column and returns the value in the same place in another. XLOOKUP is the modern choice.
LOWERMINÚSCULASConverts text to lowercase.
MATCHCORRESPThe position of a value in a row or column.
MAXMÁXIMOThe largest number.
MAXAMÁXIMOAThe largest value, counting text in a range as 0 and TRUE as 1.
MAXIFSMÁXIMO.SE.SThe largest value among cells that meet conditions.
MDETERMMATRIZ.DETERMThe determinant of a square matrix.
MDURATIONMDURAÇÃO
MEDIANMEDThe middle number of a sorted list.
MIDSEG.TEXTOCharacters from the middle of a text value.
MINMÍNIMOThe smallest number.
MINAMÍNIMOAThe smallest value, counting text in a range as 0 and TRUE as 1.
MINIFSMÍNIMO.SE.SThe smallest value among cells that meet conditions.
MINUTEMINUTOThe minute of a time (0-59).
MINVERSEMATRIZ.INVERSAThe inverse of a square matrix.
MIRRMTIRRate of return when money borrowed and money reinvested earn different rates.
MMULTMATRIZ.MULTMultiplies two matrices.
MODRESTOThe remainder after division.
MODEMODAThe most frequently occurring number.
MODE.MULTMODO.MÚLTEvery value that is tied for most common, as a list.
MODE.SNGLMODO.SIMPLES
MONTHMÊSThe month of a date (1-12).
MROUNDMARREDRounds to the nearest multiple of a number.
MULTINOMIALPOLINOMIALThe number of ways to split a group into smaller groups of the given sizes: the factorial of the total, divided by the factorial of each size.
MUNITUNIDMThe unit matrix of a given size: 1 down the diagonal and 0 everywhere else.
NNConverts a value to a number (text becomes 0).
NANÃO.DISPReturns the #N/A error on purpose.
NEGBINOM.DISTDIST.BINOM.NEGThe negative binomial distribution: the chance of a number of failures before a given number of successes.
NEGBINOMDISTDIST.BIN.NEGThe chance of exactly a number of failures before a given number of successes. The older form of NEGBINOM.DIST.
NETWORKDAYSDIATRABALHOTOTALWorking days (Monday–Friday) between two dates, inclusive.
NETWORKDAYS.INTLDIATRABALHOTOTAL.INTLWorking days between two dates, inclusive, with the weekend on days you choose.
NOMINALNOMINALThe quoted yearly rate behind an effective rate. The reverse of EFFECT.
NORM.DISTDIST.NORMALThe normal distribution: the chance of a value at or below x, or the height of the bell curve at x.
NORM.INVINV.NORMALThe value below which a given share of a normal distribution falls.
NORM.S.DISTDIST.S.NORMThe standard normal distribution (mean 0, standard deviation 1) at a z-score.
NORM.S.INVINV.S.NORMThe z-score below which a given share of the standard normal distribution falls.
NORMDISTDIST.NORM
NORMINVINV.NORM
NORMSDISTDIST.NORMPThe chance of a z-score or less in the standard normal distribution. The older form of NORM.S.DIST.
NORMSINVINV.NORMP
NOTNÃOFlips TRUE to FALSE and FALSE to TRUE.
NOWAGORAThe current date and time.
NPERNPERHow many payment periods are needed to pay off a loan.
NPVVALNet present value of future cash flows at a discount rate.
NUMBERVALUEVALOR.NÚMEROTurns text into a number, whatever decimal and thousands marks it uses.
OCT2DECOCTADEC
OCT2HEXOCTAHEX
ODDÍMPARRounds away from zero to the next odd integer.
ODDFPRICEPREÇOPRIMINC
ODDFYIELDLUCROPRIMINC
ODDLPRICEPREÇOÚLTINC
ODDLYIELDLUCROÚLTINC
OFFSETDESLOCAMENTOA range a set number of rows and columns away from a starting cell, of any size.
OROUTRUE if at least one condition is TRUE.
PDURATIONPDURAÇÃOHow many periods an investment needs to reach a target at a steady rate.
PEARSONPEARSONThe Pearson correlation coefficient, the same as CORREL.
PERCENTILEPERCENTILThe value below which a given percentage of the data falls.
PERCENTILE.EXCPERCENTIL.EXCThe value below which a percentage of the data falls, excluding 0% and 100%.
PERCENTILE.INCPERCENTIL.INC
PERCENTRANKORDEM.PERCENTUAL
PERCENTRANK.EXCORDEM.PERCENTUAL.EXCWhere a value stands in a list, between 0 and 1 without ever reaching either.
PERCENTRANK.INCORDEM.PERCENTUAL.INCWhere a value stands in a list, from 0 (the lowest) to 1 (the highest).
PERMUTPERMUTARHow many ways to pick a number of items from a group, when the order matters.
PERMUTATIONAPERMUTAR.RThe number of ordered arrangements when the same item may be used more than once: number to the power of number_chosen.
PHIPHIThe height of the standard normal bell curve at x.
PHONETICFONÉTICA
PIPIThe number π (3.14159…).
PMTPGTOThe payment for a loan with constant payments and a constant interest rate.
POISSONPOISSON
POISSON.DISTDIST.POISSONThe chance of a number of events in a period, given how many happen on average.
POWERPOTÊNCIARaises a number to a power (same as ^).
PPMTPPGTOThe principal (pay-down) part of one loan payment.
PRICEPREÇO
PRICEDISCPREÇODESC
PRICEMATPREÇOVENC
PROBPROBAdds up the probabilities of the outcomes that fall between two limits.
PRODUCTPRODUTOMultiplies all the numbers together.
PROPERINICIAL.MAIÚSCULACapitalises The First Letter Of Each Word.
PVVAThe present value: what a series of future payments is worth now.
QUARTILEQUARTILA quartile of the data (0 = min, 2 = median, 4 = max).
QUARTILE.EXCQUARTIL.EXCA quartile of the data (1, 2 or 3), using the exclusive method.
QUARTILE.INCQUARTIL.INC
QUOTIENTQUOCIENTEThe whole-number part of a division.
RADIANSRADIANOSTurns degrees into radians, which is what SIN, COS and TAN take.
RANDALEATÓRIOA random number between 0 and 1. Changes on every edit.
RANDARRAYMATRIZALEATÓRIAFills an array with random numbers.
RANDBETWEENALEATÓRIOENTREA random whole number between two limits.
RANKORDEMThe position of a number in a list (1 = largest by default).
RANK.AVGORDEM.MÉDThe position of a number in a list. Tied values share the average of their positions.
RATETAXAThe interest rate per period of a loan or investment.
RECEIVEDRECEBER
REPLACESUBSTITUIRReplaces characters at a given position.
REPTREPETIRRepeats text a number of times.
RIGHTDIREITAThe last characters of a text value.
ROMANROMANOWrites a number in Roman numerals.
ROUNDARREDRounds a number to a given number of digits.
ROUNDDOWNARRED.PARA.BAIXORounds a number towards zero.
ROUNDUPARRED.PARA.CIMARounds a number away from zero.
ROWLINThe row number of a reference (or of the current cell).
ROWSLINSHow many rows a range has.
RRIDEVOLVERTAXAJUROSThe steady growth rate per period that turns one amount into another (CAGR).
RSQRQUADR squared: the share of the variation in y that the best-fit line explains, from 0 to 1.
RTDRTD
SEARCHPROCURARPosition of one text inside another (not case-sensitive, allows wildcards).
SECSECThe secant of an angle: 1 divided by its cosine.
SECHSECH
SECONDSEGUNDOThe second of a time (0-59).
SEQUENCESEQUÊNCIAGenerates a list of sequential numbers that spills into neighbouring cells.
SERIESSUMSOMASÉRIEThe sum of a power series: each coefficient times x raised to a power that grows by a fixed step.
SHEETFOLHAThe number of a sheet, counting the tabs from the left: 1 for the first.
SHEETSFOLHASHow many sheets the workbook has.
SIGNSINAL1 for positive numbers, -1 for negative, 0 for zero.
SINSENThe sine of an angle given in radians.
SINHSENHThe hyperbolic sine of a number.
SKEWDISTORÇÃOSkewness: how lopsided the data are. Positive means a longer tail of high values, negative a longer tail of low values.
SKEW.PDISTORÇÃO.PHow lopsided a whole population is: positive when the tail runs to the right, negative when it runs to the left.
SLNAMORTStraight-line depreciation: the same loss of value every year.
SLOPEDECLIVEThe slope of the straight line that best fits the data: how much y changes for each 1 added to x.
SMALLMENORThe k-th smallest value (k = 1 is the minimum).
SORTORDENARSorts a range. The result spills.
SORTBYORDENARPORSorts a range by the values in another range.
SQRTRAIZQSquare root.
SQRTPIRAIZPIThe square root of a number multiplied by π.
STANDARDIZENORMALIZARA z-score: how many standard deviations a value is above (or below) the mean.
STDEVDESVPADStandard deviation of a sample.
STDEV.PDESVPAD.PStandard deviation of an entire population.
STDEV.SDESVPAD.S
STDEVADESVPADAThe standard deviation of a sample, counting text and FALSE in a range as 0 and TRUE as 1. STDEV skips them.
STDEVPDESVPADP
STDEVPADESVPADPAThe standard deviation of a whole population, counting text and FALSE in a range as 0 and TRUE as 1. STDEVP skips them.
STEYXEPADYXThe standard error of the regression: the typical distance of a y value from the best-fit line.
SUBSTITUTESUBSTReplaces specific text with new text.
SUBTOTALSUBTOTALTotals a range, leaving out rows that a filter hides and other subtotals inside it.
SUMSOMAAdds up numbers, cells and ranges.
SUMIFSOMA.SEAdds the cells that meet one condition.
SUMIFSSOMA.SE.SAdds the cells that meet every one of several conditions.
SUMPRODUCTSOMARPRODUTOMultiplies matching items in arrays, then adds the results.
SUMSQSOMARQUADAdds the squares of the numbers.
SUMX2MY2SOMAX2DY2Adds up the differences of the squares of matching values in two ranges.
SUMX2PY2SOMAX2SY2Adds up the sums of the squares of matching values in two ranges.
SUMXMY2SOMAXMY2Adds up the squares of the differences of matching values in two ranges.
SWITCHPARÂMETROCompares a value against a list and returns the matching result.
SYDAMORTDSum-of-years’ digits depreciation: more in the early periods, less in the late ones.
TTReturns the value if it is text, otherwise empty text.
T.DISTDIST.TStudent's t-distribution: the chance of a t of x or less, or the height of the curve at x.
T.DIST.2TDIST.T.2CThe two-tailed t-distribution: the chance of a t further from 0 than x, on either side. This is the p-value of a two-sided t-test.
T.DIST.RTDIST.T.DIRThe right tail of the t-distribution: the chance of a t greater than x.
T.INVINV.TThe t-value below which a given share of the t-distribution falls.
T.INV.2TINV.T.2CThe t-value with a given share of the distribution beyond it, counting both tails. This is the critical value of a two-sided test.
T.TESTTESTE.TStudent's t-test: the chance that two samples would differ this much if they came from populations with the same mean.
TANTANThe tangent of an angle given in radians.
TANHTANHThe hyperbolic tangent of a number.
TBILLEQOTN
TBILLPRICEOTNVALOR
TBILLYIELDOTNLUCRO
TDISTDISTTThe tail of the t-distribution beyond x, on one side or both. The older form of T.DIST.RT and T.DIST.2T.
TEXTTEXTOFormats a number as text using a format code.
TEXTAFTERTEXTODEPOISThe text that comes after a delimiter.
TEXTBEFORETEXTOANTESThe text that comes before a delimiter.
TEXTJOINUNIRTEXTOJoins text with a separator between each item.
TEXTSPLITDIVIDIRTEXTOSplits text into separate cells at a delimiter. The result spills.
TIMETEMPOBuilds a time from hours, minutes and seconds.
TIMEVALUEVALOR.TEMPOConverts a time written as text into a fraction of a day.
TINVINVT
TODAYHOJEToday's date. Updates automatically.
TOROWPARALINTurns an array into a single row.
TRANSPOSETRANSPORFlips rows into columns and columns into rows.
TRENDTENDÊNCIAValues on the best-fit straight line (least squares): fitted values for the known data, or predictions for new x values. Spills.
TRIMCOMPACTARRemoves extra spaces, leaving single spaces between words.
TRIMMEANMÉDIA.INTERNAThe average with a share of the highest and lowest values left out.
TRUNCTRUNCARCuts off the decimal part of a number.
TTESTTESTET
TYPETIPOA number for the kind of value: 1 number, 2 text, 4 TRUE or FALSE, 16 error, 64 array.
UNICHARUNICARÁTThe character with a Unicode number: letters of any alphabet, symbols, emoji.
UNICODEUNICODEThe Unicode number of the first character of some text.
UPPERMAIÚSCULASConverts text to UPPERCASE.
VALUEVALORConverts text that looks like a number into a number.
VARVARVariance of a sample.
VAR.PVAR.PVariance of an entire population.
VAR.SVAR.S
VARAVARAThe variance of a sample, counting text and FALSE in a range as 0 and TRUE as 1. VAR skips them.
VARPVARP
VARPAVARPAThe variance of a whole population, counting text and FALSE in a range as 0 and TRUE as 1. VARP skips them.
VDBBDVDepreciation between any two points in an asset’s life, by declining balance that switches to straight-line once that gives more.
VLOOKUPPROCVFinds a value in the first column of a table and returns a value from the same row.
VSTACKJUNTARVStacks arrays on top of each other into one taller array.
WEEKDAYDIA.SEMANAThe day of the week as a number.
WEEKNUMNÚMSEMANAThe week number of the year.
WEIBULLWEIBULL
WEIBULL.DISTDIST.WEIBULLThe Weibull distribution, used for how long things last before they fail.
WORKDAYDIATRABALHOThe date a number of working days before or after a date.
WORKDAY.INTLDIATRABALHO.INTLThe date a number of working days before or after a date, with the weekend on days you choose.
XIRRXTIRThe yearly rate of return for cash flows that fall on any dates.
XMATCHCORRESPXThe position of a value in a list, with exact match by default.
XNPVXVALNet present value of cash flows that fall on any dates, not evenly spaced ones.
XORXOUTRUE if an odd number of conditions are TRUE.
YEARANOThe year of a date.
YEARFRACFRAÇÃOANOThe fraction of a year between two dates, using a day-count basis.
YIELDLUCRO
YIELDDISCLUCRODESC
YIELDMATLUCROVENC
Z.TESTTESTE.ZThe one-tailed z-test: the chance of a sample mean this far above a claimed population mean.
ZTESTTESTEZ

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 Portuguese (Portugal) 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.

Other languages