Home › Functions › Compatibility › LOGINV
fx
LOGINV
Compatibility  ·  Since: Excel 2003  ·  9 languages

Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard_dev. If p = LOGNORMDIST(x,...) then LOGINV(p,...) = x.

🌐 Translations

English LOGINV
Deutsch LOGINV
Français LOI.LOGNORMALE.INVERSE
Español DISTR.LOG.INV
Italiano INV.LOGNORM
Português INVLOG
Nederlands LOG.NORM.INV
Polski ROZKŁAD.LOG.ODW
Русский ЛОГНОРМОБР

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

LOGINV(probability,mean,standard_dev)

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

▶ Examples

=LOGINV(A2,A3,A4)

Related functions

Copied to clipboard