Categories
Excel function translations Danish to English
A list of all Excel function translation from Danish to English. If you’re familiar with the Danish version of Excel and you find yourself working with the English version, this list will be of use to you, because Excel functions have different names in different languages.
List of all Excel functions
translated from Danish to English
| Danish | English |
| / | LOWER |
| ABS | ABS |
| ADRESSE | ADDRESS |
| AFKAST | YIELD |
| AFKAST.DISKONTO | YIELDDISC |
| AFKAST.UDLØBSDATO | YIELDMAT |
| AFKORT | TRUNC |
| AFRUND | ROUND |
| AFRUND.BUND.MAT | FLOOR.MATH |
| AFRUND.GULV | FLOOR |
| AFRUND.GULV.PRECISE | FLOOR.PRECISE |
| AFRUND.LOFT | CEILING |
| AKKUM.HOVEDSTOL | CUMPRINC |
| AKKUM.RENTE | CUMIPMT |
| AMORDEGRC | AMORDEGRC |
| AMORLINC | AMORLINC |
| ANTAL.ARBEJDSDAGE | NETWORKDAYS |
| ANTAL.ARBEJDSDAGE.INTL | NETWORKDAYS.INTL |
| ANTAL.BLANKE | COUNTBLANK |
| ÅR | YEAR |
| ÅR.BRØK | YEARFRAC |
| ARABISK | ARABIC |
| ARBEJDSDAG | WORKDAY |
| ARBEJDSDAG.INTL | WORKDAY.INTL |
| ARCCOS | ACOS |
| ARCCOSH | ACOSH |
| ARCCOT | ACOT |
| ARCCOTH | ACOTH |
| ARCSIN | ASIN |
| ARCSINH | ASINH |
| ARCTAN | ATAN |
| ARCTAN2 | ATAN2 |
| ARCTANH | ATANH |
| ARK | SHEET |
| ARK.FLERE | SHEETS |
| ÅRSAFSKRIVNING | SYD |
| ASC | ASC |
| BAHTTEKST | BAHTTEXT |
| BASIS | BASE |
| BESSELI | BESSELI |
| BESSELJ | BESSELJ |
| BESSELK | BESSELK |
| BESSELY | BESSELY |
| BETA.FORDELING | BETA.DIST |
| BETA.INV | BETA.INV |
| BETAFORDELING | BETADIST |
| BETAINV | BETAINV |
| BIN.TIL.DEC | BIN2DEC |
| BIN.TIL.HEX | BIN2HEX |
| BIN.TIL.OKT | BIN2OCT |
| BINOMIAL.DIST.INTERVAL | BINOM.DIST.RANGE |
| BINOMIAL.FORDELING | BINOM.DIST |
| BINOMIAL.INV | BINOM.INV |
| BINOMIALFORDELING | BINOMDIST |
| BITELLER | BITOR |
| BITLSKIFT | BITLSHIFT |
| BITOG | BITAND |
| BITRSKIFT | BITRSHIFT |
| BITXELLER | BITXOR |
| CELLE | CELL |
| CHAR | CHAR |
| CHI2.FORD.RT | CHISQ.DIST.RT |
| CHI2.FORDELING | CHISQ.DIST |
| CHI2.INV | CHISQ.INV |
| CHI2.INV.RT | CHISQ.INV.RT |
| CHI2.TEST | CHISQ.TEST |
| CHIFORDELING | CHIDIST |
| CHIINV | CHIINV |
| CHITEST | CHITEST |
| COS | COS |
| COSH | COSH |
| COT | COT |
| COTH | COTH |
| CSC | CSC |
| CSCH | CSCH |
| DAG | DAY |
| DAGE | DAYS |
| DAGE360 | DAYS360 |
| DATO | DATE |
| DATOVÆRDI | DATEVALUE |
| DB | DB |
| DBCS | DBCS |
| DEC.TIL.BIN | DEC2BIN |
| DEC.TIL.HEX | DEC2HEX |
| DEC.TIL.OKT | DEC2OCT |
| DECIMAL | DECIMAL |
| DELTA | DELTA |
| DHENT | DGET |
| DISKONTO | DISC |
| DMAKS | DMAX |
| DMIDDEL | DAVERAGE |
| DMIN | DMIN |
| DOBBELT.FAKULTET | FACTDOUBLE |
| DPRODUKT | DPRODUCT |
| DSA | DDB |
| DSTDAFV | DSTDEV |
| DSTDAFVP | DSTDEVP |
| DSUM | DSUM |
| DTÆL | DCOUNT |
| DTÆLV | DCOUNTA |
| DVARIANS | DVAR |
| DVARIANSP | DVARP |
| EDATO | EDATE |
| EFFEKTIV.RENTE | EFFECT |
| EKSAKT | EXACT |
| EKSP | EXP |
| EKSP.FORDELING | EXPON.DIST |
| EKSPFORDELING | EXPONDIST |
| ELLER | OR |
| Enten-eller | XOR |
| ER.FE | ISERR |
| ER.FEJL | ISERROR |
| ER.FORMEL | ISFORMULA |
| ER.IKKE.TEKST | ISNONTEXT |
| ER.IKKE.TILGÆNGELIG | ISNA |
| ER.LIGE | ISEVEN |
| ER.LOGISK | ISLOGICAL |
| ER.REFERENCE | ISREF |
| ER.TAL | ISNUMBER |
| ER.TEKST | ISTEXT |
| ER.TOM | ISBLANK |
| ER.ULIGE | ISODD |
| ERF.PRECISE | ERF.PRECISE |
| ERFC.PRECISE | ERFC.PRECISE |
| ERSTAT, ERSTATB | REPLACE, REPLACEB |
| EUROCONVERT | EUROCONVERT |
| F.FORDELING | F.DIST |
| F.FORDELING.RT | F.DIST.RT |
| F.INV | F.INV |
| F.INV.RT | F.INV.RT |
| F.TEST | F.TEST |
| FAKULTET | FACT |
| FALSK | FALSE |
| FAST | FIXED |
| FEJLFUNK | ERF |
| FEJLFUNK.KOMP | ERFC |
| FEJLTYPE | ERROR.TYPE |
| FFORDELING | FDIST |
| FILTRERXML | FILTERXML |
| FIND, FINDB | FIND, FINDB |
| FINV | FINV |
| FISHER | FISHER |
| FISHERINV | FISHERINV |
| FJERN.OVERFLØDIGE.BLANKE | TRIM |
| FONETISK | PHONETIC |
| FORKLARINGSGRAD | RSQ |
| FORMELTEKST | FORMULATEXT |
| FORØGELSE | GROWTH |
| FORSKYDNING | OFFSET |
| FORTEGN | SIGN |
| FRAKTIL | PERCENTILE |
| FRAKTIL.MEDTAG | PERCENTILE.INC |
| FRAKTIL.UDELAD | PERCENTILE.EXC |
| FREKVENS | FREQUENCY |
| FTEST | FTEST |
| FV | FV |
| FVTABEL | FVSCHEDULE |
| GAMMA | GAMMA |
| GAMMA.FORDELING | GAMMA.DIST |
| GAMMA.INV | GAMMA.INV |
| GAMMAFORDELING | GAMMADIST |
| GAMMAINV | GAMMAINV |
| GAMMALN | GAMMALN |
| GAMMALN.PRECISE | GAMMALN.PRECISE |
| GAUSS | GAUSS |
| GENTAG | REPT |
| GEOMIDDELVÆRDI | GEOMEAN |
| GETPIVOTDATA | GETPIVOTDATA |
| GETRIN | GESTEP |
| GRADER | DEGREES |
| H.YDELSE | PPMT |
| HARMIDDELVÆRDI | HARMEAN |
| HELTAL | INT |
| HEX.TIL.BIN | HEX2BIN |
| HEX.TIL.DEC | HEX2DEC |
| HEX.TIL.OKT | HEX2OCT |
| HØJRE, HØJREB | RIGHT, RIGHTB |
| HVIS | IF |
| HVIS.FEJL | IFERROR |
| HVISIT | IFNA |
| HYPERLINK | HYPERLINK |
| HYPGEO.FORDELING | HYPGEOM.DIST |
| HYPGEOFORDELING | HYPGEOMDIST |
| HYPPIGST | MODE |
| HYPPIGST.ENKELT | MODE.SNGL |
| HYPPIGST.FLERE | MODE.MULT |
| IA | IRR |
| IDAG | TODAY |
| IKKE | NOT |
| IKKE.TILGÆNGELIG | NA |
| IMAGABS | IMABS |
| IMAGARGUMENT | IMARGUMENT |
| IMAGCOS | IMCOS |
| IMAGCOSH | IMCOSH |
| IMAGCOT | IMCOT |
| IMAGCSC | IMCSC |
| IMAGCSCH | IMCSCH |
| IMAGDIV | IMDIV |
| IMAGEKSP | IMEXP |
| IMAGINÆR | IMAGINARY |
| IMAGKONJUGERE | IMCONJUGATE |
| IMAGKVROD | IMSQRT |
| IMAGLN | IMLN |
| IMAGLOG10 | IMLOG10 |
| IMAGLOG2 | IMLOG2 |
| IMAGPOTENS | IMPOWER |
| IMAGPRODUKT | IMPRODUCT |
| IMAGREELT | IMREAL |
| IMAGSEC | IMSEC |
| IMAGSECH | IMSECH |
| IMAGSIN | IMSIN |
| IMAGSINH | IMSINH |
| IMAGSUB | IMSUB |
| IMAGSUM | IMSUM |
| IMAGTAN | IMTAN |
| INDEKS | INDEX |
| INDIREKTE | INDIRECT |
| INFO | INFO |
| INTERN.RENTE | XIRR |
| ISO.LOFT | ISO.CEILING |
| ISOUGE.NR | ISOWEEKNUM |
| ISPMT | ISPMT |
| KALD | CALL |
| KODE | CODE |
| KODNINGSURL | ENCODEURL |
| KOLONNE | COLUMN |
| KOLONNER | COLUMNS |
| KOMBIN | COMBIN |
| KOMBINA | COMBINA |
| KOMPLEKS | COMPLEX |
| KONFIDENS.NORM | CONFIDENCE.NORM |
| KONFIDENSINTERVAL | CONFIDENCE |
| KONFIDENST | CONFIDENCE.T |
| KONVERTER | CONVERT |
| KORRELATION | CORREL |
| KOVARIANS | COVAR |
| KOVARIANS.P | COVARIANCE.P |
| KOVARIANS.S | COVARIANCE.S |
| KR | DOLLAR |
| KR.BRØK | DOLLARFR |
| KR.DECIMAL | DOLLARDE |
| KRITBINOM | CRITBINOM |
| KUBE.KPI.MEDLEM | CUBEKPIMEMBER |
| KUBEMEDLEM | CUBEMEMBER |
| KUBEMEDLEM.EGENSKAB | CUBEMEMBERPROPERTY |
| KUBERANGERET.MEDLEM | CUBERANKEDMEMBER |
| KUBESÆT | CUBESET |
| KUBESÆT.ANTAL | CUBESETCOUNT |
| KUBEVÆRDI | CUBEVALUE |
| KUPONBETALINGER | COUPNUM |
| KUPONDAG.FORRIGE | COUPPCD |
| KUPONDAG.NÆSTE | COUPNCD |
| KUPONDAGE.A | COUPDAYS |
| KUPONDAGE.ANK | COUPDAYSNC |
| KUPONDAGE.SA | COUPDAYBS |
| KURS | PRICE |
| KURS.DISKONTO | PRICEDISC |
| KURS.UDLØB | PRICEMAT |
| KVARTIL | QUARTILE |
| KVARTIL.MEDTAG | QUARTILE.INC |
| KVARTIL.UDELAD | QUARTILE.EXC |
| KVOTIENT | QUOTIENT |
| KVROD | SQRT |
| KVRODPI | SQRTPI |
| LA | SLN |
| LÆNGDE, LÆNGDEB | LEN, LENB |
| LIGE | EVEN |
| LINREGR | LINEST |
| LN | LN |
| LOFT.MAT | CEILING.MATH |
| LOFT.PRECISE | CEILING.PRECISE |
| LOG | LOG |
| LOG10 | LOG10 |
| LOGINV | LOGINV |
| LOGNORM.FORDELING | LOGNORM.DIST |
| LOGNORM.INV | LOGNORM.INV |
| LOGNORMFORDELING | LOGNORMDIST |
| LOGREGR | LOGEST |
| LOPSLAG | VLOOKUP |
| MAD | AVEDEV |
| MAFRUND | MROUND |
| MAKS | MAX |
| MAKSV | MAXA |
| MÅNED | MONTH |
| MDETERM | MDETERM |
| MEDIAN | MEDIAN |
| MENHED | MUNIT |
| MIA | MIRR |
| MIDDEL | AVERAGE |
| MIDDEL.HVIS | AVERAGEIF |
| MIDDEL.HVISER | AVERAGEIFS |
| MIDDELV | AVERAGEA |
| MIDT, MIDTB | MID, MIDB |
| MIN | MIN |
| MINDSTE | SMALL |
| MINDSTE.FÆLLES.MULTIPLUM | LCM |
| MINUT | MINUTE |
| MINV | MINA |
| MINVERT | MINVERSE |
| MODTAGET.VED.UDLØB | RECEIVED |
| MPRODUKT | MMULT |
| MULTINOMIAL | MULTINOMIAL |
| MVARIGHED | MDURATION |
| NEGBINOM.FORDELING | NEGBINOM.DIST |
| NEGBINOMFORDELING | NEGBINOMDIST |
| NETTO.NUTIDSVÆRDI | XNPV |
| NOMINEL | NOMINAL |
| NORM.INV | NORM.INV |
| NORMAL.FORDELING | NORM.DIST |
| NORMFORDELING | NORMDIST |
| NORMINV | NORMINV |
| NPER | NPER |
| NU | NOW |
| NUTIDSVÆRDI | NPV |
| NV | PV |
| OG | AND |
| OKT.TIL.BIN | OCT2BIN |
| OKT.TIL.DEC | OCT2DEC |
| OKT.TIL.HEX | OCT2HEX |
| OMRÅDER | AREAS |
| Oversigt | TDIST |
| PÅLØBRENTE | ACCRINT |
| PÅLØBRENTE.UDLØB | ACCRINTM |
| PEARSON | PEARSON |
| PERMUT | PERMUT |
| PERMUTATIONA | PERMUTATIONA |
| PHI | PHI |
| PI | PI |
| PLADS | RANK |
| PLADS.GNSN | RANK.AVG |
| PLADS.LIGE | RANK.EQ |
| POISSON | POISSON |
| POISSON.FORDELING | POISSON.DIST |
| POTENS | POWER |
| PROCENTPLADS | PERCENTRANK |
| PROCENTPLADS.MEDTAG | PERCENTRANK.INC |
| PROCENTPLADS.UDELAD | PERCENTRANK.EXC |
| PRODUKT | PRODUCT |
| PROGNOSE | FORECAST |
| PVARIGHED | PDURATION |
| R.YDELSE | IPMT |
| RADIANER | RADIANS |
| RÆKKE | ROW |
| RÆKKER | ROWS |
| REGISTER.ID | REGISTER.ID |
| RENS | CLEAN |
| RENTE | RATE |
| RENTEFOD | INTRATE |
| REST | MOD |
| ROMERTAL | ROMAN |
| RRI | RRI |
| RTD | RTD |
| RUND.NED | ROUNDDOWN |
| RUND.OP | ROUNDUP |
| SAK | DEVSQ |
| SAMLING | AGGREGATE |
| SAMMENKÆDNING | CONCATENATE |
| SAMMENLIGN | MATCH |
| SAND | TRUE |
| SANDSYNLIGHED | PROB |
| SEC | SEC |
| SECH | SECH |
| sekund | SECOND |
| SERIESUM | SERIESSUM |
| SIN | SIN |
| SINH | SINH |
| SKÆRING | INTERCEPT |
| SKÆVHED | SKEW |
| SKÆVHED.P | SKEW.P |
| SLÅ.OP | LOOKUP |
| SLUMP | RAND |
| SLUMPMELLEM | RANDBETWEEN |
| SLUT.PÅ.MÅNED | EOMONTH |
| SØG, SØGB | SEARCH, SEARCHB |
| SQL.REQUEST | SQL.REQUEST |
| STANDARD.NORM.FORDELING | NORM.S.DIST |
| STANDARD.NORM.INV | NORM.S.INV |
| STANDARDISER | STANDARDIZE |
| STANDARDNORMFORDELING | NORMSDIST |
| STANDARDNORMINV | NORMSINV |
| STATSOBLIGATION | TBILLEQ |
| STATSOBLIGATION.AFKAST | TBILLYIELD |
| STATSOBLIGATION.KURS | TBILLPRICE |
| STDAFV | STDEV |
| STDAFV.P | STDEV.P |
| STDAFV.S | STDEV.S |
| STDAFVP | STDEVP |
| STDAFVPV | STDEVPA |
| STDAFVV | STDEVA |
| STFYX | STEYX |
| STIGNING | SLOPE |
| STORE.BOGSTAVER | UPPER |
| STØRSTE | LARGE |
| STØRSTE.FÆLLES.DIVISOR | GCD |
| STORT.FORBOGSTAV | PROPER |
| SUBTOTAL | SUBTOTAL |
| SUM | SUM |
| SUM.HVIS | SUMIF |
| SUM.HVISER | SUMIFS |
| SUMKV | SUMSQ |
| SUMPRODUKT | SUMPRODUCT |
| SUMX2MY2 | SUMX2MY2 |
| SUMX2PY2 | SUMX2PY2 |
| SUMXMY2 | SUMXMY2 |
| T | T |
| T.FORDELING | T.DIST |
| T.FORDELING.2T | T.DIST.2T |
| T.FORDELING.RT | T.DIST.RT |
| T.INV | T.INV |
| T.INV.2T | T.INV.2T |
| T.TEST | T.TEST |
| TÆL | COUNT |
| TÆL.HVIS | COUNTIF |
| TÆL.HVISER | COUNTIFS |
| TÆLV | COUNTA |
| TAL | N |
| TALVÆRDI | NUMBERVALUE |
| TAN | TAN |
| TANH | TANH |
| TEKST | TEXT |
| TENDENS | TREND |
| TID | TIME |
| TIDSVÆRDI | TIMEVALUE |
| TIME | HOUR |
| TINV | TINV |
| TOPSTEJL | KURT |
| TRANSPONER | TRANSPOSE |
| TRIMMIDDELVÆRDI | TRIMMEAN |
| TTEST | TTEST |
| UDSKIFT | SUBSTITUTE |
| UGE.NR | WEEKNUM |
| UGEDAG | WEEKDAY |
| ULIGE | ODD |
| ULIGE.FØRSTE.AFKAST | ODDFYIELD |
| ULIGE.KURS.PÅLYDENDE | ODDFPRICE |
| ULIGE.SIDSTE.AFKAST | ODDLYIELD |
| ULIGE.SIDSTE.KURS | ODDLPRICE |
| UNICHAR | UNICHAR |
| UNICODE | UNICODE |
| VÆLG | CHOOSE |
| VÆRDI | VALUE |
| VÆRDITYPE | TYPE |
| VARIANS | VAR |
| VARIANS.P | VAR.P |
| VARIANS.S | VAR.S |
| VARIANSP | VARP |
| VARIANSPV | VARPA |
| VARIANSV | VARA |
| VARIGHED | DURATION |
| VENSTRE, VENSTREB | LEFT, LEFTB |
| VOPSLAG | HLOOKUP |
| VSA | VDB |
| WEBTJENESTE | WEBSERVICE |
| WEIBULL | WEIBULL |
| WEIBULL.FORDELING | WEIBULL.DIST |
| XOPSLAG | XLOOKUP |
| YDELSE | PMT |
| Z.TEST | Z.TEST |
| ZTEST | ZTEST |