Formulas > =LOGNORM.DIST()

How To Use LOGNORM.DIST() Function in Google Sheets



Common Questions About the LOGNORM.DIST Formula:
• What is LOGNORM.DIST and how is it used?
• What are the parameters of LOGNORM.DIST?
• How can LOGNORM.DIST be used to calculate probability?

How Can the LOGNORM.DIST Formula Be Used Appropriately?
• To calculate the cumulative probability of a normally distributed variable
• To analyze the log-normal distribution of data
• To evaluate a frequency distribution

How Can the LOGNORM.DIST Formula Be Commonly Mistyped?
• Logormdist
• Logarithmic.dist
• Lognormal.dist

What Are Some Common Ways the LOGNORM.DIST Formula Is Used Inappropriately?
• Not providing parameters in the correct order
• Not providing the correct parameters
• Not formatting the data properly

What Are Common Pitfalls When Using the LOGNORM.DIST Formula?
• Mistyping function names or function parameters
• Not properly specifying a range of probabilities
• Not accounting for outliers

What Are Common Mistakes When Using the LOGNORM.DIST Formula?
• Entering wrong value type
• Using the wrong probability distribution
• Using inappropriate ranges

What Are Common Misconceptions People Might Have with the LOGNORM.DIST Formula?
• Believing that it is the only probability distribution formula available 
• Thinking that the formula works with any data type 
• Believing that it is the only way to calculate probability

How To Actually Use LOGNORM.DIST() in Sheets

LOGNORM.DIST(x, mean, standard_deviation)

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

Learn more about the LOGNORM.DIST() formula:

Google Sheets LOGNORMDIST Log Normal Cumulative Distribution Function NORMSDIST

This video shows the trend line LOGNORMDIST and the use of NORMSDIST and LN to generate the same trend line and data set.

Generate a LOGNORM.DIST() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.