NORMSDIST Function

Basic Description

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.

 Formulas:

Examples of use of the Excel Normsdist Function

 Results:

Excel Normsdist Function Results

 

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

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment