Formula translator / Finnish

Excel functions in Finnish and English

Excelin funktiot suomeksi ja englanniksi

Excel in Finnish has its own name for most functions: VLOOKUP is PHAKU and IF is JOS. 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")

Finnish: =JOS(PHAKU(A2; Prices!A:C; 3; EPÄTOSI)>=1,5; "High"; "Low")

In Finnish, 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 468 functions in Finnish and English

TRUE is TOSI and FALSE is EPÄTOSI.

EnglishFinnishWhat it does
ABSITSEISARVOThe absolute value: the number without its sign.
ACCRINTKERTYNYT.KORKO
ACCRINTMKERTYNYT.KORKO.LOPUSSA
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
ADDRESSOSOITEBuilds a cell address as text from a row number and a column number.
AGGREGATEKOOSTELike SUBTOTAL with more calculations, and it can ignore errors in the range.
AMORDEGRCAMORDEGRC
AMORLINCAMORLINC
ANDJATRUE only if every condition is TRUE.
ARABICARABIATurns Roman numerals into a number.
ARRAYTOTEXTMATRIISI.TEKSTIKSIAll the values of a range written out as one piece of text.
ASINASINThe angle, in radians, whose sine is the number. Wrap it in DEGREES() for degrees.
ASINHASINHThe 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.
AVEDEVKESKIPOIKKEAMAThe average distance of the values from their mean: a plain measure of how spread out they are.
AVERAGEKESKIARVOThe arithmetic mean of the numbers.
AVERAGEAKESKIARVOAThe average, counting text in a range as 0 and TRUE as 1.
AVERAGEIFKESKIARVO.JOSAverages the cells that meet a condition.
AVERAGEIFSKESKIARVO.JOS.JOUKKOAverages the cells that meet every one of several conditions.
BASEPERUSWrites a number in another base, such as binary (2) or hexadecimal (16), as text.
BESSELIBESSELI
BESSELJBESSELJ
BESSELKBESSELK
BESSELYBESSELY
BETA.DISTBEETA.JAKAUMAThe beta distribution, for shares and percentages that vary between two bounds.
BETA.INVBEETA.KÄÄNTThe value below which a given share of a beta distribution falls.
BETADISTBEETAJAKAUMAThe chance of x or less in a beta distribution. The older form of BETA.DIST.
BETAINVBEETAJAKAUMA.KÄÄNT
BIN2DECBINDESTurns a binary number into an ordinary one.
BIN2HEXBINHEKSA
BIN2OCTBINOKT
BINOM.DISTBINOMI.JAKAUMAThe chance of a number of successes in a set number of tries, each with the same chance.
BINOM.DIST.RANGEBINOMI.JAKAUMA.ALUEThe chance that the number of successes in a set of tries lands between two counts.
BINOM.INVBINOMIJAKAUMA.KÄÄNTThe smallest number of successes whose cumulative binomial chance reaches a target: how many to plan for.
BINOMDISTBINOMIJAKAUMA
BITANDBITTI.JACompares two whole numbers bit by bit and keeps the bits that are set in both.
BITLSHIFTBITTI.SIIRTO.VMoves the bits of a whole number to the left, which doubles it for every bit moved.
BITORBITTI.TAICompares two whole numbers bit by bit and keeps the bits that are set in either.
BITRSHIFTBITTI.SIIRTO.OMoves the bits of a whole number to the right, which halves it for every bit moved and drops the remainder.
BITXORBITTI.EHDOTON.TAICompares two whole numbers bit by bit and keeps the bits that are set in one but not the other.
CEILINGPYÖRISTÄ.KERR.YLÖSRounds a number up to the nearest multiple (away from zero when both are negative).
CEILING.MATHPYÖRISTÄ.KERR.YLÖS.MATEMAATTINENRounds a number up to the nearest multiple; mode rounds negative numbers away from zero.
CEILING.PRECISEPYÖRISTÄ.KERR.YLÖS.TARKKA
CELLSOLUTells you something about a cell: its address, row, column, contents, number format or the type of value in it.
CHARMERKKIThe character for a character code.
CHIDISTCHIJAKAUMA
CHIINVCHIJAKAUMA.KÄÄNT
CHISQ.DISTCHINELIÖ.JAKAUMAThe chi-square distribution: the chance of a value of x or less, or the height of the curve at x.
CHISQ.DIST.RTCHINELIÖ.JAKAUMA.OHThe 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.INVCHINELIÖ.KÄÄNTThe value below which a given share of the chi-square distribution falls.
CHISQ.INV.RTCHINELIÖ.KÄÄNT.OHThe chi-square value with a given share of the distribution above it: the critical value of a chi-square test.
CHISQ.TESTCHINELIÖ.TESTIThe chi-square test of independence: the chance of counts this far from the expected ones if nothing but chance were at work.
CHITESTCHITESTI
CHOOSEVALITSE.INDEKSIPicks a value from a list by its position.
CHOOSECOLSVALITSESARAKKEETReturns the columns you name from an array, in the order you name them.
CLEANSIIVOARemoves non-printable characters.
CODEKOODIThe character code of the first character.
COLUMNSARAKEThe column number of a reference (A = 1).
COLUMNSSARAKKEETHow many columns a range has.
COMBINKOMBINAATIOHow many ways to choose a number of items from a group, when the order does not matter.
COMBINAKOMBINAATIOAThe number of ways to choose items when the same item may be chosen more than once and the order does not matter.
COMPLEXKOMPLEKSI
CONCATYHDISTÄJoins text from several values or ranges.
CONCATENATEKETJUTAJoins several text values (older version of CONCAT).
CONFIDENCELUOTTAMUSVÄLI
CONFIDENCE.NORMLUOTTAMUSVÄLI.NORMThe margin of error for an average: add and subtract it to get the confidence interval.
CONFIDENCE.TLUOTTAMUSVÄLI.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.
CONVERTMUUNNAConverts a number from one unit of measurement to another: miles to kilometres, pounds to kilograms, Fahrenheit to Celsius.
CORRELKORRELAATIOThe 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
COUNTLASKECounts cells that contain numbers.
COUNTALASKE.ACounts cells that are not empty.
COUNTBLANKLASKE.TYHJÄTCounts empty cells in a range.
COUNTIFLASKE.JOSCounts the cells that meet a condition.
COUNTIFSLASKE.JOS.JOUKKOCounts the rows that meet every one of several conditions.
COUPDAYBSKORKOPÄIVÄT.ALUSTA
COUPDAYSKORKOPÄIVÄT
COUPDAYSNCKORKOPÄIVÄT.SEURAAVA
COUPNCDKORKOPÄIVÄ.SEURAAVA
COUPNUMKORKOPÄIVÄ.JAKSOT
COUPPCDKORKOPÄIVÄ.EDELLINEN
COVARKOVARIANSSI
COVARIANCE.PKOVARIANSSI.PPopulation covariance: the average product of the deviations of each pair from their means.
COVARIANCE.SKOVARIANSSI.SSample covariance: like COVARIANCE.P, but divides by n − 1 for a sample.
CRITBINOMBINOMIJAKAUMA.KRIT
CSCKOSEKThe cosecant of an angle: 1 divided by its sine.
CSCHKOSEKH
CUBEKPIMEMBERKUUTIOKPIJÄSEN
CUBEMEMBERKUUTIONJÄSEN
CUBEMEMBERPROPERTYKUUTIONJÄSENENOMINAISUUS
CUBERANKEDMEMBERKUUTIONLUOKITELTUJÄSEN
CUBESETKUUTIOJOUKKO
CUBESETCOUNTKUUTIOJOUKKOJENMÄÄRÄ
CUBEVALUEKUUTIONARVO
CUMIPMTMAKSETTU.KORKOTotal interest paid between two payment numbers.
CUMPRINCMAKSETTU.LYHENNYSTotal paid off the loan itself (not interest) between two payment numbers.
DATEPÄIVÄYSBuilds a date from a year, month and day.
DATEDIFPVMEROThe difference between two dates in years, months or days.
DATEVALUEPÄIVÄYSARVOConverts a date written as text into a date serial number.
DAVERAGETKESKIARVOThe average of a column of a table for the rows that meet conditions written in cells.
DAYPÄIVÄThe day of the month (1-31).
DAYSPÄIVÄTThe number of days between two dates.
DAYS360PÄIVÄT360Days between two dates in a year of twelve 30-day months, as some accounts count them.
DBDBDepreciation for one period, losing the same percentage of the remaining value each period.
DCOUNTTLASKECounts the numbers in a column of a table for the rows that meet conditions written in cells.
DCOUNTATLASKEACounts the cells that are not empty in a column of a table for the rows that meet conditions written in cells.
DDBDDBDepreciation for one period at double the straight-line rate (or another multiple).
DEC2BINDESBINWrites a whole number in binary.
DEC2HEXDESHEKSAWrites a whole number in hexadecimal.
DEC2OCTDESOKT
DECIMALDESIMAALITurns a number written in another base, as text, into an ordinary number.
DEGREESASTEETTurns radians into degrees.
DELTASAMA.ARVOTests whether two numbers are equal: 1 when they are, 0 when they are not.
DEVSQOIKAISTU.NELIÖSUMMAThe sum of the squared distances of the values from their mean.
DGETTNOUDAThe 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.
DISCDISKONTTOKORKO
DMAXTMAKSThe largest number in a column of a table among the rows that meet conditions written in cells.
DMINTMINThe smallest number in a column of a table among the rows that meet conditions written in cells.
DOLLARVALUUTTAA number as text in currency style: $1,234.57, with negatives in brackets.
DOLLARDEVALUUTTA.DESTurns a price written with a fraction, as bond prices are (1.02 meaning 1 and 2/16), into an ordinary decimal.
DOLLARFRVALUUTTA.MURTOTurns a decimal price into one written with a fraction, as bond prices are: 1.125 in sixteenths is 1.02.
DPRODUCTTTULOMultiplies the numbers in a column of a table for the rows that meet conditions written in cells.
DROPHYLKÄÄRemoves the first or last rows or columns of an array.
DSTDEVTKESKIHAJONTAThe standard deviation of a column of a table for the matching rows, treating them as a sample.
DSTDEVPTKESKIHAJONTAPThe standard deviation of a column of a table for the matching rows, treating them as the whole population.
DSUMTSUMMAAdds up a column of a table for the rows that meet conditions written in cells.
DURATIONKESTO
DVARTVARIANSSIThe variance of a column of a table for the matching rows, treating them as a sample.
DVARPTVARIANSSIPThe variance of a column of a table for the matching rows, treating them as the whole population.
EDATEPÄIVÄ.KUUKAUSIThe same day a number of months before or after a date.
EFFECTKORKO.EFEKTThe yearly rate you really pay or earn, once interest is added several times a year.
ENCODEURLURLKOODAUSText made safe to put in a web address: spaces become %20, and so on.
EOMONTHKUUKAUSI.LOPPUThe last day of the month, a number of months away.
ERFVIRHEFUNKTIOThe error function between two limits. With one limit it runs from 0.
ERF.PRECISEVIRHEFUNKTIO.TARKKAThe error function from 0 to x.
ERFCVIRHEFUNKTIO.KOMPLEMENTTIThe complementary error function: 1 - ERF(x).
ERROR.TYPEVIRHEEN.LAJIA number for the kind of error: 2 #DIV/0!, 3 #VALUE!, 4 #REF!, 5 #NAME?, 6 #NUM!, 7 #N/A.
EVENPARILLINENRounds away from zero to the next even integer.
EXACTVERTAATRUE if two text values are exactly the same, including case.
EXPEKSPONENTTIe raised to a power.
EXPANDLAAJENNAGrows an array to a set number of rows and columns, filling the new cells.
EXPON.DISTEKSPONENTIAALI.JAKAUMAThe exponential distribution, for the time between events that happen at a steady rate: the chance of waiting x or less.
EXPONDISTEKSPONENTIAALIJAKAUMA
F.DISTF.JAKAUMAThe F-distribution: the chance of a ratio of two variances of x or less, or the height of the curve at x.
F.DIST.RTF.JAKAUMA.OHThe right tail of the F-distribution: the chance of a ratio greater than x. This is the p-value of an F statistic.
F.INVF.KÄÄNTThe value below which a given share of the F-distribution falls.
F.INV.RTF.KÄÄNT.OHThe F value with a given share of the distribution above it: the critical value of an F-test.
F.TESTF.TESTIThe F-test: the chance that two samples would have variances this different if their populations varied equally. Two-tailed.
FACTKERTOMAFactorial: 1 × 2 × … × n.
FACTDOUBLEKERTOMA.OSAThe double factorial: the number times every second whole number below it (7 × 5 × 3 × 1).
FDISTFJAKAUMA
FILTERSUODATAKeeps only the rows that meet a condition. The result spills.
FINDETSIPosition of one text inside another (case-sensitive).
FINVFJAKAUMA.KÄÄNT
FISHERFISHERThe Fisher transformation of a correlation, which makes it close to normally distributed so that it can be tested.
FISHERINVFISHER.KÄÄNTTurns a Fisher-transformed value back into a correlation.
FIXEDKIINTEÄA number as text, rounded to a set number of decimals, with or without commas.
FLOORPYÖRISTÄ.KERR.ALASRounds a number down to the nearest multiple (toward zero when both are negative).
FLOOR.MATHPYÖRISTÄ.KERR.ALAS.MATEMAATTINENRounds a number down to the nearest multiple; mode rounds negative numbers toward zero.
FLOOR.PRECISEPYÖRISTÄ.KERR.ALAS.TARKKA
FORECASTENNUSTEPredicts a y value for a new x from the best-fit straight line through known data.
FORMULATEXTKAAVA.TEKSTIShows the formula in a cell as text.
FREQUENCYTAAJUUSCounts 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.
FTESTFTESTI
FVTULEVA.ARVOThe future value of an investment with regular payments.
FVSCHEDULETULEVA.ARVO.ERIKORKOWhat an amount grows to when the interest rate changes from period to period.
GAMMAGAMMAThe gamma function, which stretches the factorial to numbers that are not whole: GAMMA(n) is (n-1)!
GAMMA.DISTGAMMA.JAKAUMAThe gamma distribution, for values that cannot be negative and lean to the right, such as waiting times.
GAMMA.INVGAMMA.JAKAUMA.KÄÄNTThe value below which a given share of a gamma distribution falls.
GAMMADISTGAMMAJAKAUMA
GAMMAINVGAMMAJAKAUMA.KÄÄNT
GAMMALNGAMMALNThe natural logarithm of the gamma function. It stays small where GAMMA itself would overflow.
GAMMALN.PRECISEGAMMALN.TARKKA
GAUSSGAUSSThe chance that a standard normal value falls between the mean and z standard deviations above it.
GCDSUURIN.YHT.TEKIJÄGreatest common divisor.
GEOMEANKESKIARVO.GEOMThe geometric mean: the right average for growth rates.
GESTEPRAJATests whether a number reaches a threshold: 1 when it is greater than or equal to the step, 0 when it is not.
GETPIVOTDATANOUDA.PIVOT.TIEDOTReads one value out of a PivotTable by naming it, so that the formula still finds it when the PivotTable grows or is sorted.
GROWTHKASVUValues on the best-fit exponential curve: predictions for something that grows by a steady percentage rather than a steady amount. Spills.
HARMEANKESKIARVO.HARMThe harmonic mean: the right average for rates such as speeds.
HEX2BINHEKSABIN
HEX2DECHEKSADESTurns a hexadecimal number into an ordinary one.
HEX2OCTHEKSAOKT
HLOOKUPVHAKUFinds a value in the first row of a table and returns a value from the same column.
HOURTUNNITThe hour of a time (0-23).
HSTACKHPINOPlaces arrays side by side into one wider array.
HYPERLINKHYPERLINKKIMakes 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.DISTHYPERGEOM_JAKAUMAThe hypergeometric distribution: the chance of a number of successes in a sample drawn without putting anything back.
HYPGEOMDISTHYPERGEOM.JAKAUMAThe chance of exactly a number of successes in a sample drawn without putting anything back. The older form of HYPGEOM.DIST.
IFJOSReturns one value if a condition is TRUE and another if it is FALSE.
IFERRORJOSVIRHEReturns a fallback value if a formula results in an error.
IFNAJOSPUUTTUUReturns a fallback value only for #N/A errors.
IFSJOSSChecks conditions in order and returns the value for the first TRUE one.
IMABSKOMPLEKSI.ABS
IMAGINARYKOMPLEKSI.IMAG
IMARGUMENTKOMPLEKSI.ARG
IMCONJUGATEKOMPLEKSI.KONJ
IMCOSKOMPLEKSI.COS
IMCOSHIMCOSH
IMCOTKOMPLEKSI.COT
IMCSCKOMPLEKSI.KOSEK
IMCSCHKOMPLEKSI.KOSEKH
IMDIVKOMPLEKSI.OSAM
IMEXPKOMPLEKSI.EKSP
IMLNKOMPLEKSI.LN
IMLOG10KOMPLEKSI.LOG10
IMLOG2KOMPLEKSI.LOG2
IMPOWERKOMPLEKSI.POT
IMPRODUCTKOMPLEKSI.TULO
IMREALKOMPLEKSI.REAALI
IMSECKOMPLEKSI.SEK
IMSECHKOMPLEKSI.SEKH
IMSINKOMPLEKSI.SIN
IMSINHKOMPLEKSI.SINH
IMSQRTKOMPLEKSI.NELIÖJ
IMSUBKOMPLEKSI.EROTUS
IMSUMKOMPLEKSI.SUM
IMTANKOMPLEKSI.TAN
INDEXINDEKSIThe value at a given row and column of a range.
INDIRECTEPÄSUORATurns text such as "B2" into a real reference to that cell or range.
INFOKUVAUS
INTKOKONAISLUKURounds down to the nearest whole number.
INTERCEPTLEIKKAUSPISTEWhere the best-fit straight line crosses the y axis: the predicted y when x is 0.
INTRATEKORKO.ARVOPAPERI
IPMTIPMTThe interest part of one loan payment.
IRRSISÄINEN.KORKOInternal rate of return for a series of cash flows.
ISBLANKONTYHJÄTRUE if the cell is empty.
ISERRONVIRHTRUE if the value is any error except #N/A.
ISERRORONVIRHETRUE if the value is any error.
ISEVENONPARILLINENTRUE if the number is even.
ISFORMULAONKAAVATRUE if the cell holds a formula.
ISLOGICALONTOTUUSTRUE if the value is TRUE or FALSE.
ISNAONPUUTTUUTRUE if the value is the #N/A error.
ISNONTEXTONEI_TEKSTITRUE if the value is not text.
ISNUMBERONLUKUTRUE if the value is a number (dates count too).
ISODDONPARITONTRUE if the number is odd.
ISOWEEKNUMVIIKKO.ISO.NROThe ISO 8601 week number: weeks start on Monday, and week 1 contains the first Thursday of the year.
ISPMTISPMTThe interest paid in a period of a loan that is repaid in equal amounts of principal, so the interest falls every period.
ISREFONVIITTTRUE if the value is a reference to a cell or range.
ISTEXTONTEKSTITRUE if the value is text.
KURTKURTKurtosis: how heavy the tails are compared with a normal distribution (0). Positive means more extreme values.
LARGESUURIThe k-th largest value (k = 1 is the maximum).
LCMPIENIN.YHT.JAETTAVALeast common multiple.
LEFTVASENThe first characters of a text value.
LENPITUUSThe number of characters in a text value.
LINESTLINREGRFits 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.
LNLUONNLOGNatural logarithm.
LOGLOGLogarithm to a base (default 10).
LOG10LOG10Base-10 logarithm.
LOGESTLOGREGRFits 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.
LOGINVLOGNORM.JAKAUMA.KÄÄNT
LOGNORM.DISTLOGNORM_JAKAUMAThe lognormal distribution, for values whose logarithm is normally distributed, such as prices and incomes.
LOGNORM.INVLOGNORM.KÄÄNTThe value below which a given share of a lognormal distribution falls.
LOGNORMDISTLOGNORM.JAKAUMAThe chance of x or less in a lognormal distribution. The older form of LOGNORM.DIST.
LOOKUPHAKUFinds a value in a sorted row or column and returns the value in the same place in another. XLOOKUP is the modern choice.
LOWERPIENETConverts text to lowercase.
MATCHVASTINEThe position of a value in a row or column.
MAXMAKSThe largest number.
MAXAMAKSAThe largest value, counting text in a range as 0 and TRUE as 1.
MAXIFSMAKS.JOSThe largest value among cells that meet conditions.
MDETERMMDETERMThe determinant of a square matrix.
MDURATIONKESTO.MUUNN
MEDIANMEDIAANIThe middle number of a sorted list.
MIDPOIMI.TEKSTICharacters from the middle of a text value.
MINMINThe smallest number.
MINAMINAThe smallest value, counting text in a range as 0 and TRUE as 1.
MINIFSMIN.JOSThe smallest value among cells that meet conditions.
MINUTEMINUUTITThe minute of a time (0-59).
MINVERSEMKÄÄNTEINENThe inverse of a square matrix.
MIRRMSISÄINENRate of return when money borrowed and money reinvested earn different rates.
MMULTMKERROMultiplies two matrices.
MODJAKOJThe remainder after division.
MODEMOODIThe most frequently occurring number.
MODE.MULTMOODI.USEAEvery value that is tied for most common, as a list.
MODE.SNGLMOODI.YKSI
MONTHKUUKAUSIThe month of a date (1-12).
MROUNDPYÖRISTÄ.KERRRounds to the nearest multiple of a number.
MULTINOMIALMULTINOMIThe 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.
MUNITYKSIKKÖMThe unit matrix of a given size: 1 down the diagonal and 0 everywhere else.
NNConverts a value to a number (text becomes 0).
NAPUUTTUUReturns the #N/A error on purpose.
NEGBINOM.DISTBINOMI.JAKAUMA.NEGThe negative binomial distribution: the chance of a number of failures before a given number of successes.
NEGBINOMDISTBINOMIJAKAUMA.NEGThe chance of exactly a number of failures before a given number of successes. The older form of NEGBINOM.DIST.
NETWORKDAYSTYÖPÄIVÄTWorking days (Monday–Friday) between two dates, inclusive.
NETWORKDAYS.INTLTYÖPÄIVÄT.KANSVÄLWorking days between two dates, inclusive, with the weekend on days you choose.
NOMINALKORKO.VUOSIThe quoted yearly rate behind an effective rate. The reverse of EFFECT.
NORM.DISTNORMAALI.JAKAUMAThe normal distribution: the chance of a value at or below x, or the height of the bell curve at x.
NORM.INVNORMAALI.JAKAUMA.KÄÄNTThe value below which a given share of a normal distribution falls.
NORM.S.DISTNORM_JAKAUMA.NORMITThe standard normal distribution (mean 0, standard deviation 1) at a z-score.
NORM.S.INVNORM_JAKAUMA.KÄÄNTThe z-score below which a given share of the standard normal distribution falls.
NORMDISTNORM.JAKAUMA
NORMINVNORM.JAKAUMA.KÄÄNT
NORMSDISTNORM.JAKAUMA.NORMITThe chance of a z-score or less in the standard normal distribution. The older form of NORM.S.DIST.
NORMSINVNORM.JAKAUMA.NORMIT.KÄÄNT
NOTEIFlips TRUE to FALSE and FALSE to TRUE.
NOWNYTThe current date and time.
NPERNJAKSOHow many payment periods are needed to pay off a loan.
NPVNNANet present value of future cash flows at a discount rate.
NUMBERVALUENROARVOTurns text into a number, whatever decimal and thousands marks it uses.
OCT2BINOKTBIN
OCT2DECOKTDES
OCT2HEXOKTHEKSA
ODDPARITONRounds away from zero to the next odd integer.
ODDFPRICEPARITON.ENS.NIMELLISARVO
ODDFYIELDPARITON.ENS.TUOTTO
ODDLPRICEPARITON.VIIM.NIMELLISARVO
ODDLYIELDPARITON.VIIM.TUOTTO
OFFSETSIIRTYMÄA range a set number of rows and columns away from a starting cell, of any size.
ORTAITRUE if at least one condition is TRUE.
PDURATIONKESTO.JAKSOHow many periods an investment needs to reach a target at a steady rate.
PEARSONPEARSONThe Pearson correlation coefficient, the same as CORREL.
PERCENTILEPROSENTTIPISTEThe value below which a given percentage of the data falls.
PERCENTILE.EXCPROSENTTIPISTE.ULKThe value below which a percentage of the data falls, excluding 0% and 100%.
PERCENTILE.INCPROSENTTIPISTE.SIS
PERCENTRANKPROSENTTIJÄRJESTYS
PERCENTRANK.EXCPROSENTTIJÄRJESTYS.ULKWhere a value stands in a list, between 0 and 1 without ever reaching either.
PERCENTRANK.INCPROSENTTIJÄRJESTYS.SISWhere a value stands in a list, from 0 (the lowest) to 1 (the highest).
PERMUTPERMUTAATIOHow many ways to pick a number of items from a group, when the order matters.
PERMUTATIONAPERMUTAATIOAThe number of ordered arrangements when the same item may be used more than once: number to the power of number_chosen.
PHIFIIThe height of the standard normal bell curve at x.
PHONETICFONEETTINEN
PIPIIThe number π (3.14159…).
PMTMAKSUThe payment for a loan with constant payments and a constant interest rate.
POISSONPOISSON
POISSON.DISTPOISSON.JAKAUMAThe chance of a number of events in a period, given how many happen on average.
POWERPOTENSSIRaises a number to a power (same as ^).
PPMTPPMTThe principal (pay-down) part of one loan payment.
PRICEHINTA
PRICEDISCHINTA.DISK
PRICEMATHINTA.LUNASTUS
PROBTODENNÄKÖISYYSAdds up the probabilities of the outcomes that fall between two limits.
PRODUCTTULOMultiplies all the numbers together.
PROPERERISNIMICapitalises The First Letter Of Each Word.
PVNAThe present value: what a series of future payments is worth now.
QUARTILENELJÄNNESA quartile of the data (0 = min, 2 = median, 4 = max).
QUARTILE.EXCNELJÄNNES.ULKA quartile of the data (1, 2 or 3), using the exclusive method.
QUARTILE.INCNELJÄNNES.SIS
QUOTIENTOSAMÄÄRÄThe whole-number part of a division.
RADIANSRADIAANITTurns degrees into radians, which is what SIN, COS and TAN take.
RANDSATUNNAISLUKUA random number between 0 and 1. Changes on every edit.
RANDARRAYSATUNN.MATRIISIFills an array with random numbers.
RANDBETWEENSATUNNAISLUKU.VÄLILTÄA random whole number between two limits.
RANKARVON.MUKAANThe position of a number in a list (1 = largest by default).
RANK.AVGARVON.MUKAAN.KESKIARVOThe position of a number in a list. Tied values share the average of their positions.
RATEKORKOThe interest rate per period of a loan or investment.
REPLACEKORVAAReplaces characters at a given position.
REPTTOISTARepeats text a number of times.
RIGHTOIKEAThe last characters of a text value.
ROMANROMANWrites a number in Roman numerals.
ROUNDPYÖRISTÄRounds a number to a given number of digits.
ROUNDDOWNPYÖRISTÄ.DES.ALASRounds a number towards zero.
ROUNDUPPYÖRISTÄ.DES.YLÖSRounds a number away from zero.
ROWRIVIThe row number of a reference (or of the current cell).
ROWSRIVITHow many rows a range has.
RRITOT.ROIThe steady growth rate per period that turns one amount into another (CAGR).
RSQPEARSON.NELIÖR squared: the share of the variation in y that the best-fit line explains, from 0 to 1.
RTDRTD
SEARCHKÄY.LÄPIPosition of one text inside another (not case-sensitive, allows wildcards).
SECSEKThe secant of an angle: 1 divided by its cosine.
SECHSEKH
SECONDSEKUNNITThe second of a time (0-59).
SERIESSUMSARJA.SUMMAThe sum of a power series: each coefficient times x raised to a power that grows by a fixed step.
SHEETTAULUKKOThe number of a sheet, counting the tabs from the left: 1 for the first.
SHEETSTAULUKOTHow many sheets the workbook has.
SIGNETUMERKKI1 for positive numbers, -1 for negative, 0 for zero.
SINSINThe sine of an angle given in radians.
SINHSINHThe hyperbolic sine of a number.
SKEWJAKAUMAN.VINOUSSkewness: how lopsided the data are. Positive means a longer tail of high values, negative a longer tail of low values.
SKEW.PJAKAUMAN.VINOUS.POPHow lopsided a whole population is: positive when the tail runs to the right, negative when it runs to the left.
SLNSTPStraight-line depreciation: the same loss of value every year.
SLOPEKULMAKERROINThe slope of the straight line that best fits the data: how much y changes for each 1 added to x.
SMALLPIENIThe k-th smallest value (k = 1 is the minimum).
SORTLAJITTELESorts a range. The result spills.
SORTBYLAJITTELE.ARVOJEN.PERUSTEELLASorts a range by the values in another range.
SQRTNELIÖJUURISquare root.
SQRTPINELIÖJUURI.PIIThe square root of a number multiplied by π.
STANDARDIZENORMITAA z-score: how many standard deviations a value is above (or below) the mean.
STDEVKESKIHAJONTAStandard deviation of a sample.
STDEV.PKESKIHAJONTA.PStandard deviation of an entire population.
STDEV.SKESKIHAJONTA.S
STDEVAKESKIHAJONTAAThe standard deviation of a sample, counting text and FALSE in a range as 0 and TRUE as 1. STDEV skips them.
STDEVPKESKIHAJONTAP
STDEVPAKESKIHAJONTAPAThe standard deviation of a whole population, counting text and FALSE in a range as 0 and TRUE as 1. STDEVP skips them.
STEYXKESKIVIRHEThe standard error of the regression: the typical distance of a y value from the best-fit line.
SUBSTITUTEVAIHDAReplaces specific text with new text.
SUBTOTALVÄLISUMMATotals a range, leaving out rows that a filter hides and other subtotals inside it.
SUMSUMMAAdds up numbers, cells and ranges.
SUMIFSUMMA.JOSAdds the cells that meet one condition.
SUMIFSSUMMA.JOS.JOUKKOAdds the cells that meet every one of several conditions.
SUMPRODUCTTULOJEN.SUMMAMultiplies matching items in arrays, then adds the results.
SUMSQNELIÖSUMMAAdds the squares of the numbers.
SUMX2MY2NELIÖSUMMIEN.EROTUSAdds up the differences of the squares of matching values in two ranges.
SUMX2PY2NELIÖSUMMIEN.SUMMAAdds up the sums of the squares of matching values in two ranges.
SUMXMY2EROTUSTEN.NELIÖSUMMAAdds up the squares of the differences of matching values in two ranges.
SYDVUOSIPOISTOSum-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.DISTT.JAKAUMAStudent's t-distribution: the chance of a t of x or less, or the height of the curve at x.
T.DIST.2TT.JAKAUMA.2SThe 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.RTT.JAKAUMA.OHThe right tail of the t-distribution: the chance of a t greater than x.
T.INVT.KÄÄNTThe t-value below which a given share of the t-distribution falls.
T.INV.2TT.KÄÄNT.2SThe 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.TESTT.TESTIStudent'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.
TBILLEQOBLIG.TUOTTOPROS
TBILLPRICEOBLIG.HINTA
TBILLYIELDOBLIG.TUOTTO
TDISTTJAKAUMAThe tail of the t-distribution beyond x, on one side or both. The older form of T.DIST.RT and T.DIST.2T.
TEXTTEKSTIFormats a number as text using a format code.
TEXTAFTERTEKSTI.JÄLKEENThe text that comes after a delimiter.
TEXTBEFORETEKSTI.ENNENThe text that comes before a delimiter.
TEXTJOINTEKSTI.YHDISTÄJoins text with a separator between each item.
TEXTSPLITTEKSTINJAKOSplits text into separate cells at a delimiter. The result spills.
TIMEAIKABuilds a time from hours, minutes and seconds.
TIMEVALUEAIKA_ARVOConverts a time written as text into a fraction of a day.
TINVTJAKAUMA.KÄÄNT
TODAYTÄMÄ.PÄIVÄToday's date. Updates automatically.
TOROWRIVIINTurns an array into a single row.
TRANSPOSETRANSPONOIFlips rows into columns and columns into rows.
TRENDSUUNTAUSValues on the best-fit straight line (least squares): fitted values for the known data, or predictions for new x values. Spills.
TRIMPOISTA.VÄLITRemoves extra spaces, leaving single spaces between words.
TRIMMEANKESKIARVO.TASATTUThe average with a share of the highest and lowest values left out.
TRUNCKATKAISECuts off the decimal part of a number.
TTESTTTESTI
TYPETYYPPIA number for the kind of value: 1 number, 2 text, 4 TRUE or FALSE, 16 error, 64 array.
UNICHARUNICODEMERKKIThe character with a Unicode number: letters of any alphabet, symbols, emoji.
UNICODEUNICODEThe Unicode number of the first character of some text.
UNIQUEAINUTKERTAISET.ARVOTRemoves duplicates from a list. The result spills.
UPPERISOTConverts text to UPPERCASE.
VALUEARVOConverts text that looks like a number into a number.
VALUETOTEXTARVO.TEKSTIKSIAny value as text. Text passes through unchanged, or in quotes in the strict format.
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.
VDBVDBDepreciation between any two points in an asset’s life, by declining balance that switches to straight-line once that gives more.
VLOOKUPPHAKUFinds a value in the first column of a table and returns a value from the same row.
VSTACKVPINOStacks arrays on top of each other into one taller array.
WEBSERVICEVERKKOPALVELU
WEEKDAYVIIKONPÄIVÄThe day of the week as a number.
WEEKNUMVIIKKO.NROThe week number of the year.
WEIBULLWEIBULL
WEIBULL.DISTWEIBULL.JAKAUMAThe Weibull distribution, used for how long things last before they fail.
WORKDAYTYÖPÄIVÄThe date a number of working days before or after a date.
WORKDAY.INTLTYÖPÄIVÄ.KANSVÄLThe date a number of working days before or after a date, with the weekend on days you choose.
WRAPROWSRIVITÄRIVWraps a row or column of values into rows of a set length.
XIRRSISÄINEN.KORKO.JAKSOTONThe yearly rate of return for cash flows that fall on any dates.
XLOOKUPXHAKUSearches a range and returns the matching item from another range. The modern replacement for VLOOKUP.
XMATCHXVASTINEThe position of a value in a list, with exact match by default.
XNPVNNA.JAKSOTONNet present value of cash flows that fall on any dates, not evenly spaced ones.
XOREHDOTON.TAITRUE if an odd number of conditions are TRUE.
YEARVUOSIThe year of a date.
YEARFRACVUOSI.OSAThe fraction of a year between two dates, using a day-count basis.
YIELDTUOTTO
YIELDDISCTUOTTO.DISK
YIELDMATTUOTTO.ERÄP
Z.TESTZ.TESTIThe one-tailed z-test: the chance of a sample mean this far above a claimed population mean.
ZTESTZTESTI

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 Finnish 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