Author: Oscar Cronquist Article last updated on May 11, 2022

The LOGNORMDIST function calculates the cumulative lognormal distribution of argument x, based on a normally distributed ln(x) with the arguments of mean and standard_dev.

This function is outdated and is located in the Compatibility category, it has been replaced with the newer LOGNORM.DIST function.

Formula in cell C7:

=LOGNORMDIST(C3,C4,C5)

Excel Function Syntax

LOGNORMDIST(x, mean, standard_dev)

Arguments

x Required.
mean Required. A value representing the mean of ln(x).
standard_dev Required. A value representing the standard deviation of ln(x).

Comments

The LOGNORMDIST function returns

  • #VALUE! error value if any argument is non-numeric.
  • #NUM! error value if:
    • x <= 0
    • standard_dev <= 0

The equation to calculate the lognormal cumulative distribution is: