LOGINV


Calculates the inverse of the LOGNORMDIST function.

Syntax:

LOGINV(p, μ, σ)

A variable is lognormally distributed if its natural logarithm is normally distributed. Parameters of the distribution are μ (mean) and σ (standard deviation).
LOGINV returns the value x, such that LOGNORMDIST(x, μ, σ) is p.

Example:

LOGINV(0.5, 0, 1)
returns 1.
LOGNORMDIST(1, 0, 1)
returns 0.5.






 
Created with Zapof