Compatibility - LOGNORMDIST Function

The LOGNORMDIST function replaces the LOGNORM.DIST function in Excel 2010.

Description

The function 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.

LOGNORMDIST(x,mean,standard_dev)

Argument	Description	Required/ Optional
X	The value at which to evaluate the function.	Required
Mean	The mean of ln(x).	Required
Standard_dev	The standard deviation of ln(x).	Required

The equation for the lognormal cumulative distribution function is −

$$LOGNORMDIST(x,\mu,\sigma) = NORMDIST(\frac{ln(x) - \mu}{\sigma})$$
If any argument is non-numeric, LOGNORMDIST returns the #VALUE! error value
If x ≤ 0 or if Standard_dev ≤ 0, LOGNORMDIST returns the #NUM! error value

advanced_excel_compatibility_functions.htm