NORMDIST

Syntax: NORMDIST(X, M, S, C)

X = a numeric value
M = the mean of the normal distribution
S = the standard deviation of the normal distribution
C = a boolean value (1 = ``cumulative'')

The cumulative normal distribution from minus infinity to X for mean M and standard deviation S. If C is True (non-zero), the cumulative distribution function F(X) is returned; otherwise, the probability mass function f(X) is returned. The standard deviation S must be greater than zero.

The mathematical formulation is given by:

For C = 0:

$$f(X) = \frac{1}{\sqrt{2\pi \times S}} e^{-\frac{(X-M)^2}{2S^2}}$$

For C = 1:

$$F(X) = \int_{-\infty}^{X} \frac{1}{\sqrt{2\pi \times S}} e^{-\frac{(t-M)^2}{2S^2}} dt$$

Examples:

NORMDIST(1.41, 1, 0, 0) = 0.1476385

NORMDIST(1.41, 1, 0, 1) = 0.92073016

NORMDIST(1.41, 1, 0, 0) = Error

Excel function: NORMDIST