Functions
NORM.S.DIST
Standard normal CDF/PDF
Try it
When to use it
When should I use NORM.S.DIST instead of NORM.DIST?
Use NORM.S.DIST when your data is already standardised (z-scores with mean=0 and stdev=1). It is a shorthand for NORM.DIST(x,0,1,cumulative) and is commonly used after computing a z-score manually.
Used in
Syntax
NORM.S.DIST(x,cumulative)Examples
=NORM.S.DIST(2.4,TRUE) // => 0.9918024640754037
=NORM.S.DIST(2.4,FALSE) // => 0.0223945302948429