In Excel 2010, the NORMSDIST function has been replaced by the NORM.S.DIST function, which can calculate the both the probability density function and the cumulative distribution function, (whereas the Normsdist function only calculates the cumulative distribution function).
The Excel NORMSDIST function calculates the Standard Normal Cumulative Distribution Function for a supplied value.
The format of the function is:
Where z is the value at which you want to calculate the function.
In the spreadsheets below, Excel Normsdist Function is used to calculate the Standard Normal Cumulative Distribution function at 3 different values of z.
Further information and examples of the Excel Normsdist function can be found on the Microsoft Office website.
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.|