Excel functions / Statistics

LOGNORM.INV function

The value below which a given share of a lognormal distribution falls.

Syntax

=LOGNORM.INV(probability, mean, standard_dev)

Arguments

When to use it

LOGNORM.INV gives the value below which a share of a lognormal distribution falls.

Examples

  1. Undo LOGNORM.DIST

    ABCDE
    1pMeanSD
    20.0390843.51.24.000

    In E2: =LOGNORM.INV(A2, B2, C2) → 4.000

    Try this example

Common mistakes

LOGNORM.INV 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

Also written as LOGINV.

Try LOGNORM.INV in the playground

Related functions