Categories
Excel function translations English to Dutch
A list of Excel function translations from English to Dutch. If you’re familiar with the English version of Excel and you find yourself working with the Dutch 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 English to Dutch
English | Dutch |
ABS | ABS |
ACCRINT | SAMENG.RENTE |
ACCRINTM | SAMENG.RENTE.V |
ACOS | BOOGCOS |
ACOSH | BOOGCOSH |
ACOT | BOOGCOT |
ACOTH | BOOGCOTH |
ADDRESS | ADRES |
AGGREGATE | AGGREGAAT |
AMORDEGRC | AMORDEGRC |
AMORLINC | AMORLINC |
AND | EN |
ARABIC | ARABISCH |
AREAS | BEREIKEN |
ASC | ASC |
ASIN | BOOGSIN |
ASINH | BOOGSINH |
ATAN | BOOGTAN |
ATAN2 | BOOGTAN2 |
ATANH | BOOGTANH |
AVEDEV | GEM.DEVIATIE |
AVERAGE | GEMIDDELDE |
AVERAGEA | GEMIDDELDEA |
AVERAGEIF | GEMIDDELDE.ALS |
AVERAGEIFS | GEMIDDELDEN.ALS |
BAHTTEXT | BAHT.TEKST |
BASE | BASIS |
BESSELI | BESSEL.I |
BESSELJ | BESSEL.J |
BESSELK | BESSEL.K |
BESSELY | BESSEL.Y |
BETA.DIST | BETA.VERD |
BETA.INV | BETA.INV |
BETADIST | BETA.VERD |
BETAINV | BETA.INV |
BIN2DEC | BIN.N.DEC |
BIN2HEX | BIN.N.HEX |
BIN2OCT | BIN.N.OCT |
BINOM.DIST | BINOM.VERD |
BINOM.DIST.RANGE | BINOM.VERD.BEREIK |
BINOM.INV | BINOMIALE.INV |
BINOMDIST | BINOMIALE.VERD |
BITAND | BIT.EN |
BITLSHIFT | BIT.VERSCHUIF.LINKS |
BITOR | BIT.OF |
BITRSHIFT | BIT.VERSCHUIF.RECHTS |
BITXOR | BIT.EX.OF |
CALL | ROEPEN |
CEILING | AFRONDEN.BOVEN |
CEILING.MATH | AFRONDEN.BOVEN.WISK |
CEILING.PRECISE | AFRONDEN.BOVEN.NAUWKEURIG |
CELL | CEL |
CHAR | TEKEN |
CHIDIST | CHI.KWADRAAT |
CHIINV | CHI.KWADRAAT.INV |
CHISQ.DIST | CHIKW.VERD |
CHISQ.DIST.RT | CHIKW.VERD.RECHTS |
CHISQ.INV | CHIKW.INV |
CHISQ.INV.RT | CHIKW.INV.RECHTS |
CHISQ.TEST | CHIKW.TEST |
CHITEST | CHI.TOETS |
CHOOSE | KIEZEN |
CLEAN | WISSEN.CONTROL |
CODE | CODE |
COLUMN | KOLOM |
COLUMNS | KOLOMMEN |
COMBIN | COMBINATIES |
COMBINA | COMBIN.A |
COMPLEX | COMPLEX |
CONCATENATE | TEKST.SAMENVOEGEN |
CONFIDENCE | BETROUWBAARHEID |
CONFIDENCE.NORM | BETROUWBAARHEID.NORM |
CONFIDENCE.T | BETROUWBAARHEID.T |
CONVERT | CONVERTEREN |
CORREL | CORRELATIE |
COS | COS |
COSH | COSH |
COT | COT |
COTH | COTH |
COUNT | AANTAL |
COUNTA | AANTALARG |
COUNTBLANK | AANTAL.LEGE.CELLEN |
COUNTIF | AANTAL.ALS |
COUNTIFS | AANTALLEN.ALS |
COUPDAYBS | COUP.DAGEN.BB |
COUPDAYS | COUP.DAGEN |
COUPDAYSNC | COUP.DAGEN.VV |
COUPNCD | COUP.DATUM.NB |
COUPNUM | COUP.AANTAL |
COUPPCD | COUP.DATUM.VB |
COVAR | COVARIANTIE |
COVARIANCE.P | COVARIANTIE.P |
COVARIANCE.S | COVARIANTIE.S |
CRITBINOM | CRIT.BINOM |
CSC | COSEC |
CSCH | COSECH |
CUBEKPIMEMBER | KUBUSKPILID |
CUBEMEMBER | KUBUSLID |
CUBEMEMBERPROPERTY | KUBUSLIDEIGENSCHAP |
CUBERANKEDMEMBER | KUBUSGERANGSCHIKTLID |
CUBESET | KUBUSSET |
CUBESETCOUNT | KUBUSSETAANTAL |
CUBEVALUE | KUBUSWAARDE |
CUMIPMT | CUM.RENTE |
CUMPRINC | CUM.HOOFDSOM |
DATE | DATUM |
DATEVALUE | DATUMWAARDE |
DAVERAGE | DBGEMIDDELDE |
DAY | DAG |
DAYS | DAGEN |
DAYS360 | DAGEN360 |
DB | DB |
DBCS | DBCS |
DCOUNT | DBAANTAL |
DCOUNTA | DBAANTALALC |
DDB | DDB |
DEC2BIN | DEC.N.BIN |
DEC2HEX | DEC.N.HEX |
DEC2OCT | DEC.N.OCT |
DECIMAL | DECIMAAL |
DEGREES | GRADEN |
DELTA | DELTA |
DEVSQ | DEV.KWAD |
DGET | DBLEZEN |
DISC | DISCONTO |
DMAX | DBMAX |
DMIN | DBMIN |
DOLLAR | EURO |
DOLLARDE | EURO.DE |
DOLLARFR | EURO.BR |
DPRODUCT | DBPRODUCT |
DSTDEV | DBSTDEV |
DSTDEVP | DBSTDEVP |
DSUM | DBSOM |
DURATION | DUUR |
DVAR | DBVAR |
DVARP | DBVARP |
EDATE | ZELFDE.DAG |
EFFECT | EFFECT.RENTE |
ENCODEURL | URL.CODEREN |
EOMONTH | LAATSTE.DAG |
ERF | FOUTFUNCTIE |
ERF.PRECISE | FOUTFUNCTIE.NAUWKEURIG |
ERFC | FOUT.COMPLEMENT |
ERFC.PRECISE | FOUT.COMPLEMENT.NAUWKEURIG |
ERROR.TYPE | TYPE.FOUT |
EUROCONVERT | EUROCONVERT |
EVEN | EVEN |
EXACT | GELIJK |
EXP | EXP |
EXPON.DIST | T.VERD |
EXPONDIST | EXPON.VERD |
F.DIST | F.VERD |
F.DIST.RT | F.VERD.RECHTS |
F.INV | F.INV |
F.INV.RT | F.INV.RECHTS |
F.TEST | F.TOETS |
FACT | FACULTEIT |
FACTDOUBLE | DUBBELE.FACULTEIT |
FALSE | ONWAAR |
FDIST | F.VERDELING |
FILTERXML | XML.FILTEREN |
FIND, FINDB | VIND, VIND.ALLES.B |
FINV | F.INVERSE |
FISHER | FISHER |
FISHERINV | FISHER.INV |
FIXED | VAST |
FLOOR | AFRONDEN.BENEDEN |
FLOOR.MATH | AFRONDEN.BENEDEN.WISK |
FLOOR.PRECISE | AFRONDEN.BENEDEN.NAUWKEURIG |
FORECAST | VOORSPELLEN |
FORMULATEXT | FORMULETEKST |
FREQUENCY | INTERVAL |
FTEST | F.TOETS |
FV | TW |
FVSCHEDULE | TOEK.WAARDE2 |
GAMMA | GAMMA |
GAMMA.DIST | GAMMA.VERD |
GAMMA.INV | GAMMA.INV |
GAMMADIST | GAMMA.VERD |
GAMMAINV | GAMMA.INV |
GAMMALN | GAMMA.LN |
GAMMALN.PRECISE | GAMMA.LN.NAUWKEURIG |
GAUSS | GAUSS |
GCD | GGD |
GEOMEAN | MEETK.GEM |
GESTEP | GROTER.DAN |
GETPIVOTDATA | DRAAITABELOPHALEN |
GROWTH | GROEI |
HARMEAN | HARM.GEM |
HEX2BIN | HEX.N.BIN |
HEX2DEC | HEX.N.DEC |
HEX2OCT | HEX.N.OCT |
HLOOKUP | HORIZ.ZOEKEN |
HOUR | UUR |
HYPERLINK | HYPERLINK |
HYPGEOM.DIST | HYPGEOM.VERD |
HYPGEOMDIST | HYPERGEO.VERD |
IF | ALS |
IFERROR | ALS.FOUT |
IFNA | ALS.NB |
IMABS | C.ABS |
IMAGINARY | C.IM.DEEL |
IMARGUMENT | C.ARGUMENT |
IMCONJUGATE | C.TOEGEVOEGD |
IMCOS | C.COS |
IMCOSH | C.COSH |
IMCOT | C.COT |
IMCSC | C.COSEC |
IMCSCH | C.COSECH |
IMDIV | C.QUOTIENT |
IMEXP | C.EXP |
IMLN | C.LN |
IMLOG10 | C.LOG10 |
IMLOG2 | C.LOG2 |
IMPOWER | C.MACHT |
IMPRODUCT | C.PRODUCT |
IMREAL | C.REEEL.DEEL |
IMSEC | C.SEC |
IMSECH | C.SECH |
IMSIN | C.SIN |
IMSINH | C.SINH |
IMSQRT | C.WORTEL |
IMSUB | C.VERSCHIL |
IMSUM | C.SOM |
IMTAN | C.TAN |
INDEX | INDEX |
INDIRECT | INDIRECT |
INFO | INFO |
INT | INTEGER |
INTERCEPT | SNIJPUNT |
INTRATE | RENTEPERCENTAGE |
IPMT | IBET |
IRR | IR |
ISBLANK | ISLEEG |
ISERR | ISFOUT2 |
ISERROR | ISFOUT |
ISEVEN | IS.EVEN |
ISFORMULA | ISFORMULE |
ISLOGICAL | ISLOGISCH |
ISNA | ISNB |
ISNONTEXT | ISGEENTEKST |
ISNUMBER | ISGETAL |
ISO.CEILING | ISO.AFRONDEN.BOVEN |
ISODD | IS.ONEVEN |
ISOWEEKNUM | ISO.WEEKNUMMER |
ISPMT | ISBET |
ISREF | ISVERWIJZING |
ISTEXT | ISTEKST |
KURT | KURTOSIS |
LARGE | GROOTSTE |
LCM | KGV |
LEFT, LEFTB | LINKS, LINKSB |
LEN, LENB | LENGTE, LENGTEB |
LINEST | LIJNSCH |
LN | LN |
LOG | LOG |
LOG10 | LOG10 |
LOGEST | LOGSCH |
LOGINV | LOG.NORM.INV |
LOGNORM.DIST | LOGNORM.VERD |
LOGNORM.INV | LOGNORM.INV |
LOGNORMDIST | LOG.NORM.VERD |
LOOKUP | ZOEKEN |
LOWER | KLEINE.LETTERS |
MATCH | VERGELIJKEN |
MAX | MAX |
MAXA | MAXA |
MDETERM | DETERMINANTMAT |
MDURATION | AANG.DUUR |
MEDIAN | MEDIAAN |
MID, MIDB | DEEL, DEELB |
MIN | MIN |
MINA | MINA |
MINUTE | MINUUT |
MINVERSE | INVERSEMAT |
MIRR | GIR |
MMULT | PRODUCTMAT |
MOD | REST |
MODE | MODUS |
MODE.MULT | MODUS.MEERV |
MODE.SNGL | MODUS.ENKELV |
MONTH | MAAND |
MROUND | AFRONDEN.N.VEELVOUD |
MULTINOMIAL | MULTINOMIAAL |
MUNIT | EENHEIDMAT |
N | N |
NA | NB |
NEGBINOM.DIST | NEGBINOM.VERD |
NEGBINOMDIST | NEG.BINOM.VERD |
NETWORKDAYS | NETTO.WERKDAGEN |
NETWORKDAYS.INTL | NETWERKDAGEN.INTL |
NOMINAL | NOMINALE.RENTE |
NORM.DIST | NORM.VERD |
NORM.INV | NORM.INV |
NORM.S.DIST | NORM.S.VERD |
NORM.S.INV | NORM.S.INV |
NORMDIST | NORM.VERD |
NORMINV | NORM.INV |
NORMSDIST | STAND.NORM.VERD |
NORMSINV | STAND.NORM.INV |
NOT | NIET |
NOW | NU |
NPER | NPER |
NPV | NHW |
NUMBERVALUE | NUMERIEKE.WAARDE |
OCT2BIN | OCT.N.BIN |
OCT2DEC | OCT.N.DEC |
OCT2HEX | OCT.N.HEX |
ODD | ONEVEN |
ODDFPRICE | AFW.ET.PRIJS |
ODDFYIELD | AFW.ET.REND |
ODDLPRICE | AFW.LT.PRIJS |
ODDLYIELD | AFW.LT.REND |
OFFSET | VERSCHUIVING |
OR | OF |
PDURATION | PDUUR |
PEARSON | PEARSON |
PERCENTILE | PERCENTIEL |
PERCENTILE.EXC | PERCENTIEL.EXC |
PERCENTILE.INC | PERCENTIEL.INC |
PERCENTRANK | PERCENT.RANG |
PERCENTRANK.EXC | PROCENTRANG.EXC |
PERCENTRANK.INC | PROCENTRANG.INC |
PERMUT | PERMUTATIES |
PERMUTATIONA | PERMUTATIE.A |
PHI | PHI |
PHONETIC | FONETISCH |
PI | PI |
PMT | AFLOSSING |
POISSON | POISSON |
POISSON.DIST | POISSON.VERD |
POWER | MACHT |
PPMT | PBET |
PRICE | PRIJS.NOM |
PRICEDISC | PRIJS.DISCONTO |
PRICEMAT | PRIJS.VERVALDAG |
PROB | KANS |
PRODUCT | PRODUCT |
PROPER | BEGINLETTERS |
PV | HW |
QUARTILE | KWARTIEL |
QUARTILE.EXC | KWARTIEL.EXC |
QUARTILE.INC | KWARTIEL.INC |
QUOTIENT | QUOTIENT |
RADIANS | RADIALEN |
RAND | ASELECT |
RANDBETWEEN | ASELECTTUSSEN |
RANK | RANG |
RANK.AVG | RANG.GEMIDDELDE |
RANK.EQ | RANG.GELIJK |
RATE | RENTE |
RECEIVED | OPBRENGST |
REGISTER.ID | REGISTRATIE.ID |
REPLACE, REPLACEB | VERVANGEN, VERVANGENB |
REPT | HERHALING |
RIGHT, RIGHTB | RECHTS, RECHTSB |
ROMAN | ROMEINS |
ROUND | AFRONDEN |
ROUNDDOWN | AFRONDEN.NAAR.BENEDEN |
ROUNDUP | AFRONDEN.NAAR.BOVEN |
ROW | RIJ |
ROWS | RIJEN |
RRI | RRI |
RSQ | R.KWADRAAT |
RTD | RTG |
SEARCH, SEARCHB | VIND.SPEC, VIND.SPEC.B |
SEC | SEC |
SECH | SECH |
SECOND | SECONDE |
SERIESSUM | SOM.MACHTREEKS |
SHEET | BLAD |
SHEETS | BLADEN |
SIGN | POS.NEG |
SIN | SIN |
SINH | SINH |
SKEW | SCHEEFHEID |
SKEW.P | SCHEEFHEID.P |
SLN | LIN.AFSCHR |
SLOPE | RICHTING |
SMALL | KLEINSTE |
SQL.REQUEST | SQL.REQUEST |
SQRT | WORTEL |
SQRTPI | WORTEL.PI |
STANDARDIZE | NORMALISEREN |
STDEV | STDEV |
STDEV.P | STDEV.P |
STDEV.S | STDEV.S |
STDEVA | STDEVA |
STDEVP | STDEVP |
STDEVPA | STDEVPA |
STEYX | STAND.FOUT.YX |
SUBSTITUTE | SUBSTITUEREN |
SUBTOTAL | SUBTOTAAL |
SUM | SOM |
SUMIF | SOM.ALS |
SUMIFS | SOMMEN.ALS |
SUMPRODUCT | SOMPRODUCT |
SUMSQ | KWADRATENSOM |
SUMX2MY2 | SOM.X2MINY2 |
SUMX2PY2 | SOM.X2PLUSY2 |
SUMXMY2 | SOM.XMINY.2 |
SYD | SYD |
T | T |
T.DIST | T.VERD |
T.DIST.2T | T.VERD.2T |
T.DIST.RT | T.VERD.RECHTS |
T.INV | T.INV |
T.INV.2T | T.INV.2T |
T.TEST | T.TEST |
TAN | TAN |
TANH | TANH |
TBILLEQ | SCHATK.OBL |
TBILLPRICE | SCHATK.PRIJS |
TBILLYIELD | SCHATK.REND |
TDIST | T.VERD |
TEXT | TEKST |
TIME | TIJD |
TIMEVALUE | TIJDWAARDE |
TINV | T.INV |
TODAY | VANDAAG |
TRANSPOSE | TRANSPONEREN |
TREND | TREND |
TRIM | SPATIES.WISSEN |
TRIMMEAN | GETRIMD.GEM |
TRUE | WAAR |
TRUNC | GEHEEL |
TTEST | T.TOETS |
TYPE | TYPE |
UNICHAR | UNITEKEN |
UNICODE | UNICODE |
UPPER | HOOFDLETTERS |
VALUE | WAARDE |
VAR | VAR |
VAR.P | VAR.P |
VAR.S | VAR.S |
VARA | VARA |
VARP | VARP |
VARPA | VARPA |
VDB | VDB |
VLOOKUP | VERT.ZOEKEN |
WEBSERVICE | WEBSERVICE |
WEEKDAY | WEEKDAG |
WEEKNUM | WEEKNUMMER |
WEIBULL | WEIBULL |
WEIBULL.DIST | WEIBULL.VERD |
WORKDAY | WERKDAG |
WORKDAY.INTL | WERKDAG.INTL |
XIRR | IR.SCHEMA |
XLOOKUP | X.ZOEKEN |
XNPV | NHW2 |
XOR | EX.OF |
YEAR | JAAR |
YEARFRAC | JAAR.DEEL |
YIELD | RENDEMENT |
YIELDDISC | REND.DISCONTO |
YIELDMAT | REND.VERVAL |
Z.TEST | Z.TEST |
ZTEST | Z.TOETS |