---
title: "Excel Function Names in Danish and English | PracticeExcel"
description: "The English and Danish names of 112 Excel functions, from SUM and IF to VLOOKUP (LOPSLAG) and SUMIF (SUM.HVIS), with syntax, examples and exercises for each."
canonical_url: "https://practiceexcelonline.com/functions/english-danish"
locale: en
meta:
"og:description": "The English and Danish names of 112 Excel functions, from SUM and IF to VLOOKUP (LOPSLAG) and SUMIF (SUM.HVIS), with syntax, examples and exercises for each."
"og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_Excel%2BFunction%2BNames%2Bin%2BDanish%2Band%2BEnglish%2Cdescription_~VGhlIEVuZ2xpc2ggYW5kIERhbmlzaCBuYW1lcyBvZiAxMTIgRXhjZWwgZnVuY3Rpb25zLCBmcm9tIFNVTSBhbmQgSUYgdG8gVkxPT0tVUCAoTE9QU0xBRykgYW5kIFNVTUlGIChTVU0uSFZJUyksIHdpdGggc3ludGF4LCBleGFtcGxlcyBhbmQgZXhlcmNpc2VzIGZvciBlYWNoLg%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Cp_Ii9mdW5jdGlvbnMvZW5nbGlzaC1kYW5pc2gi%2Cs_UKxg_oGN4yFJ7d_N.png"
"og:image:height": "600"
"og:image:type": image/png
"og:image:width": "1200"
"og:title": "Excel Function Names in Danish and English | PracticeExcel"
"twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_Excel%2BFunction%2BNames%2Bin%2BDanish%2Band%2BEnglish%2Cdescription_~VGhlIEVuZ2xpc2ggYW5kIERhbmlzaCBuYW1lcyBvZiAxMTIgRXhjZWwgZnVuY3Rpb25zLCBmcm9tIFNVTSBhbmQgSUYgdG8gVkxPT0tVUCAoTE9QU0xBRykgYW5kIFNVTUlGIChTVU0uSFZJUyksIHdpdGggc3ludGF4LCBleGFtcGxlcyBhbmQgZXhlcmNpc2VzIGZvciBlYWNoLg%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Cp_Ii9mdW5jdGlvbnMvZW5nbGlzaC1kYW5pc2gi%2Cs_UKxg_oGN4yFJ7d_N.png"
---
> Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt)
# **Excel function names in Danish and English**
Danish Excel translates function names, so VLOOKUP is LOPSLAG and SUMIF is SUM.HVIS. Here are the English and Danish names of the 112 functions with a page on PracticeExcel. Click a name for its syntax, examples and exercises.
=
LOPSLAGVLOOKUP;
| **English** | **Danish** |
| --- | --- |
| [ABS](https://practiceexcelonline.com/functions/abs) | ABS |
| [AND](https://practiceexcelonline.com/functions/and) | OG |
| [AVERAGE](https://practiceexcelonline.com/functions/average) | MIDDEL |
| [AVERAGEIF](https://practiceexcelonline.com/functions/averageif) | MIDDEL.HVIS |
| [AVERAGEIFS](https://practiceexcelonline.com/functions/averageifs) | MIDDEL.HVISER |
| [CEILING.MATH](https://practiceexcelonline.com/functions/ceiling-math) | LOFT.MAT |
| [CHAR](https://practiceexcelonline.com/functions/char) | TEGN |
| [CHOOSE](https://practiceexcelonline.com/functions/choose) | VÆLG |
| [COLUMN](https://practiceexcelonline.com/functions/column) | KOLONNE |
| [CONCAT](https://practiceexcelonline.com/functions/concat) | SAMMENKÆDNING |
| [CONCATENATE](https://practiceexcelonline.com/functions/concatenate) | SAMMENKÆDE |
| [CORREL](https://practiceexcelonline.com/functions/correl) | KORRELATION |
| [COUNT](https://practiceexcelonline.com/functions/count) | TÆL |
| [COUNTA](https://practiceexcelonline.com/functions/counta) | TÆLV |
| [COUNTBLANK](https://practiceexcelonline.com/functions/countblank) | ANTAL.BLANKE |
| [COUNTIF](https://practiceexcelonline.com/functions/countif) | TÆL.HVIS |
| [COUNTIFS](https://practiceexcelonline.com/functions/countifs) | TÆL.HVISER |
| [DATE](https://practiceexcelonline.com/functions/date) | DATO |
| [DATEDIF](https://practiceexcelonline.com/functions/datedif) | DATO.FORSKEL |
| [DATEVALUE](https://practiceexcelonline.com/functions/datevalue) | DATOVÆRDI |
| [DAY](https://practiceexcelonline.com/functions/day) | DAG |
| [DAYS](https://practiceexcelonline.com/functions/days) | DAGE |
| [EDATE](https://practiceexcelonline.com/functions/edate) | EDATO |
| [EOMONTH](https://practiceexcelonline.com/functions/eomonth) | SLUT.PÅ.MÅNED |
| [FILTER](https://practiceexcelonline.com/functions/filter) | FILTRER |
| [FIND](https://practiceexcelonline.com/functions/find) | FIND |
| [FV](https://practiceexcelonline.com/functions/fv) | FV |
| [HLOOKUP](https://practiceexcelonline.com/functions/hlookup) | VOPSLAG |
| [HOUR](https://practiceexcelonline.com/functions/hour) | TIME |
| [IF](https://practiceexcelonline.com/functions/if) | HVIS |
| [IFERROR](https://practiceexcelonline.com/functions/iferror) | HVIS.FEJL |
| [IFNA](https://practiceexcelonline.com/functions/ifna) | HVISIT |
| [IFS](https://practiceexcelonline.com/functions/ifs) | HVISER |
| [INDEX](https://practiceexcelonline.com/functions/index) | INDEKS |
| [INDIRECT](https://practiceexcelonline.com/functions/indirect) | INDIREKTE |
| [INT](https://practiceexcelonline.com/functions/int) | HELTAL |
| [IRR](https://practiceexcelonline.com/functions/irr) | IA |
| [ISBLANK](https://practiceexcelonline.com/functions/isblank) | ER.TOM |
| [ISERROR](https://practiceexcelonline.com/functions/iserror) | ER.FEJL |
| [ISNA](https://practiceexcelonline.com/functions/isna) | ER.IKKE.TILGÆNGELIG |
| [ISNUMBER](https://practiceexcelonline.com/functions/isnumber) | ER.TAL |
| [ISTEXT](https://practiceexcelonline.com/functions/istext) | ER.TEKST |
| [LARGE](https://practiceexcelonline.com/functions/large) | STØRSTE |
| [LEFT](https://practiceexcelonline.com/functions/left) | VENSTRE |
| [LEN](https://practiceexcelonline.com/functions/len) | LÆNGDE |
| [LOOKUP](https://practiceexcelonline.com/functions/lookup) | SLÅ.OP |
| [LOWER](https://practiceexcelonline.com/functions/lower) | SMÅ.BOGSTAVER |
| [MATCH](https://practiceexcelonline.com/functions/match) | SAMMENLIGN |
| [MAX](https://practiceexcelonline.com/functions/max) | MAKS |
| [MEDIAN](https://practiceexcelonline.com/functions/median) | MEDIAN |
| [MID](https://practiceexcelonline.com/functions/mid) | MIDT |
| [MIN](https://practiceexcelonline.com/functions/min) | MIN |
| [MOD](https://practiceexcelonline.com/functions/mod) | REST |
| [MODE](https://practiceexcelonline.com/functions/mode) | HYPPIGST |
| [MONTH](https://practiceexcelonline.com/functions/month) | MÅNED |
| [NETWORKDAYS](https://practiceexcelonline.com/functions/networkdays) | ANTAL.ARBEJDSDAGE |
| [NOT](https://practiceexcelonline.com/functions/not) | IKKE |
| [NOW](https://practiceexcelonline.com/functions/now) | NU |
| [NPER](https://practiceexcelonline.com/functions/nper) | NPER |
| [NPV](https://practiceexcelonline.com/functions/npv) | NUTIDSVÆRDI |
| [OFFSET](https://practiceexcelonline.com/functions/offset) | FORSKYDNING |
| [OR](https://practiceexcelonline.com/functions/or) | ELLER |
| [PERCENTILE.INC](https://practiceexcelonline.com/functions/percentile-inc) | FRAKTIL.MEDTAG |
| [PMT](https://practiceexcelonline.com/functions/pmt) | YDELSE |
| [POWER](https://practiceexcelonline.com/functions/power) | POTENS |
| [PRODUCT](https://practiceexcelonline.com/functions/product) | PRODUKT |
| [PROPER](https://practiceexcelonline.com/functions/proper) | STORT.FORBOGSTAV |
| [PV](https://practiceexcelonline.com/functions/pv) | NV |
| [RAND](https://practiceexcelonline.com/functions/rand) | SLUMP |
| [RANDBETWEEN](https://practiceexcelonline.com/functions/randbetween) | SLUMPMELLEM |
| [RANK](https://practiceexcelonline.com/functions/rank) | PLADS |
| [RATE](https://practiceexcelonline.com/functions/rate) | RENTE |
| [REPLACE](https://practiceexcelonline.com/functions/replace) | ERSTAT |
| [RIGHT](https://practiceexcelonline.com/functions/right) | HØJRE |
| [ROUND](https://practiceexcelonline.com/functions/round) | AFRUND |
| [ROUNDDOWN](https://practiceexcelonline.com/functions/rounddown) | RUND.NED |
| [ROUNDUP](https://practiceexcelonline.com/functions/roundup) | RUND.OP |
| [ROW](https://practiceexcelonline.com/functions/row) | RÆKKE |
| [SEARCH](https://practiceexcelonline.com/functions/search) | SØG |
| [SEQUENCE](https://practiceexcelonline.com/functions/sequence) | SEKVENS |
| [SMALL](https://practiceexcelonline.com/functions/small) | MINDSTE |
| [SORT](https://practiceexcelonline.com/functions/sort) | SORTER |
| [SORTBY](https://practiceexcelonline.com/functions/sortby) | SORTER.EFTER |
| [SQRT](https://practiceexcelonline.com/functions/sqrt) | KVROD |
| [STDEV.P](https://practiceexcelonline.com/functions/stdev-p) | STDAFV.P |
| [STDEV.S](https://practiceexcelonline.com/functions/stdev-s) | STDAFV.S |
| [SUBSTITUTE](https://practiceexcelonline.com/functions/substitute) | UDSKIFT |
| [SUM](https://practiceexcelonline.com/functions/sum) | SUM |
| [SUMIF](https://practiceexcelonline.com/functions/sumif) | SUM.HVIS |
| [SUMIFS](https://practiceexcelonline.com/functions/sumifs) | SUM.HVISER |
| [SUMPRODUCT](https://practiceexcelonline.com/functions/sumproduct) | SUMPRODUKT |
| [SWITCH](https://practiceexcelonline.com/functions/switch) | SKIFT |
| [TEXT](https://practiceexcelonline.com/functions/text) | TEKST |
| [TEXTAFTER](https://practiceexcelonline.com/functions/textafter) | TEKSTEFTER |
| [TEXTBEFORE](https://practiceexcelonline.com/functions/textbefore) | TEKSTFØR |
| [TEXTJOIN](https://practiceexcelonline.com/functions/textjoin) | TEKST.KOMBINER |
| [TEXTSPLIT](https://practiceexcelonline.com/functions/textsplit) | TEKSTSPLIT |
| [TIME](https://practiceexcelonline.com/functions/time) | TID |
| [TODAY](https://practiceexcelonline.com/functions/today) | IDAG |
| [TRANSPOSE](https://practiceexcelonline.com/functions/transpose) | TRANSPONER |
| [TRIM](https://practiceexcelonline.com/functions/trim) | FJERN.OVERFLØDIGE.BLANKE |
| [TRUNC](https://practiceexcelonline.com/functions/trunc) | AFKORT |
| [UNIQUE](https://practiceexcelonline.com/functions/unique) | ENTYDIGE |
| [UPPER](https://practiceexcelonline.com/functions/upper) | STORE.BOGSTAVER |
| [VALUE](https://practiceexcelonline.com/functions/value) | VÆRDI |
| [VLOOKUP](https://practiceexcelonline.com/functions/vlookup) | LOPSLAG |
| [WEEKDAY](https://practiceexcelonline.com/functions/weekday) | UGEDAG |
| [WEEKNUM](https://practiceexcelonline.com/functions/weeknum) | UGE.NR |
| [WORKDAY](https://practiceexcelonline.com/functions/workday) | ARBEJDSDAG |
| [XLOOKUP](https://practiceexcelonline.com/functions/xlookup) | XOPSLAG |
| [XMATCH](https://practiceexcelonline.com/functions/xmatch) | XSAMMENLIGN |
| [YEAR](https://practiceexcelonline.com/functions/year) | ÅR |
## **Semicolons, commas and decimals**
Danish Excel separates arguments with semicolons and uses a comma as the decimal separator, so =ROUND(A1,2) in English Excel is =AFRUND(A1;2) in Danish Excel. Excel translates function names itself when a workbook moves between languages, so a colleague's workbook just works. A formula you paste in as text has to use the names of the Excel you paste it into, or it shows #NAME?.
## **Questions**
### What is VLOOKUP called in Danish Excel?
VLOOKUP is called LOPSLAG in Danish Excel, where the arguments are separated by semicolons: LOPSLAG(opslagsværdi; tabelmatrix; kolonneindeks\_nr; \[lig\_med]).
### What is XLOOKUP called in Danish Excel?
XLOOKUP is called XOPSLAG in Danish Excel, where the arguments are separated by semicolons: XOPSLAG(opslagsværdi; opslagsmatrix; returmatrix; \[hvis\_ikke\_fundet]; \[matchtilstand]; \[søgetilstand]).
### What is IF called in Danish Excel?
IF is called HVIS in Danish Excel, where the arguments are separated by semicolons: HVIS(logisk\_test; \[værdi\_hvis\_sand]; \[værdi\_hvis\_falsk]).
### What is SUMIF called in Danish Excel?
SUMIF is called SUM.HVIS in Danish Excel, where the arguments are separated by semicolons: SUM.HVIS(område; kriterier; \[sum\_område]).
### What is COUNTIF called in Danish Excel?
COUNTIF is called TÆL.HVIS in Danish Excel, where the arguments are separated by semicolons: TÆL.HVIS(område; kriterier).
### What is IFERROR called in Danish Excel?
IFERROR is called HVIS.FEJL in Danish Excel, where the arguments are separated by semicolons: HVIS.FEJL(værdi; værdi\_hvis\_fejl).
### What is INDEX called in Danish Excel?
INDEX is called INDEKS in Danish Excel, where the arguments are separated by semicolons: INDEKS(matrix; række\_nr; \[kol\_nr]).
### What is MATCH called in Danish Excel?
MATCH is called SAMMENLIGN in Danish Excel, where the arguments are separated by semicolons: SAMMENLIGN(opslagsværdi; opslagsmatrix; \[sammenligningstype]).
```json
{"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/functions/english-danish#webpage","description":"The English and Danish names of 112 Excel functions, from SUM and IF to VLOOKUP (LOPSLAG) and SUMIF (SUM.HVIS), with syntax, examples and exercises for each.","name":"Excel Function Names in Danish and English","url":"https://practiceexcelonline.com/functions/english-danish","@type":["WebPage","CollectionPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/functions/english-danish#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/functions/english-danish#/schema/question/1"},{"@id":"https://practiceexcelonline.com/functions/english-danish#/schema/question/2"},{"@id":"https://practiceexcelonline.com/functions/english-danish#/schema/question/3"},{"@id":"https://practiceexcelonline.com/functions/english-danish#/schema/question/4"},{"@id":"https://practiceexcelonline.com/functions/english-danish#/schema/question/5"},{"@id":"https://practiceexcelonline.com/functions/english-danish#/schema/question/6"},{"@id":"https://practiceexcelonline.com/functions/english-danish#/schema/question/7"},{"@id":"https://practiceexcelonline.com/functions/english-danish#/schema/question/8"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/functions/english-danish"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/functions/english-danish#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel functions","item":"https://practiceexcelonline.com/functions","position":2},{"@type":"ListItem","name":"Excel Function Names in Danish and English","position":3}]},{"@id":"https://practiceexcelonline.com/functions/english-danish#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"What is VLOOKUP called in Danish Excel?","acceptedAnswer":{"@type":"Answer","text":"VLOOKUP is called LOPSLAG in Danish Excel, where the arguments are separated by semicolons: LOPSLAG(opslagsværdi; tabelmatrix; kolonneindeks_nr; [lig_med])."}},{"@id":"https://practiceexcelonline.com/functions/english-danish#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"What is XLOOKUP called in Danish Excel?","acceptedAnswer":{"@type":"Answer","text":"XLOOKUP is called XOPSLAG in Danish Excel, where the arguments are separated by semicolons: XOPSLAG(opslagsværdi; opslagsmatrix; returmatrix; [hvis_ikke_fundet]; [matchtilstand]; [søgetilstand])."}},{"@id":"https://practiceexcelonline.com/functions/english-danish#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"What is IF called in Danish Excel?","acceptedAnswer":{"@type":"Answer","text":"IF is called HVIS in Danish Excel, where the arguments are separated by semicolons: HVIS(logisk_test; [værdi_hvis_sand]; [værdi_hvis_falsk])."}},{"@id":"https://practiceexcelonline.com/functions/english-danish#/schema/question/4","@type":"Question","inLanguage":"en-US","name":"What is SUMIF called in Danish Excel?","acceptedAnswer":{"@type":"Answer","text":"SUMIF is called SUM.HVIS in Danish Excel, where the arguments are separated by semicolons: SUM.HVIS(område; kriterier; [sum_område])."}},{"@id":"https://practiceexcelonline.com/functions/english-danish#/schema/question/5","@type":"Question","inLanguage":"en-US","name":"What is COUNTIF called in Danish Excel?","acceptedAnswer":{"@type":"Answer","text":"COUNTIF is called TÆL.HVIS in Danish Excel, where the arguments are separated by semicolons: TÆL.HVIS(område; kriterier)."}},{"@id":"https://practiceexcelonline.com/functions/english-danish#/schema/question/6","@type":"Question","inLanguage":"en-US","name":"What is IFERROR called in Danish Excel?","acceptedAnswer":{"@type":"Answer","text":"IFERROR is called HVIS.FEJL in Danish Excel, where the arguments are separated by semicolons: HVIS.FEJL(værdi; værdi_hvis_fejl)."}},{"@id":"https://practiceexcelonline.com/functions/english-danish#/schema/question/7","@type":"Question","inLanguage":"en-US","name":"What is INDEX called in Danish Excel?","acceptedAnswer":{"@type":"Answer","text":"INDEX is called INDEKS in Danish Excel, where the arguments are separated by semicolons: INDEKS(matrix; række_nr; [kol_nr])."}},{"@id":"https://practiceexcelonline.com/functions/english-danish#/schema/question/8","@type":"Question","inLanguage":"en-US","name":"What is MATCH called in Danish Excel?","acceptedAnswer":{"@type":"Answer","text":"MATCH is called SAMMENLIGN in Danish Excel, where the arguments are separated by semicolons: SAMMENLIGN(opslagsværdi; opslagsmatrix; [sammenligningstype])."}},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"}]}
```
## Sitemap
See the full [sitemap](https://practiceexcelonline.com/sitemap.md) for all pages.