WorksheetFunction.Norm_S_Dist (Excel)

Returns the standard normal cumulative distribution function. The distribution has a mean of 0 (zero) and a standard deviation of one. Use this function in place of a table of standard normal curve areas.

If z is non-numeric, Norm_S_Dist returns the #VALUE! error value. The equation for the standard normal cumulative distribution function is:

Norm_S_Dist (Arg1, Arg2)

Dim dblArg1 As Double: dblArg1 = 
Dim dblNorm_S_Dist As Double
dblNorm_S_Dist = WorksheetFunction.Norm_S_Dist(Arg1:=dblArg1, Arg2:=True)


Arg1, Arg2

Arg1 (Double) - Z - The value for which you want the distribution.

Arg2 (Boolean) - Cumulative - A logical value that determines the form of the function. If cumulative is True, Norm_S_Dist returns the cumulative distribution function; if False, it returns the probability mass function.