Formulas > =LOGNORM.DIST()
How to Use LOGNORM.DIST() in Google Sheets
Description
How To Actually Use LOGNORM.DIST() in Sheets
LOGNORM.DIST(x, mean, standard_deviation)
Try LOGNORM.DIST yourself
In cells D1:D10, use the LOGNORM.DIST formula to calculate the lognormal distribution for the values in A1:A10, with a mean of 0 and a standard deviation of 1.
Hints (3)
-
Remember to reference the cell for the x value.
-
Set the mean and standard deviation as constants in the formula.
-
Don't forget to specify the cumulative parameter.
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 LOGNORM.DIST() formula:
Generate a LOGNORM.DIST() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses LOGNORM.DIST(). 2 free AI generations, no signup. Members get unlimited use.
Generate a LOGNORM.DIST() formula