Returns the inverse of the lognormal distribution.
LOGNORM.INV(Number; Mean; StDev)
Number (required) is the probability value for which the inverse standard logarithmic distribution is to be calculated.
Mean (required) is the arithmetic mean of the standard logarithmic distribution.
StDev (required) is the standard deviation of the standard logarithmic distribution.
This function is identical to LOGINV and was introduced for interoperability with other office suites.
=LOGNORM.INV(0.05;0;1) returns 0.1930408167.