Formulas > =NORM.S.DIST()

How To Use NORM.S.DIST() Function in Google Sheets



Common Questions about the NORM.S.DIST Formula:

1. What is the NORM.S.DIST formula?
2. What does the NORM.S.DIST formula do?
3. How do I use the NORM.S.DIST formula?

How to use the NORM.S.DIST Formula Appropriately:

1. The NORM.S.DIST formula can be used to calculate the probability of an observation falling below a certain value, given a standard normal distribution.
2. The NORM.S.DIST formula takes two arguments: the value for which to get the probability (""x"") and an optional parameter that allows the user to specify whether the lower (0) or upper (1) tail of the normal distribution should be used.
3. The formula should be used with other available statistic formulas to derive a full understanding of the data set.

How the NORM.S.DIST Formula can be Commonly Mistyped:

1. Using NORM.DIST instead of NORM.S.DIST (NORM.DIST works with a binomial distribution).
2. Reversing the arguments so that the value is on the right and the option on the left.
3. Omitting the optional argument, which defaults to 0.

Common Ways the NORM.S.DIST Formula is Used Inappropriately:

1. Using the NORM.S.DIST formula without understanding the underlying normal distribution or the expected outcome of the calculation.
2. Using the NORM.S.DIST formula to calculate the probability of an observation that falls below a certain value, when the value is actually higher than the observation (this is often the result of reversing the arguments).
3. Using the NORM.S.DIST formula incorrectly, such as supplying a value that is outside the range of the normal distribution, or a value that is so large or small as to be statistically improbable.

Common Pitfalls When Using the NORM.S.DIST Formula:

1. Not understanding the normal distribution and expected results for the formula.
2. Not understanding the logic behind the optional argument included with the NORM.S.DIST formula (i.e. whether the lower or upper tail of the distribution should be used).
3. Reversing the arguments and incorrect usage of the optional argument.

Common Mistakes When Using the NORM.S.DIST Formula:

1. Not reading the formula correctly and providing incorrect values.
2. Not accounting for the optional parameters when setting up the formula.
3. Omitting the optional parameters.

Common Misconceptions People Might Have with the NORM.S.DIST Formula:

1. That the calculation is based on a binomial distribution, instead of a standard normal distribution.
2. That the NORM.S.DIST formula must be used to calculate the probability of an observation that falls below a certain value, when in fact the optional argument allows for calculation of an upper tail probability.
3. That the NORM.S.DIST formula can give accurate results outside the range of the normal distribution.

How To Actually Use NORM.S.DIST() in Sheets


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 NORM.S.DIST() formula:


This video shows the use of ARRAYFORMULA to generate the datasets of Google Sheets NORMSDIST, NORMDIST, GAUSS and ERF

Generate a NORM.S.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.