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

LOGNORM.INV

Returns the inverse of the lognormal cumulative distribution function.

Sample Usage

LOGNORM.INV(0.5,4,6)
LOGNORM.INV(A2,A3,A4)


Syntax

LOGNORM.INV(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

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