Syntax
LOGINV(probability, mean, standard_dev)
| Parameter | Description |
|---|---|
| probability | Parameter of the LOGINV function. |
| mean | Parameter of the LOGINV function. |
| standard_dev | Parameter of the LOGINV function. |
Examples
Median income from lognormal model
Formula
=LOGINV(0.5, 10.8, 0.7)
Returns ~49,021. The median income in this lognormal model is about $49K — note the median of a lognormal equals e^mean.
90th percentile equipment lifespan
Formula
=LOGINV(0.9, LN(5000), 0.4)
Returns ~8,342. 90% of equipment units are expected to last fewer than about 8,342 hours.
5th percentile for risk analysis
Formula
=LOGINV(0.05, 3.5, 1.2)
Returns ~4.68. Only 5% of outcomes fall below this value, useful as a worst-case floor in Monte Carlo simulations.
Common Errors
#NUM!
Probability must be between 0 and 1 (exclusive), and standard_dev must be positive.
#VALUE!
Occurs when arguments are non-numeric.
Tips
Use LOGNORM.INV instead
LOGINV is the legacy compatibility function. LOGNORM.INV is the modern replacement with the same behavior.
Median shortcut
LOGINV(0.5, mean, std) always equals EXP(mean) because the median of a lognormal distribution is e raised to the mean of the underlying normal.
Pair with LOGNORMDIST
These are inverse functions: LOGINV(LOGNORMDIST(x, m, s), m, s) returns x. Use them together to convert between values and probabilities.
Try LOGINV in Viztab
Import your data and use LOGINV with 370+ other formulas. No signup required.
Open Viztab