WorksheetFunction.NormSDist Method

Excel Developer Reference

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.

Syntax

expression.NormSDist(Arg1)

expression   A variable that represents a WorksheetFunction object.

Parameters

Name	Required/Optional	Data Type	Description
Arg1	Required	Double	Z - the value for which you want the distribution.

Return Value
Double

Remarks

• If z is nonnumeric, NORMSDIST returns the #VALUE! error value.

• The equation for the standard normal density function is:

  

See Also

• WorksheetFunction Object
• WorksheetFunction Object Members