- Formula Reference
- Contacting Us
- Getting Technical Support
- Formula Overview
-
Formula Functions
- Functions A to C
- Functions D to G
- Functions H to L
-
Functions M to Q
- MAKEARRAY
- MAP
- MATCH
- MAX
- MAXA
- MAXIFS
- MDETERM
- MDURATION
- MEDIAN
- MID
- MIDB
- MIN
- MINA
- MINIFS
- MINUTE
- MINVERSE
- MIRR
- MMULT
- MOD
- MODE
- MODE.MULT
- MODE.SNGL
- MONTH
- MONTHSPARKLINE
- MROUND
- MULTINOMIAL
- MUNIT
- N
- NA
- NEGBINOM.DIST
- NEGBINOMDIST
- NETWORKDAYS
- NETWORKDAYS.INTL
- NOMINAL
- NORM.DIST
- NORM.INV
- NORM.S.DIST
- NORM.S.INV
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- NOT
- NOW
- NPER
- NPV
- NUMBERVALUE
- OCT2BIN
- OCT2DEC
- OCT2HEX
- ODD
- ODDFPRICE
- ODDFYIELD
- ODDLPRICE
- ODDLYIELD
- OFFSET
- OR
- PARETOSPARKLINE
- PDURATION
- PEARSON
- PERCENTILE
- PERCENTILE.EXC
- PERCENTILE.INC
- PERCENTRANK
- PERCENTRANK.EXC
- PERCENTRANK.INC
- PERMUT
- PERMUTATIONA
- PHI
- PI
- PIESPARKLINE
- PMT
- POISSON
- POISSON.DIST
- POWER
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PROB
- PRODUCT
- PROPER
- PV
- QUARTILE
- QUARTILE.EXC
- QUARTILE.INC
- QUOTIENT
- Functions R to S
- Functions T to Z
NORMSDIST
This function returns the standard normal cumulative distribution function.
Syntax
NORMSDIST(value)
Arguments
The argument can be any numeric value.
Remarks
The distribution has a mean of zero and a standard deviation of one. Use this function in place of a table of standard normal curve areas.
Data Types
Accepts numeric data. Returns numeric data.
Examples
NORMSDIST(F1)
NORMSDIST(R1C6)
NORMSDIST(1.288) gives the result 0.901127
Version Available
This function is available in product version 1.0 or later.