Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev. Use this function to analyze data that has been logarithmically transformed.

LOGNORM.DIST takes 3 required arguments and no optional arguments:

Syntax: LOGNORM.DIST(x, mean, standard_dev)

#1)
The arguments for the LOGNORM.DIST function are:
Argument Required? Description
x Required The value at which to evaluate the function.
mean Required The mean of ln(x).
standard_dev Required The standard deviation of ln(x).
comments powered by Disqus