[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

NORMSDIST

Syntax:

NORMSDIST ( z )

Description: Computes the standard normal distribution for the specified mean and standard deviation.

Mathematical Formula:

Arguments:

Name

Type

Description

z

number

The value for which the distribution is to be computed.

 

Return Type and Value: number – The standard normal distribution for the specified mean and standard deviation.

[Example:

NORMSDIST(1.333333) results in 0.90878873
NORMSDIST(-1.5) results in 0.06680720

end example]