<< Click to Display Table of Contents >> LOGNORMDIST (lognormal distribution)

Note: LOGNORMDIST is supplemented by the new function LOGNORM.DIST with additional functionality, which is available in newer versions of Microsoft Excel (2010 or later).

Syntax:

LOGNORMDIST(x, Mean, StdDev)

Description:

Returns the probabilities of a cumulative log-normal distributed random number.

With this function you can view probability distributions in which not the random number itself but its natural logarithm is normally distributed.

x is the value to be evaluated. Must be > 0.

Mean is the mean of LN(x).

StdDev is the standard deviation of LN(x). Must be > 0.

See also:

LOGNORM.DIST, LN, LOGNORM.INV/LOGINV, NORM.DIST/NORMDIST, NORM.S.DIST/NORMSDIST