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.

English	Danish	What it does
ABS	ABS	Returns the absolute value of a number, the number without its sign. -25 becomes 25 and 25 stays 25.
AND	OG	Returns TRUE only when every condition is TRUE. Usually used as the test inside IF.
AVERAGE	MIDDEL	Returns the mean: the sum of the numbers divided by how many there are. Blank cells and text are skipped.
AVERAGEIF	MIDDEL.HVIS	Returns the average of the cells that meet one condition.
AVERAGEIFS	MIDDEL.HVISER	Returns the average of the cells that meet every one of several conditions. The average range comes first.
CEILING.MATH	LOFT.MAT	Rounds a number up to the nearest multiple you choose, such as the next 5, 10 or 0.25. Without a multiple it rounds up to the next whole number.
CHAR	TEGN	Returns the character for a code number. CHAR(65) is A, and CHAR(10) is a line break, the usual way to put line breaks into a formula.
CHOOSE	VÆLG	Returns the value at a numbered position in a list of arguments.
COLUMN	KOLONNE	Returns the column number of a cell, 1 for A, 2 for B and 27 for AA. Left empty, it returns the column of the cell the formula is in.
CONCAT	SAMMENKÆDNING	Joins texts and ranges into one text. The & operator does the same for single cells.
CONCATENATE	SAMMENKÆDE	Joins up to 255 texts into one. In Excel it takes single cells, not ranges; CONCAT and the & operator do the same job in new sheets.
CORREL	KORRELATION	Returns the correlation coefficient of two ranges, from -1 to 1. Close to 1 means the two rise together, close to -1 that one falls as the other rises, and close to 0 no straight-line link.
COUNT	TÆL	Counts the cells that hold numbers (dates count too). Text, blanks and errors are not counted.
COUNTA	TÆLV	Counts the cells that are not empty: numbers, text, logical values and errors.
COUNTBLANK	ANTAL.BLANKE	Counts the empty cells in a range. A formula that returns "" also counts as empty.
COUNTIF	TÆL.HVIS	Counts the cells in a range that meet one condition. Text conditions ignore upper and lower case.
COUNTIFS	TÆL.HVISER	Counts the rows that meet every one of several conditions. Use the same range twice to count between two limits.
DATE	DATO	Builds a date from a year, month and day. Months and days outside the normal range roll over: month 14 is February next year.
DATEDIF	DATO.FORSKEL	Counts the whole years, months or days between two dates, which is how you work out an age or a length of service. Excel leaves it out of the function list, but it works.
DATEVALUE	DATOVÆRDI	Converts a date written as text, such as "2024-03-15", into a date serial number Excel can calculate with and format.
DAY	DAG	Returns the day of the month of a date, a number from 1 to 31.
DAYS	DAGE	Returns the number of days between two dates. The end date comes first, and the result is the same as subtracting the start date from the end date.
EDATE	EDATO	Returns the same day a number of months before or after a date. In a shorter month it stops at the last day, so one month after Jan 31, 2024 is Feb 29.
EOMONTH	SLUT.PÅ.MÅNED	Returns the last day of the month a number of months before or after a date. 0 gives the end of the same month.
FILTER	FILTRER	Returns the rows of a range that meet a condition, as a list that spills into the cells below.
FIND	FIND	Returns the position of one text inside another. FIND is case-sensitive and does not allow wildcards; it returns #VALUE! when nothing is found.
FV	FV	Returns the future value of an investment with equal regular payments and a fixed interest rate. Money you pay in is negative, so the result is positive.
HLOOKUP	VOPSLAG	Looks for a value in the first row of a table and returns the value from another row in the same column.
HOUR	TIME	Returns the hour of a time as a number from 0 to 23. Times are fractions of a day, so 0.75 is 6:00 PM and HOUR(0.75) is 18.
IF	HVIS	Returns one value when a test is TRUE and another when it is FALSE. Put text results in double quotes.
IFERROR	HVIS.FEJL	Returns a value you choose when a formula gives any error, and the formula result otherwise.
IFNA	HVISIT	Returns a value you choose when a formula gives #N/A, and the formula result otherwise. Other errors still show.
IFS	HVISER	Checks several conditions in order and returns the value for the first one that is TRUE. Use TRUE as the last test for "everything else".
INDEX	INDEKS	Returns the value at a given row and column position in a range. Paired with MATCH it becomes a lookup in any direction.
INDIRECT	INDIREKTE	Turns text into a cell reference, such as "B3" or "Sheet2!A1", and returns what is in that cell. Use it to build a reference from other cells.
INT	HELTAL	Rounds a number down to the nearest whole number. Negative numbers go further from zero: INT(-7.9) is -8.
IRR	IA	Returns the internal rate of return of a series of cash flows, the discount rate at which their net present value is 0.
ISBLANK	ER.TOM	Returns TRUE when a cell is empty. A cell with a formula that returns "" is not empty.
ISERROR	ER.FEJL	Returns TRUE if a value is any error, such as
ISNA	ER.IKKE.TILGÆNGELIG	Returns TRUE if a value is the
ISNUMBER	ER.TAL	Returns TRUE if a value is a number and FALSE for anything else, including text that only looks like a number. Dates and times are numbers too.
ISTEXT	ER.TEKST	Returns TRUE if a value is text and FALSE otherwise. Numbers stored as text count as text; empty cells do not.
LARGE	STØRSTE	Returns the k-th largest value in a range: k = 1 is the maximum, k = 2 the runner-up.
LEFT	VENSTRE	Returns the first characters of a text. Without num_chars it returns one character.
LEN	LÆNGDE	Returns the number of characters in a text, spaces included.
LOOKUP	SLÅ.OP	Looks up a value in one row or column and returns the value in the same position from another. It always does an approximate match, so the lookup range must be sorted from smallest to largest.
LOWER	SMÅ.BOGSTAVER	Converts text to small letters.
MATCH	SAMMENLIGN	Returns the position of a value in a row or column. Use 0 as match_type for an exact match.
MAX	MAKS	Returns the largest number. Text and blank cells in a range are ignored.
MEDIAN	MEDIAN	Returns the middle value of a set of numbers. With an even count it averages the two in the middle.
MID	MIDT	Returns a number of characters from the middle of a text, starting at a given position.
MIN	MIN	Returns the smallest number. Text and blank cells in a range are ignored.
MOD	REST	Returns the remainder after division. The result has the same sign as the divisor.
MODE	HYPPIGST	Returns the number that appears most often in a range. If no number repeats, it returns
MONTH	MÅNED	Returns the month of a date as a number from 1 (January) to 12 (December).
NETWORKDAYS	ANTAL.ARBEJDSDAGE	Counts the working days (Monday to Friday) between two dates, both included, minus any holidays you list.
NOT	IKKE	Reverses a logical value: TRUE becomes FALSE and FALSE becomes TRUE.
NOW	NU	Returns the current date and time. It updates every time the sheet recalculates, so it is a live clock, not a timestamp.
NPER	NPER	Returns how many payment periods it takes to pay off a loan, or to reach a savings goal, with fixed payments and a fixed interest rate.
NPV	NUTIDSVÆRDI	Returns the net present value of future cash flows at a discount rate. The first value is discounted one period, so a payment made today is added outside NPV.
OFFSET	FORSKYDNING	Returns a reference a number of rows and columns away from a starting cell, optionally a whole range of a given height and width. Wrap it in SUM or AVERAGE to work with that range.
OR	ELLER	Returns TRUE when at least one condition is TRUE.
PERCENTILE.INC	FRAKTIL.MEDTAG	Returns the value below which a given share of the data falls, such as the 90th percentile. The share k is a fraction from 0 to 1.
PMT	YDELSE	Returns the payment per period on a loan with a fixed interest rate, paid off in equal payments. The result is negative because it is money going out.
POWER	POTENS	Raises a number to a power. POWER(2,3) is 2×2×2, which is 8, the same as =2^3.
PRODUCT	PRODUKT	Multiplies all the numbers you give it, ranges included. Empty cells and text in a range are skipped.
PROPER	STORT.FORBOGSTAV	Capitalizes the first letter of each word and makes the rest small.
PV	NV	Returns the present value, what a series of equal future payments, or one future amount, is worth today at a given interest rate.
RAND	SLUMP	Returns a random decimal number from 0 up to, but not including, 1. It changes every time the sheet recalculates.
RANDBETWEEN	SLUMPMELLEM	Returns a random whole number between a bottom and a top number, both included. It changes every time the sheet recalculates.
RANK	PLADS	Returns the rank of a number in a list, 1 for the largest by default. Equal numbers share a rank.
RATE	RENTE	Returns the interest rate per period of a loan or investment, from the number of payments, the payment and the amount. Multiply by 12 to get the annual rate on monthly payments.
REPLACE	ERSTAT	Replaces part of a text by position. From a start character, a number of characters is swapped for new text. To replace by content instead, use SUBSTITUTE.
RIGHT	HØJRE	Returns the last characters of a text. The result is text, even when it looks like a number.
ROUND	AFRUND	Rounds a number to a given number of decimals. Halves round away from zero; negative decimals round to tens, hundreds and so on.
ROUNDDOWN	RUND.NED	Rounds a number down, toward zero, to a given number of decimals.
ROUNDUP	RUND.OP	Rounds a number up, away from zero, to a given number of decimals.
ROW	RÆKKE	Returns the row number of a cell. Left empty, it returns the row of the cell the formula is in.
SEARCH	SØG	Returns the position of one text inside another, ignoring upper and lower case. Wildcards * and ? are allowed.
SEQUENCE	SEKVENS	Returns a list of numbers in sequence, such as 1, 2, 3, that spills into rows and columns. You choose the size, the start and the step.
SMALL	MINDSTE	Returns the k-th smallest value in a range: k = 1 is the minimum.
SORT	SORTER	Sorts the rows of a range by one of its columns and spills the sorted copy into the cells below. The original data stays as it is.
SORTBY	SORTER.EFTER	Sorts a range by the values in another range, which need not be part of the result. Add more by-range and order pairs to break ties.
SQRT	KVROD	Returns the square root of a number. A negative number gives
STDEV.P	STDAFV.P	Returns the standard deviation of a whole population, for when your data is every value there is and not a sample.
STDEV.S	STDAFV.S	Estimates the standard deviation of a sample, which is how far the values typically sit from their average. Text and empty cells in a range are ignored.
SUBSTITUTE	UDSKIFT	Replaces existing text with new text, everywhere or only the n-th time it appears.
SUM	SUM	Adds numbers, cell references and ranges. Text and blank cells in a range are ignored.
SUMIF	SUM.HVIS	Adds the cells that meet one condition. The condition can be checked in the same range or in another column.
SUMIFS	SUM.HVISER	Adds the cells that meet every one of several conditions. The sum range comes first.
SUMPRODUCT	SUMPRODUKT	Multiplies ranges row by row and adds the results. With a condition in parentheses it works as a flexible SUMIFS.
SWITCH	SKIFT	Compares one value against a list and returns the result for the first match, with an optional default at the end.
TEXT	TEKST	Formats a number as text with a number format code, for example to put it inside a sentence.
TEXTAFTER	TEKSTEFTER	Returns the text after a delimiter, such as the domain after the @ in an email address. You can choose which occurrence of the delimiter to use.
TEXTBEFORE	TEKSTFØR	Returns the text before a delimiter, such as everything before the @ in an email address. You can choose which occurrence of the delimiter to use.
TEXTJOIN	TEKST.KOMBINER	Joins texts with a delimiter between them, and can skip empty cells.
TEXTSPLIT	TEKSTSPLIT	Splits text into pieces at a delimiter and spills them across columns, or down rows when you also give a row delimiter.
TIME	TID	Builds a time from an hour, a minute and a second. The result is a fraction of a day, so TIME(12,0,0) is 0.5.
TODAY	IDAG	Returns today's date. It updates every time the sheet recalculates.
TRANSPOSE	TRANSPONER	Turns rows into columns and columns into rows. The result spills and stays linked to the original cells.
TRIM	FJERN.OVERFLØDIGE.BLANKE	Removes spaces from the start and end of a text and turns runs of spaces inside it into one.
TRUNC	AFKORT	Cuts off the decimals of a number without rounding. TRUNC(8.9) is 8, and TRUNC(-8.9) is -8.
UNIQUE	ENTYDIGE	Returns the distinct values of a range as a list that spills into the cells below.
UPPER	STORE.BOGSTAVER	Converts text to capital letters.
VALUE	VÆRDI	Converts text that looks like a number, such as "1,250" or "15%", into a real number you can calculate with.
VLOOKUP	LOPSLAG	Looks for a value in the first column of a table and returns the value from another column in the same row.
WEEKDAY	UGEDAG	Returns the day of the week of a date as a number. By default 1 is Sunday and 7 is Saturday; with 2 as the second argument, Monday is 1.
WEEKNUM	UGE.NR	Returns the week number of a date. By default weeks start on Sunday and week 1 is the week with Jan 1 in it; return type 21 gives ISO week numbers, as used in Europe.
WORKDAY	ARBEJDSDAG	Returns the date a number of working days before or after a start date, skipping weekends and any holidays you list.
XLOOKUP	XOPSLAG	Finds a value in one range and returns the matching item from another. Exact match by default, with an optional value for not found.
XMATCH	XSAMMENLIGN	Returns the position of a value in a range, like MATCH but with exact match as the default and search from the end.
YEAR	ÅR	Returns the year of a date as a number.

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]).