Excel functions / Statistics
LOGNORMDIST function
The chance of x or less in a lognormal distribution. The older form of LOGNORM.DIST.
Syntax
=LOGNORMDIST(x, mean, standard_dev)
Arguments
x: The value, greater than 0.mean: The mean of ln(x).standard_dev: The standard deviation of ln(x).
When to use it
LOGNORMDIST is the older form of LOGNORM.DIST with TRUE.
Examples
Below 4
A B C D E 1 x Mean SD 2 4 3.5 1.2 0.0391 In E2:
=LOGNORMDIST(A2, B2, C2)→ 0.0391
Common mistakes
- Newer form. LOGNORM.DIST also gives the height of the curve.
LOGNORMDIST in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: LOGNORMDIST
- Danish: LOGNORMFORDELING
- Dutch: LOG.NORM.VERD
- Finnish: LOGNORM.JAKAUMA
- French: LOI.LOGNORMALE
- German: LOGNORMVERT
- Hungarian: LOG.ELOSZLÁS
- Italian: DISTRIB.LOGNORM
- Norwegian: LOGNORMFORD
- Polish: ROZKŁAD.LOG
- Portuguese (Brazil): DIST.LOGNORMAL
- Portuguese (Portugal): DIST.NORMALLOG
- Russian: ЛОГНОРМРАСП
- Spanish: DISTR.LOG.NORM
- Swedish: LOGNORMFÖRD
- Turkish: LOGNORMDAĞ
Try LOGNORMDIST in the playground
Related functions
- LOGNORM.DIST: The lognormal distribution, for values whose logarithm is normally distributed, such as prices and incomes.