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

Argument

Description

Remarks

probability

A probability associated with the lognormal distribution.

• If this argument is equal to or less than zero, this function returns the #NUM! error value.

• If this argument is equal to or greater than 1, this function returns the #NUM! error value.

• If this argument is nonnumeric, this function returns the #VALUE! error value.

mean

A mean of ln(x).

• If this argument is nonnumeric, this function returns the #VALUE! error value.

standard_dev

The standard deviation of ln(x).

• If this argument is equal to or less than zero, this function returns the #NUM! error value.

• If this argument is nonnumeric, this function returns the #VALUE! error value.

## Example

To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.

 1 2 3 4
 A B Data Description 0.039084 Probability that is associated with the lognormal distribution 3.5 Mean of ln(x) 1.2 Standard deviation of ln(x) Formula Description (Result) =LOGNORM.INV(A2,A3,A4) Inverse of the lognormal cumulative distribution function for the terms in the table (4.000025)
 Rate this content: