GAUSS (Number) GAUSS (Number)
Number
Number Number
The number for which to perform the calculation.
Returns
Number Number
The probability that a value drawn from the standard normal distribution lies between 0 and the given number.
Returns the probability that a value drawn from the standard normal distribution lies between 0, the mean, and the given number. The result is identical to invoking NORM.S.DIST with TRUE as its IsCumulative parameter and subtracting 0.5.
Examples
GAUSS (0.19)
GAUSS (0,19)
Returns roughly 0.075.
GAUSS (0.0375)
GAUSS (0,0375)
Returns roughly 0.0150.