LOGNORM.DIST function

LOGNORM.DIST(x, mean, standardDeviation, isCumulative) LOGNORM.DIST(x; mean; standardDeviation; isCumulative)

x — Number or { Number }

The value at which to evaluate the function.

mean — Number or { Number }

The mean of the natural logarithm of the x parameter.

standardDeviation — Number or { Number }

The standard deviation of the natural logarithm of the x parameter.

isCumulative — Logical or { Logical }

FALSE to calculate the probability density function and TRUE to calculate the cumulative distribution function.

Returns — Number or { Number }

A value for the cumulative distribution function of a lognormal distribution.

Returns a value for the cumulative distribution function of a lognormal distribution.

Example

LOGNORM.DIST(1, 0, 1, TRUE)LOGNORM.DIST(1; 0; 1; TRUE)

Returns 0.5.