NORMSDIST
TheNORMSDIST
function returns the area under a normal distribution curve to the left of a specified value. This function is commonly used in statistics to calculate probabilities.
 How to use
NORMSDIST
formula?  Examples of using
NORMSDIST
formula NORMSDIST
formula not working? Similar formulas to
NORMSDIST
Usage
Use the NORMSDIST
formula with the syntax shown below, it has 1 required parameter:
 x (required):
The value for which you want to calculate the area under the normal distribution curve.
Examples
Here are a few example use cases that explain how to use theNORMSDIST
formula in Google Sheets.
Calculate the probability of a value from a normal distribution
You can use the NORMSDIST
function to calculate the probability of a value from a normal distribution by providing the value as the x
argument.
Calculate the zscore of a value from a normal distribution
If you know the mean and standard deviation of a normal distribution, you can use the NORMSDIST
function to calculate the zscore of a value by subtracting the mean from the value and dividing the result by the standard deviation.
Calculate the critical value of a normal distribution
You can use the NORMSDIST
function to calculate the critical value of a normal distribution for a given level of significance by finding the value of x
such that NORMSDIST(x) = α/2
, where α
is the level of significance.
Common Mistakes
NORMSDIST
not working? Here are some common mistakes people make when using the NORMSDIST
Google Sheets Formula:
Incorrect use of arguments
One common mistake is to use the wrong type or number of arguments. The NORMSDIST function only takes one argument, which should be a numerical value. If you provide more than one argument or a nonnumerical value, you will get an error.
Missing parentheses
Another common mistake is to forget to use parentheses around the argument. The correct syntax for the NORMSDIST function is NORMSDIST(x), where x is the numerical value you want to evaluate. If you forget the parentheses, you will get an error.
Incorrect range reference
Sometimes users mistakenly reference a range of cells instead of a single cell. The NORMSDIST function only works with a single value, so if you reference a range of cells, you will get an error. Make sure you reference a single cell that contains the value you want to evaluate.
Mistakenly using NORMDIST instead
NORMDIST is a similar function to NORMSDIST, but it returns the probability density function instead of the cumulative distribution function. If you mistakenly use NORMDIST instead of NORMSDIST, you will get a different result than what you intended.
Incorrect interpretation of the result
One common mistake is to misinterpret the result returned by the NORMSDIST function. The function returns a probability value between 0 and 1, which represents the area under the standard normal curve to the left of the given value. Some users may interpret this value as a percentage or a decimal, which can lead to incorrect conclusions.
Related Formulas
The following functions are similar to NORMSDIST
or are often used with it in a formula:

NORMSINV
The
NORMSINV
function calculates the inverse of the standard normal cumulative distribution for a specified value of x. It is commonly used in statistical analysis to transform data from a normal distribution to a standard normal distribution with a mean of 0 and a standard deviation of 1. 
NORMDIST
The
NORMDIST
function in Google Sheets calculates the normal distribution for a specified value, mean, and standard deviation. It returns the probability of a value occurring within a specified range of a normal distribution. It is commonly used in statistics, finance, and science to analyze data and make predictions. 
NORMINV
The
NORMINV
function returns the inverse of the normal cumulative distribution for a specified value, mean, and standard deviation. It is commonly used in statistics to find the value at which a given percentage of observations lie below that value.
Learn More
You can learn more about the NORMSDIST
Google Sheets function on Google Support.