Skip to Content

LOGNORM.DIST

Returns the cumulative lognormal distribution

Syntax

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

Parameters

  • x: Required. The value at which to evaluate the function
  • mean: Required. The mean of ln(x)
  • standard_dev: Required. The standard deviation of ln(x)
  • cumulative: Required. TRUE for cumulative, FALSE for probability density

Example

=LOGNORM.DIST(4, 3.5, 1.2, TRUE)
Returns: NumberSince: Excel 2010