Practice free

LOGNORM.DIST function

LOGNORM.DIST returns the lognormal probability or density at a value, for data whose logarithm is normally distributed, such as incomes or prices. Set cumulative to TRUE for the chance of being at or below it.

Example

Read it as a sentence: find the cumulative chance at 4 for a log-normal distribution with mean 3.5 and standard deviation 1.2, which gives 0.039083556.

Practice this in the app

Syntax

LOGNORM.DIST(x, mean, standard_dev, cumulative)

x (required)
The positive value to evaluate the distribution at.
mean (required)
Mean of ln(x).
standard_dev (required)
Standard deviation of ln(x); must be positive.
cumulative (required)
TRUE for the cumulative probability, FALSE for the density at x.

Returns: The lognormal probability (cumulative) or density at x.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=LOGNORM.DIST(4,3.5,1.2,TRUE) 0.039083556 Working example
=LOGNORM.DIST(4,3.5,1.2,FALSE) 0.017617597 Other cumulative flag
=LOGNORM.DIST(4,3.5,1.2,0) 0.017617597 Cumulative as 0
=LOGNORM.DIST("4",3.5,1.2,TRUE) 0.039083556 Text-number in first arg
=LOGNORM.DIST({4,4},3.5,1.2,TRUE) 0.039083556 Array in first arg (lifts, spills)
=LOGNORM.DIST("abc",3.5,1.2,TRUE) #VALUE! Non-numeric text in first arg
=LOGNORM.DIST(NA(),3.5,1.2,TRUE) #N/A Error in first arg
=LOGNORM.DIST(0,3.5,1.2,TRUE) #NUM! X 0

Watch out for

  • mean and standard_dev describe the logged data, not the raw values.
  • x of zero or less gives #NUM!.

Where it works

Excel
LOGNORM.DIST arrived in Excel 2010. Older versions do not have it.
Google Sheets
Same name, same behaviour for everyday use.

Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .