Syntax. LOGNORM.DIST(x,mean,standard_dev,cumulative)

Definition. This function returns the values of the distribution function of a lognormal distributed random variable where ln(x) is normally distributed with the parameters mean and standard_dev. Use this function to analyze data that has been logarithmically transformed.


  • x (required). The value at which to evaluate the function

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

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

  • cumulative (required). The logical value that represents the type of the function


If one of the arguments isn’t a numeric expression, the LOGNORM.DIST() function returns the #VALUE! error.

If x is less ...

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.