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