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

**Note**:

- #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.

- #VALUE! error – Occurs when any of the given arguments is non-numeric.
- 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.