LOGNORM.DIST Function
Returns the lognormal distribution of a value.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
A lognormal distribution describes positive values whose logarithms are bell-shaped — typical for order values, incomes, house prices and task durations: most values are modest, with a long tail of large ones.
mean and standard_dev are the mean and standard deviation of ln(x), not of x itself. Find them with =AVERAGE(LN(range)) and =STDEV.S(LN(range)).
TRUE returns the cumulative probability (the chance of a value up to x); FALSE returns the probability density — the height of the curve, not a probability.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| x | Yes | The value; must be greater than 0. |
| mean | Yes | The mean of ln(x). |
| standard_dev | Yes | The standard deviation of ln(x); must be greater than 0. |
| cumulative | Yes | TRUE for the cumulative probability, FALSE for the density (height of the curve). |
Examples
Example 1 — Orders of $100 or less
Northstar's order values have ln-mean 4 and ln-standard-deviation 0.5 — a median order of about $55.
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | ln mean | 4 |
| 3 | ln std dev | 0.5 |
| 4 | Order value | 100 |
| 5 | P($100 or less) | 0.8869 |
About 89% of orders are $100 or less; 11% are larger.
Common mistakes
- Using the plain mean. mean and standard_dev must describe ln(x). Using the average order value gives nonsense.
- #NUM! x is 0 or negative, or standard_dev is 0 or negative.
Notes
- LOGNORM.DIST replaces the older LOGNORMDIST function.
- Related functions: LOGNORM.INV, NORM.DIST, LN.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.