Categories
- Best practices(16)
- Berekeningen(6)
- Kringverwijzingen(2)
- Ontdubbeling(1)
- Gedefinieerde namen(1)
- Excel errors(2)
- Verklarende Excel woordenlijst(18)
- Excel standaarden(1)
- Opmaak(2)
- Formules(7)
- Functies(11)
- Input sources(4)
- Navigatie
- Risico's(2)
- Spreadsheet ontwikkeling(8)
- Spreadsheet onderhoud(7)
- Tabellen(1)
- VBA(1)
Excel functie vertalingen Nederlands-Engels
Alle Excel functies vertaald van Nederlands naar Engels. Deze lijst komt van pas als je bekend bent met de Nederlandse versie van Excel, maar met een Engelse versie moet werken. Excel functies hebben namelijk in alle talen andere namen.
Lijst met alle Excel functies
vertaald van Nederlands naar Engels
| Nederlands | Engels |
| 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 |