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.