Functions
GAUSS
NORM.S.DIST(x,TRUE) - 0.5
Try it
When to use it
When should I use GAUSS?
Use GAUSS to get the probability that a standard normal variable falls between 0 and x, equivalent to NORM.S.DIST(x,TRUE) - 0.5, useful in symmetric probability calculations.
Used in
Syntax
GAUSS(x)Examples
=GAUSS(1) // => 0.34134474606854304
=GAUSS(-1) // => -0.34134474606854304