Excel Functions in Dutch

Excel-functies in het nederlands
Lijst van Excel functies met vertaling van/naar het Engels

These are the 140 most common functions in Excel with Dutch translations. This list is very useful if you are used to the English version of Excel, and you are working with a Dutch version that only accepts the Dutch function names in the formulas. Or the other way around!

Normally you would also have to replace all the commas in my example formulas with semi-colon.

Do you need a complete list of all the function names in Dutch in Excel? Scroll down to the bottom of this page to read more about Microsoft’s Functions Translator add-in.

EnglishDutch
ABSABS
ADDRESSADRES
AGGREGATEAGGREGAAT
ANDEN
ARABICARABISCH
AVERAGEGEMIDDELDE
AVERAGEIFGEMIDDELDE.ALS
AVERAGEIFSGEMIDDELDEN.ALS
BAHTTEXTBAHT.TEKST
BIN2DECBIN.N.DEC
BIN2HEXBIN.N.HEX
CEILINGAFRONDEN.BOVEN
CEILING.MATHAFRONDEN.BOVEN.WISK
CELLCEL
CHARTEKEN
CHOOSEKIEZEN
CODECODE
COLUMNKOLOM
COLUMNSKOLOMMEN
CONCATTEKST.SAMENV
CONCATENATETEKST.SAMENVOEGEN
CONVERTCONVERTEREN
COUNTAANTAL
COUNTAAANTALARG
COUNTBLANKAANTAL.LEGE.CELLEN
COUNTIFAANTAL.ALS
COUNTIFSAANTALLEN.ALS
DATEDATUM
DATEVALUEDATUMWAARDE
DAYDAG
DAYSDAGEN
DEC2BINDEC.N.BIN
DEC2HEXDEC.N.HEX
EOMONTHLAATSTE.DAG
EVENEVEN
EXACTGELIJK
FACTFACULTEIT
FILTERXMLXML.FILTEREN
FINDVIND.ALLES
FLOORAFRONDEN.BENEDEN
FLOOR.MATHAFRONDEN.BENEDEN.WISK
FORMULATEXTFORMULETEKST
FREQUENCYINTERVAL
HEX2BINHEX.N.BIN
HEX2DECHEX.N.DEC
HLOOKUPHORIZ.ZOEKEN
HYPERLINKHYPERLINK
IFALS
IFERRORALS.FOUT
IFSALS.VOORWAARDEN
INDEXINDEX
INDIRECTINDIRECT
INFOINFO
INTINTEGER
ISBLANKISLEEG
ISERRORISFOUT
ISEVENIS.EVEN
ISLOGICALISLOGISCH
ISNAISNB
ISNONTEXTISGEENTEKST
ISNUMBERISGETAL
ISODDIS.ONEVEN
ISOWEEKNUMISO.WEEKNUMMER
ISTEXTISTEKST
LARGEGROOTSTE
LEFTLINKS
LENLENGTE
LOOKUPZOEKEN
LOWERKLEINE.LETTERS
MATCHVERGELIJKEN
MAXMAX
MAXIFSMAX.ALS.VOORWAARDEN
MEDIANMEDIAAN
MIDDEEL
MINMIN
MINIFSMIN.ALS.VOORWAARDEN
MODREST
MODEMODUS
MONTHMAAND
MROUNDAFRONDEN.N.VEELVOUD
NN
NANB
NETWORKDAYSNETTO.WERKDAGEN
NETWORKDAYS.INTLNETWERKDAGEN.INTL
NOTNIET
NOWNU
ODDONEVEN
OFFSETVERSCHUIVING
OROF
PERCENTILEPERCENTIEL
PERCENTILE.EXCPERCENTIEL.EXC
PERCENTILE.INCPERCENTIEL.INC
PERCENTRANKPERCENT.RANG
PERCENTRANK.EXCPROCENTRANG.EXC
PERCENTRANK.INCPROCENTRANG.INC
PIPI
PMTBET
PROPERBEGINLETTERS
QUARTILEKWARTIEL
QUARTILE.EXCKWARTIEL.EXC
QUARTILE.INCKWARTIEL.INC
RANDASELECT
RANDBETWEENASELECTTUSSEN
RANKRANG
RANK.AVGRANG.GEMIDDELDE
RANK.EQRANG.GELIJK
REPLACEVERVANGEN
REPTHERHALING
RIGHTRECHTS
ROMANROMEINS
ROUNDAFRONDEN
ROUNDDOWNAFRONDEN.NAAR.BENEDEN
ROUNDUPAFRONDEN.NAAR.BOVEN
ROWRIJ
ROWSRIJEN
SEARCHVIND.SPEC
SMALLKLEINSTE
STDEVSTDEV
STDEV.PSTDEV.P
STDEV.SSTDEV.S
SUBSTITUTESUBSTITUEREN
SUBTOTALSUBTOTAAL
SUMSOM
SUMIFSOM.ALS
SUMIFSSOMMEN.ALS
SUMPRODUCTSOMPRODUCT
SWITCHSCHAKELEN
TEXTTEKST
TEXTJOINTEKST.COMBINEREN
TODAYVANDAAG
TRANSPOSETRANSPONEREN
TRIMSPATIES.WISSEN
UNICHARUNITEKEN
UNICODEUNICODE
UPPERHOOFDLETTERS
VLOOKUPVERT.ZOEKEN
WEEKDAYWEEKDAG
WEEKNUMWEEKNUMMER
YEARJAAR
FALSEONWAAR
TRUEWAAR

Does Excel have a translate function?

Yes, there is an add-in called the Functions Translator add-in that you can install in a few seconds:

Go to Insert > Get Add-ins to open the add-in dialog. Choose Productivity under Category, find the Functions Translator add-in and click on the Add button

Click on picture to magnify

Now you will find the Functions Translator on the Home tab to the right.

Use it to look up a functions name in a list (Reference):

Or use the Translator feature to translate a whole formula:

1 thought on “Excel Functions in Dutch

  1. Pingback: youtube zoeken

Leave a Reply

Your email address will not be published. Required fields are marked *


8 − five =