LOGNORM.INV function

LOGNORM.INV(probability, mean, standardDeviation) LOGNORM.INV(probability; mean; standardDeviation)

probability — Number or { Number }

A probability associated with the lognormal distribution.

mean — Number or { Number }

The mean of the natural logarithm of the probability parameter.

standardDeviation — Number or { Number }

The standard deviation of the natural logarithm of the probability parameter.

Returns — Number or { Number }

The inverse of the LOGNORM.DIST function.

Returns the inverse of the LOGNORM.DIST function.

Example

LOGNORM.INV(0.5, 0, 1)LOGNORM.INV(0,5; 0; 1)

Returns 1.