Formulas > =LOGNORMDIST()

How to Use LOGNORMDIST() in Google Sheets

Description

Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value.

How To Actually Use LOGNORMDIST() in Sheets

LOGNORMDIST(x, mean, standard_deviation)

Try LOGNORMDIST yourself

Use the LOGNORMDIST formula to calculate the log-normal distribution for the value in cell A1, with a mean from B1 and a standard deviation from C1. The result should be placed in cell D1.

Hints (2)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Learn more about the LOGNORMDIST() formula:

Generate a LOGNORMDIST() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses LOGNORMDIST(). 2 free AI generations, no signup. Members get unlimited use.

Generate a LOGNORMDIST() formula