LOGNORM.DIST function
LOGNORM.DIST returns the lognormal probability or density at a value, for data whose logarithm is normally distributed, such as incomes or prices. Set cumulative to TRUE for the chance of being at or below it.
Example
Read it as a sentence: find the cumulative chance at 4 for a log-normal distribution with mean 3.5 and standard deviation 1.2, which gives 0.039083556.
A
B
C
D
1
0.039083556
2
3
Syntax
LOGNORM.DIST(x, mean, standard_dev, cumulative)
-
x(required) - The positive value to evaluate the distribution at.
-
mean(required) - Mean of ln(x).
-
standard_dev(required) - Standard deviation of ln(x); must be positive.
-
cumulative(required) - TRUE for the cumulative probability, FALSE for the density at x.
Returns: The lognormal probability (cumulative) or density at x.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=LOGNORM.DIST(4,3.5,1.2,TRUE) | 0.039083556 | Working example |
=LOGNORM.DIST(4,3.5,1.2,FALSE) | 0.017617597 | Other cumulative flag |
=LOGNORM.DIST(4,3.5,1.2,0) | 0.017617597 | Cumulative as 0 |
=LOGNORM.DIST("4",3.5,1.2,TRUE) | 0.039083556 | Text-number in first arg |
=LOGNORM.DIST({4,4},3.5,1.2,TRUE) | 0.039083556 | Array in first arg (lifts, spills) |
=LOGNORM.DIST("abc",3.5,1.2,TRUE) | #VALUE! | Non-numeric text in first arg |
=LOGNORM.DIST(NA(),3.5,1.2,TRUE) | #N/A | Error in first arg |
=LOGNORM.DIST(0,3.5,1.2,TRUE) | #NUM! | X 0 |
Watch out for
- mean and standard_dev describe the logged data, not the raw values.
- x of zero or less gives #NUM!.
Where it works
- Excel
- LOGNORM.DIST arrived in Excel 2010. Older versions do not have it.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .