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.
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).
If any argument is nonnumeric, LOGNORM.INV returns the #VALUE! error value.
If probability <= 0 or probability >= 1, LOGNORM.INV returns the #NUM! error value.
If standard_dev <= 0, LOGNORM.INV returns the #NUM! error value.
In order to use the LOGNORM.INV formula, start with your edited Excellentable
Then type in the LOGNORM.INV formula in the area you would like to display the outcome:
By adding the values you would like to calculate the LOGNORM.INV formula for, Excellentable will generate the outcome: