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