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

`=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.

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.

The LOGNORMDIST function calculates the cumulative lognormal distribution of a value. It is useful for analyzing data that has been logarithmically transformed.

The new LOGNORMDIST functions provide improved accuracy and are named more accurately to reflect their usage.

The new LOGNORMDIST functions are available in Sourcetable now, and may be available in future versions of Excel.

Drop CSV