Skip to main content



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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.