# LOGNORMDIST

Formulas / LOGNORMDIST
Calculate data that has been logarithmically transformed and divided into a range of values.
`LOGNORMDIST(x,mean,standard_dev)`
• x - required, value to evaluate the function on
• mean - required
• standard_dev - required

## Examples

• `=LOGNORMDIST(4,A2,A3)`

The LOGNORMDIST function is used to calculate the cumulative lognormal distribution for a given value. For example, this returns the cumulative lognormal distribution at 4.

• `=LOGNORMDIST(A2:A3,A2,A3)`

The LOGNORMDIST function can be used to calculate the cumulative lognormal distribution for a range of values. For example, if A2 and A3 are the lower and upper bounds of a range of values, respectively, you can use the preceding formula to calculate the cumulative lognormal distribution for the entire range.

• `=LOGNORMDIST(0.4,A2,A3)`

The LOGNORMDIST function can also be used to calculate the cumulative lognormal distribution for a given probability. For example, if A2 and A3 are the lower and upper bounds of a range of values, respectively, and 0.4 is the probability, you can use the preceding formula to calculate the cumulative lognormal distribution for the given probability.

## Summary

The LOGNORMDIST function calculates the cumulative lognormal distribution of a value, given a mean and standard deviation. It is available for backward compatibility.

• The LOGNORMDIST function returns the cumulative lognormal distribution of a variable and is used to analyze data that has been logarithmically transformed.
• The new LOGNORMDIST functions provide improved accuracy.