Excel functions

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 ExcelSavvy. Click a name for its syntax, examples and exercises.

EnglishDanishPractice
ABSABS
ANDOGPractice
AVERAGEMIDDELPractice
AVERAGEIFMIDDEL.HVISPractice
AVERAGEIFSMIDDEL.HVISERPractice
CEILING.MATHLOFT.MAT
CHARTEGN
CHOOSEVÆLG
COLUMNKOLONNE
CONCATSAMMENKÆDNING
CONCATENATESAMMENKÆDE
CORRELKORRELATION
COUNTTÆLPractice
COUNTATÆLVPractice
COUNTBLANKANTAL.BLANKEPractice
COUNTIFTÆL.HVISPractice
COUNTIFSTÆL.HVISERPractice
DATEDATO
DATEDIFDATO.FORSKELPractice
DATEVALUEDATOVÆRDI
DAYDAGPractice
DAYSDAGE
EDATEEDATOPractice
EOMONTHSLUT.PÅ.MÅNEDPractice
FILTERFILTRERPractice
FINDFIND
FVFVPractice
HLOOKUPVOPSLAG
HOURTIME
IFHVISPractice
IFERRORHVIS.FEJLPractice
IFNAHVISITPractice
IFSHVISERPractice
INDEXINDEKSPractice
INDIRECTINDIREKTE
INTHELTAL
IRRIAPractice
ISBLANKER.TOM
ISERRORER.FEJL
ISNAER.IKKE.TILGÆNGELIG
ISNUMBERER.TALPractice
ISTEXTER.TEKST
LARGESTØRSTEPractice
LEFTVENSTREPractice
LENLÆNGDEPractice
LOOKUPSLÅ.OP
LOWERSMÅ.BOGSTAVER
MATCHSAMMENLIGNPractice
MAXMAKSPractice
MEDIANMEDIAN
MIDMIDT
MINMINPractice
MODREST
MODEHYPPIGST
MONTHMÅNEDPractice
NETWORKDAYSANTAL.ARBEJDSDAGE
NOTIKKE
NOWNU
NPERNPERPractice
NPVNUTIDSVÆRDIPractice
OFFSETFORSKYDNING
ORELLERPractice
PERCENTILE.INCFRAKTIL.MEDTAG
PMTYDELSEPractice
POWERPOTENS
PRODUCTPRODUKT
PROPERSTORT.FORBOGSTAVPractice
PVNV
RANDSLUMP
RANDBETWEENSLUMPMELLEM
RANKPLADS
RATERENTE
REPLACEERSTAT
RIGHTHØJREPractice
ROUNDAFRUNDPractice
ROUNDDOWNRUND.NEDPractice
ROUNDUPRUND.OPPractice
ROWRÆKKE
SEARCHSØG
SEQUENCESEKVENS
SMALLMINDSTE
SORTSORTERPractice
SORTBYSORTER.EFTER
SQRTKVROD
STDEV.PSTDAFV.P
STDEV.SSTDAFV.S
SUBSTITUTEUDSKIFTPractice
SUMSUMPractice
SUMIFSUM.HVISPractice
SUMIFSSUM.HVISERPractice
SUMPRODUCTSUMPRODUKTPractice
SWITCHSKIFT
TEXTTEKST
TEXTAFTERTEKSTEFTERPractice
TEXTBEFORETEKSTFØRPractice
TEXTJOINTEKST.KOMBINER
TEXTSPLITTEKSTSPLIT
TIMETID
TODAYIDAG
TRANSPOSETRANSPONER
TRIMFJERN.OVERFLØDIGE.BLANKEPractice
TRUNCAFKORT
UNIQUEENTYDIGEPractice
UPPERSTORE.BOGSTAVERPractice
VALUEVÆRDI
VLOOKUPLOPSLAGPractice
WEEKDAYUGEDAGPractice
WEEKNUMUGE.NR
WORKDAYARBEJDSDAGPractice
XLOOKUPXOPSLAGPractice
XMATCHXSAMMENLIGN
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]).