LOGNORMDIST
Returns the cumulative log-normal distribution (legacy name).
LOGNORMDIST(x, mean, standard_dev) is LOGNORM.DIST(x, mean, standard_dev, TRUE): the
compatibility form has no cumulative argument.
The Formualizer engine in this repository at 0.14.0 plus unreleased changes computes the example results. Known differences from Excel are listed on this page.
Syntax
=LOGNORMDIST(x, mean, standard_dev)
Arguments
| Argument | Type | Required | Default |
|---|---|---|---|
x | number | Required | — |
mean | number | Required | — |
standard_dev | number | Required | — |
How it works
Maps to LOGNORM.DIST with cumulative set to TRUE. Its result is the standard normal CDF of (ln(x) − mean) / standard_dev. The logarithm requires x > 0, and the standard deviation must be positive.
Error cases
- Returns
#NUM!whenx <= 0orstandard_dev <= 0.
Examples
Evaluate the cumulative lognormal distribution above one.
Formula =LOGNORMDIST(2,0,1)
Expected result 0.755891404214417
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Evaluate a point below one with the same distribution parameters.
Formula =LOGNORMDIST(0.5,0,1)
Expected result 0.244108595785583
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
With mean zero and standard deviation one, x = 1 is the median.
Formula =LOGNORMDIST(1,0,1)
Expected result 0.5
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
The lognormal calculation requires a positive observation.
Formula =LOGNORMDIST(0,0,1)
Expected result #NUM!
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Find the cumulative probability at 4 with log-scale mean 3.5 and deviation 1.2.
Formula =LOGNORMDIST(4,3.5,1.2)
Expected result 0.0390835557068005
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.