Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

LOGNORMINV

Returns the inverse of the lognormal cumulative distribution function.

Sample Usage

LOGNORMINV(0.5,4,6)
LOGNORMINV(A2,A3,A4)


Syntax

LOGNORMINV(x, mean, standard_deviation)

  • x - The input to the inverse lognormal cumulative distribution function.
  • mean - The mean (mu) of the inverse lognormal cumulative distribution function.
  • standard_deviation - The standard deviation (sigma) of the inverse lognormal cumulative distribution function.

Examples

LOGNORMINV(0.5,4,6) returns a value of 54.59881
LOGNORMINV(A2,A3,A4) returns the inverse of the lognormal cumulative distribution function for the arguments defined.