formulas translated UK-NL answer

XiniX

Board Regular
Joined
May 1, 2002
Messages
57
UK NL
ABS ABS
ACCRINT SAMENG.RENTE
ACCRINTM SAMENG.RENTE.V
ACOS BOOGCOS
ACOSH BOOGCOSH
ADDRESS ADRES
AMORDEGRC AMORDEGRC
AMORLINC AMORLINC
AND EN
AREAS BEREIKEN
ASIN BOOGSIN
ASINH BOOGSINH
ATAN BOOGTAN
ATAN2 BOOGTAN2
ATANH BOOGTANH
AVEDEV GEM.DEVIATIE
AVERAGE GEMIDDELDE
BESSELI BESSEL.I
BESSELJ BESSEL.J
BESSELK BESSEL.K
BESSELY BESSEL.Y
BETADIST BETA.VERD
BETAINV BETA.INV
BIN2DEC BIN.N.DEC
BIN2HEX BIN.N.HEX
BIN2OCT BIN.N.OCT
BINOMDIST BINOMIALE.VERD
CALL ROEPEN
CEILING AFRONDEN.BOVEN
CELL CEL
CHAR TEKEN
CHIDIST CHI.KWADRAAT
CHIINV CHI.KWADRAAT.INV
CHITEST CHI.TOETS
CHOOSE KIEZEN
CLEAN WISSEN.CONTROL
CODE CODE
COLUMN KOLOM
COLUMNS KOLOMMEN
COMBIN COMBINATIES
COMPLEX COMPLEX
CONCATENATE TEKST.SAMENVOEGEN
CONFIDENCE BETROUWBAARHEID
CONVERT CONVERTEREN
CORREL CORRELATIE
COS COS
COSH COSH
COUNT AANTAL
COUNTA AANTALARG
COUNTBLANK AANTAL.LEGE.CELLEN
COUNTIF AANTAL.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
CRITBINOM CRIT.BINOM
CUMIPMT CUM.RENTE
CUMPRINC CUM.HOOFDSOM
DATE DATUM
DATEVALUE DATUMWAARDE
DAVERAGE DBGEMIDDELDE
DAY DAG
DAYS360 DAGEN360
DB DB
DCOUNT DBAANTAL
DCOUNTA DBAANTALC
DDB DDB
DEC2BIN DEC.N.BIN
DEC2HEX DEC.N.HEX
DEC2OCT DEC.N.OCT
DEGREES GRADEN
DELTA DELTA
DEVSQ DEV.KWAD
DGET DBLEZEN
DISC DISCONTO
DMAX DBMAX
DMIN DBMIN
DOLLAR GULDEN
DOLLARDE GULDEN.DE
DOLLARFR GULDEN.BR
DPRODUCT DBPRODUKT
DSTDEV DBSTDEV
DSTDEVP DBSTDEVP
DSUM DBSOM
DURATION DUUR
DVAR DBVAR
DVARP DBVARP
EDATE ZELFDE.DAG
EFFECT EFFECT.RENTE
EOMONTH LAATSTE.DAG
ERF FOUTFUNCTIE
ERFC FOUT.COMPLEMENT
ERROR.TYPE TYPE.FOUT
EVEN EVEN
EXACT GELIJK
EXP EXP
EXPONDIST EXPON.VERD
FACT FACULTEIT
FACTDOUBLE DUBBELE.FACULTEIT
FALSE ONWAAR
FDIST F.VERDELING
FIND VIND.ALLES
FINV F.INVERSE
FISHER FISHER
FISHERINV FISHER.INV
FIXED VAST
FLOOR AFRONDEN.BENEDEN
FORECAST VOORSPELLEN
FREQUENCY INTERVAL
FTEST F.TOETS
FV TW
FVSCHEDULE TOEK.WAARDE
GAMMADIST GAMMA.VERD
GAMMAINV GAMMA.INV
GAMMALN GAMMA.LN
GCD GGD
GEOMEAN MEETK.GEM
GESTEP GROTER.DAN
GROWTH GROEI
HARMEAN HARM.GEM
HEX2BIN HEX.N.BIN
HEX2DEC HEX.N.DEC
HEX2OCT HEX.N.OCT
HLOOKUP HORIZ.ZOEKEN
HOUR UUR
HYPGEOMDIST HYPERGEO.VERD
IF ALS
IMABS C.ABS
IMAGINARY C.IM.DEEL
IMARGUMENT C.ARGUMENT
IMCONJUGATE C.TOEGEVOEGD
IMCOS C.COS
IMDIV C.QUOTIENT
IMEXP C.EXP
IMLN C.LN
IMLOG10 C.LOG10
IMLOG2 C.LOG2
IMPOWER C.MACHT
IMPRODUCT C.PRODUKT
IMREAL C.REEEL.DEEL
IMSIN C.SIN
IMSQRT C.WORTEL
IMSUB C.VERSCHIL
IMSUM C.SOM
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
ISLOGICAL ISLOGISCH
ISNA ISNB
ISNONTEXT ISGEENTEKST
ISNUMBER ISGETAL
ISODD IS.ONEVEN
ISREF ISVERWIJZING
ISTEXT ISTEKST
KURT KURTOSIS
LARGE GROOTSTE
LCM KGV
LEFT LINKS
LEN LENGTE
LINEST LIJNSCH
LN LN
LOG LOG
LOG10 LOG10
LOGEST LOGSCH
LOGINV LOG.NORM.INV
LOGNORMDIST LOG.NORM.VERD
LOOKUP ZOEKEN
LOWER KLEINE.LETTERS
MATCH VERGELIJKEN
MAX MAX
MDETERM DETERMINANTMAT
MDURATION AANG.DUUR
MEDIAN MEDIAAN
MID DEEL
MIN MIN
MINUTE MINUUT
MINVERSE INVERSEMAT
MIRR GIR
MMULT PRODUKTMAT
MOD REST
MODE MODUS
MONTH MAAND
MROUND AFRONDEN.N.VEELVOUD
MULTINOMIAL MULTINOMIAAL
N N
NA NB
NEGBINOMDIST NEG.BINOM.VERD
NETWORKDAYS NETTO.WERKDAGEN
NOMINAL NOMINALE.RENTE
NORMDIST NORM.VERD
NORMINV NORM.INV
NORMINV STAND.NORM.INV
NORMSDIST STAND.NORM.VERD
NOT NIET
NOW NU
NPER NPER
NPV NHW2
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
PEARSON PEARSON
PERCENTILE PERCENTIEL
PERCENTRANK PERCENT.RANG
PERMUT PERMUTATIES
PI PI
PMT BET
POISSON POISSON
POWER MACHT
PPMT PBET
PRICE PRIJS.NOM
PRICEDISC PRIJS.DISCONTO
PRICEMAT PRIJS.VERVALDAG
PROB KANS
PRODUCT PRODUKT
PROPER BEGINLETTERS
PV HW
QUARTILE KWARTIEL
QUOTIENT QUOTIENT
RADIANS RADIALEN
RAND ASELECT
RANDBETWEEN ASELECTTUSSEN
RANK RANG
RATE RENTE
RECEIVED OPBRENGST
REGISTERID REGISTRATIE.ID
REPLACE VERVANGEN
REPT HERHALING
RIGHT RECHTS
ROUND AFRONDEN
ROUNDDOWN AFRONDEN.NAAR.BENEDEN
ROUNDUP AFRONDEN.NAAR.BOVEN
ROW RIJ
ROWS RIJEN
RSQ R.KWADRAAT
SEARCH VIND.SPEC
SECOND SECONDE
SERIESSUM SOM.MACHTREEKS
SIGN POS.NEG
SIN SIN
SINH SINH
SKEW SCHEEFHEID
SLN LIN.AFSCHR
SLOPE RICHTING
SMALL KLEINSTE
SQLREQUEST SQL.REQUEST
SQRT WORTEL
SQRTPI WORTEL.PI
STANDARDIZE NORMALISEREN
STDEV STDEV
STDEVP STDEVP
STEYX STAND.FOUT.YX
SUBSTITUTE SUBSTITUEREN
SUBTOTAL SUBTOTAAL
SUM SOM
SUMIF SOM.ALS
SUMPRODUCT SOMPRODUKT
SUMSQ KWADRATENSOM
SUMX2MY2 SOM.X2MINY2
SUMX2PY2 SOM.X2PLUSY2
SUMXMY2 SOM.XMINY.2
SYD SYD
T T
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
UPPER HOOFDLETTERS
VALUE WAARDE
VAR VAR
VARP VARP
VDB VDB
VLOOKUP VERT.ZOEKEN
WEEKDAY WEEKDAG
WEIBULL WEIBULL
WORKDAY WERKDAG
XIRR IR.SCHEMA
XNPV NHW
YEAR JAAR
YEARFRAC JAAR.DEEL
YIELD RENDEMENT
YIELDDISC REND.DISCONTO
YIELDMAT REND.VERVAL
ZTEST Z.TOETS
This message was edited by XiniX on 2002-05-25 08:32
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Forum statistics

Threads
1,215,755
Messages
6,126,682
Members
449,328
Latest member
easperhe29

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top