Formulas and functions > Functions from A to Z > GAUSS (standard normal distribution)

Syntax:

GAUSS(x)

Description:

This returns the integral of the PHI function (density function of a standard normal distribution) minus 0.5.

Compatibility notes:

Microsoft Excel supports this function only in version 2013 or later. The function is unknown in older versions.

We thus recommend that you use the NORMSDIST function instead, since it is compatible with all versions of Excel:

GAUSS(x) equals NORMSDIST(x) - 0.5