Formualizer Docs

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

ArgumentTypeRequiredDefault
xnumberRequired—
meannumberRequired—
standard_devnumberRequired—

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! when x <= 0 or standard_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?.

Implementation

Engine source

On this page