NORMDIST

Definition: NORMDIST is a function that returns the normal distribution for a specified mean and standard deviation.

Syntax: =NORMDIST(x, mean, standard_dev, cumulative)

Situation: This formula is appropriate when you need to calculate the normal distribution for a specified mean and standard deviation.

Example: If you have a normal distribution with a mean of 10 and a standard deviation of 2, and want to find the probability of a value between 8 and 12, the formula =NORMDIST(12, 10, 2, TRUE) – NORMDIST(8, 10, 2, TRUE) can be used, which returns 0.6827.