Returns the lognormal distribution of x, where ln(x) is normally distributed with parameters Mean and Standard_dev.

Use this function to analyze data that has been logarithmically transformed.

Sample Usage



The LOGNORM.DIST function syntax has the following arguments:

  • X     Required. The value at which to evaluate the function.

  • Mean     Required. The mean of ln(x).

  • Standard_dev     Required. The standard deviation of ln(x).

  • Cumulative     Required. A logical value that determines the form of the function. If cumulative is TRUE, LOGNORM.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.


  • If any argument is nonnumeric, LOGNORM.DIST returns the #VALUE! error value.

  • If x ≤ 0 or if standard_dev ≤ 0, LOGNORM.DIST returns the #NUM! error value.

  • The equation for the lognormal cumulative distribution function is:

    LOGNORM.DIST(x,µ,o) = NORM.S.DIST(1n(x)-µ / o)

In order to use the LOGNORM.DIST formula, start with your edited Excellentable

Then type in the LOGNORM.DIST formula in the area you would like to display the outcome:

By adding the values you would like to calculate the LOGNORM.DIST formula for, Excellentable will generate the outcome:



User does not have sufficient privileges to access this Content
Learn More