The Excel NORMSDIST function calculates the Standard Normal Cumulative Distribution Function for a supplied value.
Syntax: NORMSDIST( z )
Where z is the value at which you want to calculate the function.
Normsdist Function Examples
The spreadsheet below shows examples of the Excel Normsdist Function, used to calculate the Standard Normal Cumulative Distribution Function for 3 different values.
The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.
Normsdist Function Error
If you get an error from the Excel Normsdist function this is likely to be the #VALUE! error:
|#VALUE!||–||Occurs if the supplied argument is not recognised as a numeric value|