LOGNORM.INV function

Category: Statistical
Introduced: Excel 2010

Summary

Returns the inverse of the lognormal cumulative distribution

Syntax

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).

Example

=LOGNORM.INV(A2, A3, A4)

Microsoft Support Page

https://support.microsoft.com/en-us/office/lognorm-inv-function-fe79751a-f1f2-4af8-a0a1-e151b2d4f600

Back to Functions