LOGINV function
LOGINV returns the value whose lognormal cumulative probability equals a given probability, such as percentiles of prices or incomes. It is a compatibility function; LOGNORM.INV replaces it in new workbooks.
Example
Read it as a sentence: find the value at the 0.5 point of a log-normal distribution with mean 1 and standard deviation 0.5, which gives 2.718281828.
A
B
C
D
1
2.718281828
2
3
Syntax
LOGINV(probability, mean, standard_dev)
-
probability(required) - Cumulative probability between 0 and 1.
-
mean(required) - Mean of ln(x).
-
standard_dev(required) - Standard deviation of ln(x).
Returns: The x whose lognormal cumulative probability equals the input.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=LOGINV(0.5,1,0.5) | 2.718281828 | Working example |
=LOGINV("0.5",1,0.5) | 2.718281828 | Text-number in first arg |
=LOGINV({0.5,0.5},1,0.5) | 2.718281828 | Array in first arg (lifts, spills) |
=LOGINV("abc",1,0.5) | #VALUE! | Non-numeric text in first arg |
=LOGINV(NA(),1,0.5) | #N/A | Error in first arg |
=LOGINV(0,1,0.5) | #NUM! | Probability 0 |
=LOGINV(1,1,0.5) | #NUM! | Probability 1 |
=LOGINV(0.5,1,0) | #NUM! | Sd 0 |
Watch out for
- Superseded by LOGNORM.INV; use that in new workbooks.
- mean and standard_dev describe the logarithm of the data, not the raw data.
Where it works
- Excel
- LOGINV is in every version of Excel from 2007 on. Compatibility function: still works in every version, but newer replacements exist.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Compatibility functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .