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 |