LOGNORMDIST function
LOGNORMDIST returns the cumulative lognormal probability up to a value, the chance a lognormally distributed value falls at or below it. It is a compatibility function; LOGNORM.DIST replaces it.
Example
Read it as a sentence: find the cumulative chance at e, the result of EXP(1), for a log-normal distribution with mean 1 and standard deviation 0.5, which gives 0.5.
A
B
C
D
1
0.5
2
3
Syntax
LOGNORMDIST(x, mean, standard_dev)
-
x(required) - Positive value to evaluate.
-
mean(required) - Mean of ln(x).
-
standard_dev(required) - Standard deviation of ln(x).
Returns: Cumulative lognormal probability up to 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 |
|---|---|---|
=LOGNORMDIST(2,1,0.5) | 0.269704931 | Working example |
=LOGNORMDIST("2",1,0.5) | 0.269704931 | Text-number in first arg |
=LOGNORMDIST({2,2},1,0.5) | 0.269704931 | Array in first arg (lifts, spills) |
=LOGNORMDIST("abc",1,0.5) | #VALUE! | Non-numeric text in first arg |
=LOGNORMDIST(NA(),1,0.5) | #N/A | Error in first arg |
=LOGNORMDIST(0,1,0.5) | #NUM! | X 0 |
=LOGNORMDIST(2,1,0) | #NUM! | Sd 0 |
=LOGNORMDIST(Data!D1,1,0.5) | #NUM! | Blank cell as first arg |
The Data sheet these formulas read
A cell that starts with = holds that formula.
D
1
Data
Watch out for
- Superseded by LOGNORM.DIST; use that in new workbooks.
- Cumulative only; LOGNORM.DIST adds the density option.
Where it works
- Excel
- LOGNORMDIST is in every version of Excel from 2007 on. Compatibility function: still works in every version, but newer replacements exist.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Compatibility functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .