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

When to use it

LOGNORMDIST is the older form of LOGNORM.DIST with TRUE.

Examples

  1. Below 4

    ABCDE
    1xMeanSD
    243.51.20.0391

    In E2: =LOGNORMDIST(A2, B2, C2) → 0.0391

    Try this example

Common mistakes

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.

Translate a whole formula

Try LOGNORMDIST in the playground

Related functions