# LOGNORM.INV

## Content

This function returns the inverse of the lognormal cumulative distribution function of *x*, where LN( *x* ) is normally distributed with the specified mean and standard deviation.

## Syntax

`LOGNORM.INV(prob, mean, stdev)`

## Arguments

This function has these arguments:

| Argument | Description |
| -------- | ----------- |
| *prob* | [Required] Value at which to evaluate the function |
| *mean* | [Required] Value of mean of the natural logarithm of x, LN(x) |
| *stdev* | [Required] Value representing the standard deviation of LN(x) |

## Remarks

This function calculates the inverse of the lognormal cumulative distribution functions, so if *p*  = LOGNORM.DIST( *x*, ...) then LOGNORM.INV( *p* ,...) =  *x* . The #VALUE! error value is returned if any argument is non-numeric.

## Examples

`LOGNORM.INV(0.92,B8,G22)`
`LOGNORM.INV(0.88,2,1.2)` gives the result 30.264764580330958