LOGNORMDIST

Definition: LOGNORMDIST is a function that returns the cumulative distribution function for a specified log-normal distribution.

Syntax: =LOGNORMDIST(x, mean, standard_dev, cumulative)

Situation: This formula is appropriate when you need to calculate the cumulative distribution function for a log-normal distribution.

Example: If you have a log-normal distribution with a mean of 10 and a standard deviation of 2, and want to find the cumulative probability of the value 8, the formula =LOGNORMDIST(8, 10, 2, TRUE) can be used, which returns 0.1587.