Syntax. LOGNORM.INV(probability,mean,standard_dev)

Definition. This function returns the quantile of the lognormal distribution of x, where ln(x) is normally distributed with the parameters mean and standard_dev. If p = LOGNORM.DIST(x,...) then LOGNORN.INV(p,...) = x. If the probability is p, you can calculate the quantile of the lognormal distribution.

Use the lognormal distribution to analyze logarithmically transformed data.


  • probability (required). A probability associated with the lognormal distribution

  • mean (required). The mean of the lognormal distribution

  • standard_dev (required). The standard deviation of the lognormal distribution


If one of the arguments isn’t a numeric expression, the LOGNORM.INV() function ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.