How to use LOGNORM.INV Function in Excel

The LOGNORM.INV function returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters Mean and Standard_dev.

If p = LOGNORM .DIST(x…) then LOGNORM.INV (p…) = x. Use the lognormal distribution to analyze logarithmically transformed data.

Syntax:= LOGNORM.INV(probability, mean, standard_dev)

The LOGNORM.INV function syntax has the following arguments:

  • Probability    Required. A probability associated with the lognormal distribution.
  • Mean    Required. The mean of ln(x).
  • Standard_dev    Required. The standard deviation of ln(x).

Example: Let’s look at some Excel LOGNORM.INV function examples and explore how to use the LOGNORM.INV function as a worksheet function in Microsoft Excel:

Suppose we are given the following data:

Using the probability, mean, and standard deviation given above, the formula for calculating the inverse of lognormal cumulative distribution is shown below:

Syntax: =LOGNORM.INV(B1,B2,B3)

Result: 9.722271014


  1. #NUM! error – Occurs when:
    • The argument x given is less than or equal to zero; or
    • The argument standard_dev is less than or equal to zero.
  2. #VALUE! error – Occurs when any of the given arguments is non-numeric.
  3. The LOGNORM.INV function was introduced in Excel 2010 and hence is unavailable in earlier versions. For older versions, we can use the LOGINV function.


Add a Comment

Your email address will not be published. Required fields are marked *