Excel-functies in het nederlands
Lijst van Excel functies met vertaling van/naar het Engels
These are the most common Excel functions with Dutch translations.
Normally you would also have to replace all the commas in my example formulas with semi-colon.
| English | Dutch |
|---|---|
| ABS | ABS |
| ADDRESS | ADRES |
| AND | EN |
| AVERAGE | GEMIDDELDE |
| AVERAGEIF | GEMIDDELDE.ALS |
| AVERAGEIFS | GEMIDDELDEN.ALS |
| BAHTTEXT | BAHT.TEKST |
| BIN2DEC | BIN.N.DEC |
| BIN2HEX | BIN.N.HEX |
| CEILING | AFRONDEN.BOVEN |
| CHAR | TEKEN |
| CHOOSE | KIEZEN |
| CODE | CODE |
| COLUMN | KOLOM |
| COLUMNS | KOLOMMEN |
| CONCATENATE | TEKST.SAMENVOEGEN |
| COUNT | AANTAL |
| COUNTA | AANTALARG |
| COUNTBLANK | AANTAL.LEGE.CELLEN |
| COUNTIF | AANTAL.ALS |
| COUNTIFS | AANTALLEN.ALS |
| DATE | DATUM |
| DATEVALUE | DATUMWAARDE |
| DAY | DAG |
| DEC2BIN | DEC.N.BIN |
| DEC2HEX | DEC.N.HEX |
| EOMONTH | LAATSTE.DAG |
| EVEN | EVEN |
| EXACT | GELIJK |
| FACT | FACULTEIT |
| FIND | VIND.ALLES |
| FLOOR | AFRONDEN.BENEDEN |
| HEX2BIN | HEX.N.BIN |
| HEX2DEC | HEX.N.DEC |
| HLOOKUP | HORIZ.ZOEKEN |
| HYPERLINK | HYPERLINK |
| IF | ALS |
| IFERROR | ALS.FOUT |
| INDEX | INDEX |
| INDIRECT | INDIRECT |
| INFO | INFO |
| INT | INTEGER |
| ISBLANK | ISLEEG |
| ISERROR | ISFOUT |
| ISEVEN | IS.EVEN |
| ISNA | ISNB |
| ISNONTEXT | ISGEENTEKST |
| ISNUMBER | ISGETAL |
| ISODD | IS.ONEVEN |
| ISTEXT | ISTEKST |
| LARGE | GROOTSTE |
| LEFT | LINKS |
| LEN | LENGTE |
| LOOKUP | ZOEKEN |
| LOWER | KLEINE.LETTERS |
| MATCH | VERGELIJKEN |
| MAX | MAX |
| MEDIAN | MEDIAAN |
| MID | MIDDEN |
| MIN | MIN |
| MOD | REST |
| MODE | MODUS |
| MONTH | MAAND |
| N | N |
| NA | NB |
| NETWORKDAYS | NETTO.WERKDAGEN |
| NOT | NIET |
| NOW | NU |
| ODD | ONEVEN |
| OFFSET | VERSCHUIVING |
| OR | OF |
| PERCENTILE | PERCENTIEL |
| PI | PI |
| PROPER | BEGINLETTERS |
| QUARTILE | KWARTIEL |
| RAND | ASELECT |
| RANDBETWEEN | ASELECTTUSSEN |
| RANK | RANG |
| REPLACE | VERVANG |
| REPT | HERHALING |
| RIGHT | RECHTS |
| ROMAN | ROMEINS |
| ROUND | AFRONDEN |
| ROUNDDOWN | AFRONDEN.NAAR.BENEDEN |
| ROUNDUP | AFRONDEN.NAAR.BOVEN |
| ROW | RIJ |
| ROWS | RIJEN |
| SEARCH | VIND.SPEC |
| SMALL | KLEINSTE |
| STDEV | STDEV |
| SUBSTITUTE | SUBSTITUEREN |
| SUM | SOM |
| SUMIF | SOM.ALS |
| SUMIFS | SOMMEN.ALS |
| SUMPRODUCT | SOMPRODUCT |
| TEXT | TEKST |
| TODAY | VANDAAG |
| TRANSPOSE | TRANSPONEREN |
| TRIM | SPATIES.WISSEN |
| UPPER | HOOFDLETTERS |
| VLOOKUP | VERT.ZOEKEN |
| WEEKDAY | WEEKDAG |
| WEEKNUM | WEEKNUMMER |
| YEAR | JAAR |
| TRUE | WAAR |
Pingback: youtube zoeken