Formula translator / Danish

Excel functions in Danish and English

Excel-funktioner på dansk og engelsk

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

Danish: =HVIS(LOPSLAG(A2; Prices!A:C; 3; FALSK)>=1,5; "High"; "Low")

In Danish, 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 469 functions in Danish and English

TRUE is SAND and FALSE is FALSK.

EnglishDanishWhat it does
ABSABSThe absolute value: the number without its sign.
ACOSARCCOSThe angle, in radians, whose cosine is the number.
ACOSHARCCOSHThe inverse hyperbolic cosine of a number.
ACOTARCCOTThe angle, in radians, whose cotangent is the number. The result is between 0 and π.
ACOTHARCCOTH
ADDRESSADRESSEBuilds a cell address as text from a row number and a column number.
AGGREGATESAMLINGLike SUBTOTAL with more calculations, and it can ignore errors in the range.
AMORDEGRCAMORDEGRC
AMORLINCAMORLINC
ANDOGTRUE only if every condition is TRUE.
ARABICARABISKTurns Roman numerals into a number.
AREASOMRÅDER
ARRAYTOTEXTMATRIXTILTEKSTAll the values of a range written out as one piece of text.
ASINARCSINThe angle, in radians, whose sine is the number. Wrap it in DEGREES() for degrees.
ASINHARCSINHThe inverse hyperbolic sine of a number.
ATANARCTANThe angle, in radians, whose tangent is the number.
ATAN2ARCTAN2The 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.
ATANHARCTANHThe inverse hyperbolic tangent of a number.
AVEDEVMADThe average distance of the values from their mean: a plain measure of how spread out they are.
AVERAGEMIDDELThe arithmetic mean of the numbers.
AVERAGEAMIDDELVThe average, counting text in a range as 0 and TRUE as 1.
AVERAGEIFMIDDEL.HVISAverages the cells that meet a condition.
AVERAGEIFSMIDDEL.HVISERAverages the cells that meet every one of several conditions.
BASEBASISWrites a number in another base, such as binary (2) or hexadecimal (16), as text.
BESSELIBESSELI
BESSELJBESSELJ
BESSELKBESSELK
BESSELYBESSELY
BETA.DISTBETA.FORDELINGThe beta distribution, for shares and percentages that vary between two bounds.
BETA.INVBETA.INVThe value below which a given share of a beta distribution falls.
BETADISTBETAFORDELINGThe chance of x or less in a beta distribution. The older form of BETA.DIST.
BETAINVBETAINV
BIN2DECBIN.TIL.DECTurns a binary number into an ordinary one.
BIN2HEXBIN.TIL.HEX
BIN2OCTBIN.TIL.OKT
BINOM.DISTBINOMIAL.FORDELINGThe chance of a number of successes in a set number of tries, each with the same chance.
BINOM.DIST.RANGEBINOMIAL.DIST.INTERVALThe chance that the number of successes in a set of tries lands between two counts.
BINOM.INVBINOMIAL.INVThe smallest number of successes whose cumulative binomial chance reaches a target: how many to plan for.
BINOMDISTBINOMIALFORDELING
BITANDBITOGCompares two whole numbers bit by bit and keeps the bits that are set in both.
BITLSHIFTBITLSKIFTMoves the bits of a whole number to the left, which doubles it for every bit moved.
BITORBITELLERCompares two whole numbers bit by bit and keeps the bits that are set in either.
BITRSHIFTBITRSKIFTMoves the bits of a whole number to the right, which halves it for every bit moved and drops the remainder.
BITXORBITXELLERCompares two whole numbers bit by bit and keeps the bits that are set in one but not the other.
CEILINGAFRUND.LOFTRounds a number up to the nearest multiple (away from zero when both are negative).
CEILING.MATHLOFT.MATRounds a number up to the nearest multiple; mode rounds negative numbers away from zero.
CEILING.PRECISELOFT.PRECISE
CELLCELLETells you something about a cell: its address, row, column, contents, number format or the type of value in it.
CHARTEGNThe character for a character code.
CHIDISTCHIFORDELING
CHIINVCHIINV
CHISQ.DISTCHI2.FORDELINGThe chi-square distribution: the chance of a value of x or less, or the height of the curve at x.
CHISQ.DIST.RTCHI2.FORD.RTThe 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.INVCHI2.INVThe value below which a given share of the chi-square distribution falls.
CHISQ.INV.RTCHI2.INV.RTThe chi-square value with a given share of the distribution above it: the critical value of a chi-square test.
CHISQ.TESTCHI2.TESTThe chi-square test of independence: the chance of counts this far from the expected ones if nothing but chance were at work.
CHITESTCHITEST
CHOOSEVÆLGPicks a value from a list by its position.
CHOOSECOLSVÆLGKOLReturns the columns you name from an array, in the order you name them.
CHOOSEROWSVÆLGRÆKKERReturns the rows you name from an array, in the order you name them.
CLEANRENSRemoves non-printable characters.
CODEKODEThe character code of the first character.
COLUMNKOLONNEThe column number of a reference (A = 1).
COLUMNSKOLONNERHow many columns a range has.
COMBINKOMBINHow many ways to choose a number of items from a group, when the order does not matter.
COMBINAKOMBINAThe number of ways to choose items when the same item may be chosen more than once and the order does not matter.
COMPLEXKOMPLEKS
CONCATENATESAMMENKÆDNINGJoins several text values (older version of CONCAT).
CONFIDENCEKONFIDENSINTERVAL
CONFIDENCE.NORMKONFIDENS.NORMThe margin of error for an average: add and subtract it to get the confidence interval.
CONFIDENCE.TKONFIDENSTThe 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.
CONVERTKONVERTERConverts a number from one unit of measurement to another: miles to kilometres, pounds to kilograms, Fahrenheit to Celsius.
CORRELKORRELATIONThe 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
COUNTTÆLCounts cells that contain numbers.
COUNTATÆLVCounts cells that are not empty.
COUNTBLANKANTAL.BLANKECounts empty cells in a range.
COUNTIFTÆL.HVISCounts the cells that meet a condition.
COUNTIFSTÆL.HVISERCounts the rows that meet every one of several conditions.
COUPDAYBSKUPONDAGE.SA
COUPDAYSKUPONDAGE.A
COUPDAYSNCKUPONDAGE.ANK
COUPNCDKUPONDAG.NÆSTE
COUPNUMKUPONBETALINGER
COUPPCDKUPONDAG.FORRIGE
COVARKOVARIANS
COVARIANCE.PKOVARIANS.PPopulation covariance: the average product of the deviations of each pair from their means.
COVARIANCE.SKOVARIANS.SSample covariance: like COVARIANCE.P, but divides by n − 1 for a sample.
CRITBINOMKRITBINOM
CSCCSCThe cosecant of an angle: 1 divided by its sine.
CSCHCSCH
CUBEKPIMEMBERKUBE.KPI.MEDLEM
CUBEMEMBERKUBEMEDLEM
CUBEMEMBERPROPERTYKUBEMEDLEM.EGENSKAB
CUBERANKEDMEMBERKUBERANGERET.MEDLEM
CUBESETKUBESÆT
CUBESETCOUNTKUBESÆT.ANTAL
CUBEVALUEKUBEVÆRDI
CUMIPMTAKKUM.RENTETotal interest paid between two payment numbers.
CUMPRINCAKKUM.HOVEDSTOLTotal paid off the loan itself (not interest) between two payment numbers.
DATEDATOBuilds a date from a year, month and day.
DATEDIFDATO.FORSKELThe difference between two dates in years, months or days.
DATEVALUEDATOVÆRDIConverts a date written as text into a date serial number.
DAVERAGEDMIDDELThe average of a column of a table for the rows that meet conditions written in cells.
DAYDAGThe day of the month (1-31).
DAYSDAGEThe number of days between two dates.
DAYS360DAGE360Days 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.
DCOUNTDTÆLCounts the numbers in a column of a table for the rows that meet conditions written in cells.
DCOUNTADTÆLVCounts the cells that are not empty in a column of a table for the rows that meet conditions written in cells.
DDBDSADepreciation for one period at double the straight-line rate (or another multiple).
DEC2BINDEC.TIL.BINWrites a whole number in binary.
DEC2HEXDEC.TIL.HEXWrites a whole number in hexadecimal.
DEC2OCTDEC.TIL.OKT
DECIMALDECIMALTurns a number written in another base, as text, into an ordinary number.
DEGREESGRADERTurns radians into degrees.
DELTADELTATests whether two numbers are equal: 1 when they are, 0 when they are not.
DEVSQSAKThe sum of the squared distances of the values from their mean.
DGETDHENTThe 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.
DISCDISKONTO
DMAXDMAKSThe largest number in a column of a table among the rows that meet conditions written in cells.
DMINDMINThe smallest number in a column of a table among the rows that meet conditions written in cells.
DOLLARKRA number as text in currency style: $1,234.57, with negatives in brackets.
DOLLARDEKR.DECIMALTurns a price written with a fraction, as bond prices are (1.02 meaning 1 and 2/16), into an ordinary decimal.
DOLLARFRKR.BRØKTurns a decimal price into one written with a fraction, as bond prices are: 1.125 in sixteenths is 1.02.
DPRODUCTDPRODUKTMultiplies the numbers in a column of a table for the rows that meet conditions written in cells.
DROPUDELADRemoves the first or last rows or columns of an array.
DSTDEVDSTDAFVThe standard deviation of a column of a table for the matching rows, treating them as a sample.
DSTDEVPDSTDAFVPThe standard deviation of a column of a table for the matching rows, treating them as the whole population.
DSUMDSUMAdds up a column of a table for the rows that meet conditions written in cells.
DURATIONVARIGHED
DVARDVARIANSThe variance of a column of a table for the matching rows, treating them as a sample.
DVARPDVARIANSPThe variance of a column of a table for the matching rows, treating them as the whole population.
EDATEEDATOThe same day a number of months before or after a date.
EFFECTEFFEKTIV.RENTEThe yearly rate you really pay or earn, once interest is added several times a year.
ENCODEURLKODNINGSURLText made safe to put in a web address: spaces become %20, and so on.
EOMONTHSLUT.PÅ.MÅNEDThe last day of the month, a number of months away.
ERFFEJLFUNKThe error function between two limits. With one limit it runs from 0.
ERF.PRECISEERF.PRECISEThe error function from 0 to x.
ERFCFEJLFUNK.KOMPThe complementary error function: 1 - ERF(x).
ERROR.TYPEFEJLTYPEA number for the kind of error: 2 #DIV/0!, 3 #VALUE!, 4 #REF!, 5 #NAME?, 6 #NUM!, 7 #N/A.
EVENLIGERounds away from zero to the next even integer.
EXACTEKSAKTTRUE if two text values are exactly the same, including case.
EXPEKSPe raised to a power.
EXPANDUDVIDGrows an array to a set number of rows and columns, filling the new cells.
EXPON.DISTEKSP.FORDELINGThe exponential distribution, for the time between events that happen at a steady rate: the chance of waiting x or less.
EXPONDISTEKSPFORDELING
F.DISTF.FORDELINGThe 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.FORDELING.RTThe 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.INVThe value below which a given share of the F-distribution falls.
F.INV.RTF.INV.RTThe F value with a given share of the distribution above it: the critical value of an F-test.
F.TESTF.TESTThe F-test: the chance that two samples would have variances this different if their populations varied equally. Two-tailed.
FACTFAKULTETFactorial: 1 × 2 × … × n.
FACTDOUBLEDOBBELT.FAKULTETThe double factorial: the number times every second whole number below it (7 × 5 × 3 × 1).
FDISTFFORDELING
FILTERFILTRERKeeps only the rows that meet a condition. The result spills.
FILTERXMLFILTRERXML
FINDFINDPosition of one text inside another (case-sensitive).
FINVFINV
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.
FIXEDFASTA number as text, rounded to a set number of decimals, with or without commas.
FLOORAFRUND.GULVRounds a number down to the nearest multiple (toward zero when both are negative).
FLOOR.MATHAFRUND.BUND.MATRounds a number down to the nearest multiple; mode rounds negative numbers toward zero.
FLOOR.PRECISEAFRUND.GULV.PRECISE
FORECASTPROGNOSEPredicts a y value for a new x from the best-fit straight line through known data.
FORMULATEXTFORMELTEKSTShows the formula in a cell as text.
FREQUENCYFREKVENSCounts 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.
FTESTFTEST
FVFVThe future value of an investment with regular payments.
FVSCHEDULEFVTABELWhat 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.FORDELINGThe gamma distribution, for values that cannot be negative and lean to the right, such as waiting times.
GAMMA.INVGAMMA.INVThe value below which a given share of a gamma distribution falls.
GAMMADISTGAMMAFORDELING
GAMMAINVGAMMAINV
GAMMALNGAMMALNThe natural logarithm of the gamma function. It stays small where GAMMA itself would overflow.
GAMMALN.PRECISEGAMMALN.PRECISE
GAUSSGAUSSThe chance that a standard normal value falls between the mean and z standard deviations above it.
GCDSTØRSTE.FÆLLES.DIVISORGreatest common divisor.
GEOMEANGEOMIDDELVÆRDIThe geometric mean: the right average for growth rates.
GESTEPGETRINTests whether a number reaches a threshold: 1 when it is greater than or equal to the step, 0 when it is not.
GETPIVOTDATAGETPIVOTDATAReads one value out of a PivotTable by naming it, so that the formula still finds it when the PivotTable grows or is sorted.
GROWTHFORØGELSEValues on the best-fit exponential curve: predictions for something that grows by a steady percentage rather than a steady amount. Spills.
HARMEANHARMIDDELVÆRDIThe harmonic mean: the right average for rates such as speeds.
HEX2BINHEX.TIL.BIN
HEX2DECHEX.TIL.DECTurns a hexadecimal number into an ordinary one.
HEX2OCTHEX.TIL.OKT
HLOOKUPVOPSLAGFinds a value in the first row of a table and returns a value from the same column.
HOURTIMEThe hour of a time (0-23).
HSTACKHSTAKPlaces arrays side by side into one wider array.
HYPERLINKHYPERLINKMakes 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.DISTHYPGEO.FORDELINGThe hypergeometric distribution: the chance of a number of successes in a sample drawn without putting anything back.
HYPGEOMDISTHYPGEOFORDELINGThe chance of exactly a number of successes in a sample drawn without putting anything back. The older form of HYPGEOM.DIST.
IFHVISReturns one value if a condition is TRUE and another if it is FALSE.
IFERRORHVIS.FEJLReturns a fallback value if a formula results in an error.
IFNAHVISITReturns a fallback value only for #N/A errors.
IFSHVISERChecks conditions in order and returns the value for the first TRUE one.
IMABSIMAGABS
IMAGINARYIMAGINÆR
IMARGUMENTIMAGARGUMENT
IMCONJUGATEIMAGKONJUGERE
IMCOSIMAGCOS
IMCOSHIMAGCOSH
IMCOTIMAGCOT
IMCSCIMAGCSC
IMCSCHIMAGCSCH
IMDIVIMAGDIV
IMEXPIMAGEKSP
IMLNIMAGLN
IMLOG10IMAGLOG10
IMLOG2IMAGLOG2
IMPOWERIMAGPOTENS
IMPRODUCTIMAGPRODUKT
IMREALIMAGREELT
IMSECIMAGSEC
IMSECHIMAGSECH
IMSINIMAGSIN
IMSINHIMAGSINH
IMSQRTIMAGKVROD
IMSUBIMAGSUB
IMSUMIMAGSUM
IMTANIMAGTAN
INDEXINDEKSThe value at a given row and column of a range.
INDIRECTINDIREKTETurns text such as "B2" into a real reference to that cell or range.
INFOINFO
INTHELTALRounds down to the nearest whole number.
INTERCEPTSKÆRINGWhere the best-fit straight line crosses the y axis: the predicted y when x is 0.
INTRATERENTEFOD
IPMTR.YDELSEThe interest part of one loan payment.
IRRIAInternal rate of return for a series of cash flows.
ISBLANKER.TOMTRUE if the cell is empty.
ISERRER.FJLTRUE if the value is any error except #N/A.
ISERRORER.FEJLTRUE if the value is any error.
ISEVENER.LIGETRUE if the number is even.
ISFORMULAER.FORMELTRUE if the cell holds a formula.
ISLOGICALER.LOGISKTRUE if the value is TRUE or FALSE.
ISNAER.IKKE.TILGÆNGELIGTRUE if the value is the #N/A error.
ISNONTEXTER.IKKE.TEKSTTRUE if the value is not text.
ISNUMBERER.TALTRUE if the value is a number (dates count too).
ISODDER.ULIGETRUE if the number is odd.
ISOWEEKNUMISOUGE.NRThe 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.
ISREFER.REFERENCETRUE if the value is a reference to a cell or range.
ISTEXTER.TEKSTTRUE if the value is text.
KURTTOPSTEJLKurtosis: how heavy the tails are compared with a normal distribution (0). Positive means more extreme values.
LARGESTØRSTEThe k-th largest value (k = 1 is the maximum).
LCMMINDSTE.FÆLLES.MULTIPLUMLeast common multiple.
LEFTVENSTREThe first characters of a text value.
LENLÆNGDEThe 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.
LNLNNatural 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.
LOGINVLOGINV
LOGNORM.DISTLOGNORM.FORDELINGThe lognormal distribution, for values whose logarithm is normally distributed, such as prices and incomes.
LOGNORM.INVLOGNORM.INVThe value below which a given share of a lognormal distribution falls.
LOGNORMDISTLOGNORMFORDELINGThe chance of x or less in a lognormal distribution. The older form of LOGNORM.DIST.
LOOKUPSLÅ.OPFinds a value in a sorted row or column and returns the value in the same place in another. XLOOKUP is the modern choice.
LOWERSMÅ.BOGSTAVERConverts text to lowercase.
MATCHSAMMENLIGNThe position of a value in a row or column.
MAXMAKSThe largest number.
MAXAMAKSVThe largest value, counting text in a range as 0 and TRUE as 1.
MAXIFSMAKSHVISERThe largest value among cells that meet conditions.
MDETERMMDETERMThe determinant of a square matrix.
MDURATIONMVARIGHED
MEDIANMEDIANThe middle number of a sorted list.
MIDMIDTCharacters from the middle of a text value.
MINMINThe smallest number.
MINAMINVThe smallest value, counting text in a range as 0 and TRUE as 1.
MINIFSMINHVISERThe smallest value among cells that meet conditions.
MINUTEMINUTThe minute of a time (0-59).
MINVERSEMINVERTThe inverse of a square matrix.
MIRRMIARate of return when money borrowed and money reinvested earn different rates.
MMULTMPRODUKTMultiplies two matrices.
MODRESTThe remainder after division.
MODEHYPPIGSTThe most frequently occurring number.
MODE.MULTHYPPIGST.FLEREEvery value that is tied for most common, as a list.
MONTHMÅNEDThe month of a date (1-12).
MROUNDMAFRUNDRounds to the nearest multiple of a number.
MULTINOMIALMULTINOMIALThe 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.
MUNITMENHEDThe unit matrix of a given size: 1 down the diagonal and 0 everywhere else.
NTALConverts a value to a number (text becomes 0).
NAIKKE.TILGÆNGELIGReturns the #N/A error on purpose.
NEGBINOM.DISTNEGBINOM.FORDELINGThe negative binomial distribution: the chance of a number of failures before a given number of successes.
NEGBINOMDISTNEGBINOMFORDELINGThe chance of exactly a number of failures before a given number of successes. The older form of NEGBINOM.DIST.
NETWORKDAYSANTAL.ARBEJDSDAGEWorking days (Monday–Friday) between two dates, inclusive.
NETWORKDAYS.INTLANTAL.ARBEJDSDAGE.INTLWorking days between two dates, inclusive, with the weekend on days you choose.
NOMINALNOMINELThe quoted yearly rate behind an effective rate. The reverse of EFFECT.
NORM.INVNORM.INVThe value below which a given share of a normal distribution falls.
NORM.S.DISTSTANDARD.NORM.FORDELINGThe standard normal distribution (mean 0, standard deviation 1) at a z-score.
NORM.S.INVSTANDARD.NORM.INVThe z-score below which a given share of the standard normal distribution falls.
NORMDISTNORMFORDELING
NORMINVNORMINV
NORMSDISTSTANDARDNORMFORDELINGThe chance of a z-score or less in the standard normal distribution. The older form of NORM.S.DIST.
NORMSINVSTANDARDNORMINV
NOTIKKEFlips TRUE to FALSE and FALSE to TRUE.
NOWNUThe current date and time.
NPERNPERHow many payment periods are needed to pay off a loan.
NPVNUTIDSVÆRDINet present value of future cash flows at a discount rate.
NUMBERVALUETALVÆRDITurns text into a number, whatever decimal and thousands marks it uses.
OCT2BINOKT.TIL.BIN
OCT2DECOKT.TIL.DEC
OCT2HEXOKT.TIL.HEX
ODDULIGERounds away from zero to the next odd integer.
ODDFPRICEULIGE.KURS.PÅLYDENDE
ODDFYIELDULIGE.FØRSTE.AFKAST
ODDLPRICEULIGE.SIDSTE.KURS
ODDLYIELDULIGE.SIDSTE.AFKAST
OFFSETFORSKYDNINGA range a set number of rows and columns away from a starting cell, of any size.
ORELLERTRUE if at least one condition is TRUE.
PDURATIONPVARIGHEDHow many periods an investment needs to reach a target at a steady rate.
PEARSONPEARSONThe Pearson correlation coefficient, the same as CORREL.
PERCENTILEFRAKTILThe value below which a given percentage of the data falls.
PERCENTILE.EXCFRAKTIL.UDELADThe value below which a percentage of the data falls, excluding 0% and 100%.
PERCENTILE.INCFRAKTIL.MEDTAG
PERCENTRANKPROCENTPLADS
PERCENTRANK.EXCPROCENTPLADS.UDELADWhere a value stands in a list, between 0 and 1 without ever reaching either.
PERCENTRANK.INCPROCENTPLADS.MEDTAGWhere a value stands in a list, from 0 (the lowest) to 1 (the highest).
PERMUTPERMUTHow many ways to pick a number of items from a group, when the order matters.
PERMUTATIONAPERMUTATIONAThe 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.
PHONETICFONETISK
PIPIThe number π (3.14159…).
PMTYDELSEThe payment for a loan with constant payments and a constant interest rate.
POISSONPOISSON
POISSON.DISTPOISSON.FORDELINGThe chance of a number of events in a period, given how many happen on average.
POWERPOTENSRaises a number to a power (same as ^).
PPMTH.YDELSEThe principal (pay-down) part of one loan payment.
PRICEKURS
PRICEDISCKURS.DISKONTO
PRICEMATKURS.UDLØB
PROBSANDSYNLIGHEDAdds up the probabilities of the outcomes that fall between two limits.
PRODUCTPRODUKTMultiplies all the numbers together.
PROPERSTORT.FORBOGSTAVCapitalises The First Letter Of Each Word.
PVNVThe present value: what a series of future payments is worth now.
QUARTILEKVARTILA quartile of the data (0 = min, 2 = median, 4 = max).
QUARTILE.EXCKVARTIL.UDELADA quartile of the data (1, 2 or 3), using the exclusive method.
QUARTILE.INCKVARTIL.MEDTAG
QUOTIENTKVOTIENTThe whole-number part of a division.
RADIANSRADIANERTurns degrees into radians, which is what SIN, COS and TAN take.
RANDSLUMPA random number between 0 and 1. Changes on every edit.
RANDARRAYSLUMPMATRIXFills an array with random numbers.
RANDBETWEENSLUMPMELLEMA random whole number between two limits.
RANKPLADSThe position of a number in a list (1 = largest by default).
RANK.AVGPLADS.GNSNThe position of a number in a list. Tied values share the average of their positions.
RATERENTEThe interest rate per period of a loan or investment.
RECEIVEDMODTAGET.VED.UDLØB
REPLACEERSTATReplaces characters at a given position.
REPTGENTAGRepeats text a number of times.
RIGHTHØJREThe last characters of a text value.
ROMANROMERTALWrites a number in Roman numerals.
ROUNDAFRUNDRounds a number to a given number of digits.
ROUNDDOWNRUND.NEDRounds a number towards zero.
ROUNDUPRUND.OPRounds a number away from zero.
ROWRÆKKEThe row number of a reference (or of the current cell).
ROWSRÆKKERHow many rows a range has.
RRIRRIThe steady growth rate per period that turns one amount into another (CAGR).
RSQFORKLARINGSGRADR squared: the share of the variation in y that the best-fit line explains, from 0 to 1.
RTDRTD
SEARCHSØGPosition of one text inside another (not case-sensitive, allows wildcards).
SECSECThe secant of an angle: 1 divided by its cosine.
SECHSECH
SECONDSEKUNDThe second of a time (0-59).
SEQUENCESEKVENSGenerates a list of sequential numbers that spills into neighbouring cells.
SERIESSUMSERIESUMThe sum of a power series: each coefficient times x raised to a power that grows by a fixed step.
SHEETARKThe number of a sheet, counting the tabs from the left: 1 for the first.
SHEETSARK.FLEREHow many sheets the workbook has.
SIGNFORTEGN1 for positive numbers, -1 for negative, 0 for zero.
SINSINThe sine of an angle given in radians.
SINHSINHThe hyperbolic sine of a number.
SKEWSKÆVHEDSkewness: how lopsided the data are. Positive means a longer tail of high values, negative a longer tail of low values.
SKEW.PSKÆVHED.PHow lopsided a whole population is: positive when the tail runs to the right, negative when it runs to the left.
SLNLAStraight-line depreciation: the same loss of value every year.
SLOPESTIGNINGThe slope of the straight line that best fits the data: how much y changes for each 1 added to x.
SMALLMINDSTEThe k-th smallest value (k = 1 is the minimum).
SORTSORTERSorts a range. The result spills.
SORTBYSORTER.EFTERSorts a range by the values in another range.
SQRTKVRODSquare root.
SQRTPIKVRODPIThe square root of a number multiplied by π.
STANDARDIZESTANDARDISERA z-score: how many standard deviations a value is above (or below) the mean.
STDEVSTDAFVStandard deviation of a sample.
STDEV.PSTDAFV.PStandard deviation of an entire population.
STDEV.SSTDAFV.S
STDEVASTDAFVVThe standard deviation of a sample, counting text and FALSE in a range as 0 and TRUE as 1. STDEV skips them.
STDEVPSTDAFVP
STDEVPASTDAFVPVThe standard deviation of a whole population, counting text and FALSE in a range as 0 and TRUE as 1. STDEVP skips them.
STEYXSTFYXThe standard error of the regression: the typical distance of a y value from the best-fit line.
SUBSTITUTEUDSKIFTReplaces specific text with new text.
SUBTOTALSUBTOTALTotals a range, leaving out rows that a filter hides and other subtotals inside it.
SUMSUMAdds up numbers, cells and ranges.
SUMIFSUM.HVISAdds the cells that meet one condition.
SUMIFSSUM.HVISERAdds the cells that meet every one of several conditions.
SUMPRODUCTSUMPRODUKTMultiplies matching items in arrays, then adds the results.
SUMSQSUMKVAdds the squares of the numbers.
SUMX2MY2SUMX2MY2Adds up the differences of the squares of matching values in two ranges.
SUMX2PY2SUMX2PY2Adds up the sums of the squares of matching values in two ranges.
SUMXMY2SUMXMY2Adds up the squares of the differences of matching values in two ranges.
SWITCHSKIFTCompares a value against a list and returns the matching result.
SYDÅRSAFSKRIVNINGSum-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.FORDELINGStudent's t-distribution: the chance of a t of x or less, or the height of the curve at x.
T.DIST.2TT.FORDELING.2TThe 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.FORDELING.RTThe right tail of the t-distribution: the chance of a t greater than x.
T.INVT.INVThe t-value below which a given share of the t-distribution falls.
T.INV.2TT.INV.2TThe 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.TESTStudent's t-test: the chance that two samples would differ this much if they came from populations with the same mean.
TAKETAGKeeps the first or last rows or columns of an array.
TANTANThe tangent of an angle given in radians.
TANHTANHThe hyperbolic tangent of a number.
TBILLEQSTATSOBLIGATION
TBILLPRICESTATSOBLIGATION.KURS
TBILLYIELDSTATSOBLIGATION.AFKAST
TDISTTFORDELINGThe tail of the t-distribution beyond x, on one side or both. The older form of T.DIST.RT and T.DIST.2T.
TEXTTEKSTFormats a number as text using a format code.
TEXTJOINTEKST.KOMBINERJoins text with a separator between each item.
TEXTSPLITTEKSTSPLITSplits text into separate cells at a delimiter. The result spills.
TIMETIDBuilds a time from hours, minutes and seconds.
TIMEVALUETIDSVÆRDIConverts a time written as text into a fraction of a day.
TINVTINV
TOCOLTILKOLONNETurns an array into a single column.
TODAYIDAGToday's date. Updates automatically.
TOROWTILRÆKKETurns an array into a single row.
TRANSPOSETRANSPONERFlips rows into columns and columns into rows.
TRENDTENDENSValues on the best-fit straight line (least squares): fitted values for the known data, or predictions for new x values. Spills.
TRIMFJERN.OVERFLØDIGE.BLANKERemoves extra spaces, leaving single spaces between words.
TRIMMEANTRIMMIDDELVÆRDIThe average with a share of the highest and lowest values left out.
TRUNCAFKORTCuts off the decimal part of a number.
TTESTTTEST
TYPEVÆRDITYPEA number for the kind of value: 1 number, 2 text, 4 TRUE or FALSE, 16 error, 64 array.
UNICHARUNICHARThe character with a Unicode number: letters of any alphabet, symbols, emoji.
UNICODEUNICODEThe Unicode number of the first character of some text.
UNIQUEENTYDIGERemoves duplicates from a list. The result spills.
UPPERSTORE.BOGSTAVERConverts text to UPPERCASE.
VALUEVÆRDIConverts text that looks like a number into a number.
VALUETOTEXTVÆRDITILTEKSTAny value as text. Text passes through unchanged, or in quotes in the strict format.
VARVARIANSVariance of a sample.
VAR.PVARIANS.PVariance of an entire population.
VAR.SVARIANS.S
VARAVARIANSVThe variance of a sample, counting text and FALSE in a range as 0 and TRUE as 1. VAR skips them.
VARPVARIANSP
VARPAVARIANSPVThe variance of a whole population, counting text and FALSE in a range as 0 and TRUE as 1. VARP skips them.
VDBVSADepreciation between any two points in an asset’s life, by declining balance that switches to straight-line once that gives more.
VLOOKUPLOPSLAGFinds a value in the first column of a table and returns a value from the same row.
VSTACKVSTAKStacks arrays on top of each other into one taller array.
WEBSERVICEWEBTJENESTE
WEEKDAYUGEDAGThe day of the week as a number.
WEEKNUMUGE.NRThe week number of the year.
WEIBULLWEIBULL
WEIBULL.DISTWEIBULL.FORDELINGThe Weibull distribution, used for how long things last before they fail.
WORKDAYARBEJDSDAGThe date a number of working days before or after a date.
WORKDAY.INTLARBEJDSDAG.INTLThe date a number of working days before or after a date, with the weekend on days you choose.
WRAPCOLSFOLDKOLONNERWraps a row or column of values into columns of a set length.
XIRRINTERN.RENTEThe yearly rate of return for cash flows that fall on any dates.
XLOOKUPXOPSLAGSearches a range and returns the matching item from another range. The modern replacement for VLOOKUP.
XMATCHXSAMMENLIGNThe position of a value in a list, with exact match by default.
XNPVNETTO.NUTIDSVÆRDINet present value of cash flows that fall on any dates, not evenly spaced ones.
XORXELLERTRUE if an odd number of conditions are TRUE.
YEARÅRThe year of a date.
YEARFRACÅR.BRØKThe fraction of a year between two dates, using a day-count basis.
YIELDAFKAST
YIELDDISCAFKAST.DISKONTO
YIELDMATAFKAST.UDLØBSDATO
Z.TESTZ.TESTThe one-tailed z-test: the chance of a sample mean this far above a claimed population mean.
ZTESTZTEST

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