Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters Mean and Standard_dev. If p = LOGNORM.DIST(x,...) then LOGNORM.INV(p,...) = x.

Use the lognormal distribution to analyze logarithmically transformed data.

Sample Usage


LOGNORM.INV(probability, mean, standard_dev)

The LOGNORM.INV function syntax has the following arguments:

  • Probability    Required. A probability associated with the lognormal distribution.

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

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


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

  • If probability <= 0 or probability >= 1, LOGNORM.INV returns the #NUM! error value.

  • If standard_dev <= 0, LOGNORM.INV returns the #NUM! error value.

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

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

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



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