GAUSS(z)

Returns the 0.5 less than the standard normal cumulative distribution.

zThe number of standard deviations.

Remarks

* Added in Excel 2013.
* If "z" is not numeric, then #NUM is returned.
* Because NORM.D.DIST(0,true) = 0.5, gauss(z) will always be 0.5 less than NORM.S.DIST(z true).
* For the Microsoft documentation refer to support.office.com

 A
1??


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top