Related Functions:

The LOGNORM.INV function returns the inverse of the log-normal cumulative distribution function of x,  for a supplied probability, e.g. if p = LOGNORM.DIST(x,…) then LOGNORM.INV(p,…) = x.

  • This function was introduced in Excel 2010 and so is not available in earlier versions.
  • The LOGNORM.INV function replaces the LOGINV function included in earlier versions of Excel.

Syntax

=LOGNORM.INV(probability,mean,standard_dev)

Arguments

Argument Description
probability The value at which you want to evaluate the inverse function
mean The arithmetic mean of ln(x)
standard_dev The standard deviation of ln(x)

Examples

  A B C D
1 Data Description    
2 0.104962 Probability associated with the log-normal distribution    
3 7.5 Mean of ln(x)    
4 4 Standard deviation of ln(x)    
5        
6 Formula Result Notes
7 =LOGNORM.INV(A2,A3,A4) 12 Inverse of the lognormal cumulative distribution function for the terms above

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if any of the the supplied arguments are non-numeric
#NUM! Occurs if either:

  the supplied probability argument is ≤ 0 or ≥ 1
  the supplied standard_dev argument is ≤ 0