LOGNORMDIST(20:30)
LOGNORMDIST(A2:A6)
LOGNORMDIST(A1:B2,5)
Syntax
LOGNORMDIST(x, mean, standard_deviation)
- x - The input to the lognormal cumulative distribution function.
- mean - The mean (mu) of the lognormal cumulative distribution function.
- standard_deviation - The standard deviation (sigma) of the lognormal cumulative distribution function.
Examples
LOGNORMDIST(20,30) returns a value of 25.
LOGNORMDIST(A2:A6) returns the average of the numbers in cells A2 through A6.
LOGNORMDIST(A1:B2,5) returns the average of the numbers contained in cells A1 through B2 and the number 5.