LOGNORMDIST

Calculates values for the cumulative distribution function of a lognormal distribution.

Syntax:

LOGNORMDIST(x, μ, σ)

A variable is lognormally distributed if its natural logarithm is normally distributed. Parameters of the distribution are μ (mean) and σ (standard deviation).

LOGNORMDIST calculates the cumulative density function for a lognormal distribution.

LOGNORMDIST(x, μ, σ) is equivalent to NORMDIST((LN(x)-μ)/σ, 0, 1, 1); it may also be calculated from

0.5 * ERFC((-LN(x)+μ)/(σ*SQRT(2)))

Example:

LOGNORMDIST(1, 0, 1)

returns 0.5.