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 Engels-Nederlands
Alle Excel functies vertaald van Engels naar Nederlands. Deze lijst komt van pas als je bekend bent met de Engelse versie van Excel, maar met een Nederlandse versie moet werken. Excel functies hebben namelijk in alle talen andere namen.
Lijst met alle Excel functies
vertaald van Engels naar Nederlands
| 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 |