Related Functions:

The LOGNORM.DIST function returns the Log-Normal Probability Density or the Cumulative Log-Normal Distribution for a supplied value of x.

  • This function was introduced in Excel 2010 and so is not available in earlier versions.
  • The LOGNORM.DIST function replaces the LOGNORMDIST function included in earlier versions of Excel.

Syntax

=LOGNORM.DIST(x,mean,standard_dev,cumulative)

Arguments

Argument Description
x The value at which to evaluate the log-normal distribution function
mean The arithmetic mean of ln(x)
standard_dev The standard deviation of ln(x)
cumulative A logical value that determines the form of the function

  TRUE returns the cumulative distribution function
  FALSE returns the probability density function

Examples

  A B C D
1 Data Description    
2 12 Value at which to evaluate the function (x)    
3 7.5 Mean of ln(x)    
4 4 Standard deviation of ln(x)    
5        
6 Formula Result Notes
7 =LOGNORM.DIST(A2,A3,A4,TRUE) 0.104962 Cumulative lognormal distribution at 4, using the arguments in A2:A4
8 =LOGNORM.DIST(A2,A3,A4,FALSE) 0.003787 Probability lognormal distribution at 4, using the same arguments

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if any of the supplied arguments are non-numeric
#NUM! Occurs if the supplied x ≤ 0 or the supplied standard_dev ≤ 0

The equation for the lognormal cumulative distribution function is:    

    \[ \text{LOGNORM.DIST}(x,\mu,\sigma) = \text{NORM.S.DIST}( \frac {1n(x)-\mu}{\sigma}    \]

where \mu is the mean of \ln(x) and \sigma is the standard deviation of \ln(x).

See Wikipedia for more information on log-normal distribution.