# The Excel GAUSS Function

Related Function:
NORM.S.DIST

## Function Description

The Excel GAUSS function returns the probability that a member of a standard normal population will fall between the mean and a specified number of standard deviations from the mean.

Note: The Gauss function is new in Excel 2013 and so is not available in earlier versions of Excel.

The syntax of the function is:

GAUSS( z )

where the z argument is the real number at which you want to evaluate the Gauss function.

## Gauss Function Examples

Gauss Function for -6 ≤ z ≤ 6

The above chart on the right shows the Gauss Function for values of z between -6 and +6.

In the spreadsheets below, the Excel Gauss function is used to evaluate this function for four different values of z.

Formulas:
A
1=GAUSS( -5 )
2=GAUSS( 0 )
3=GAUSS( 0.1 )
4=GAUSS( 2.5 )
Results:
A
1-0.499999713
20
30.039827837
40.493790335

For further details and examples of the Excel Gauss function, see the Microsoft Office website.

## Gauss Function Errors

If you get an error from the Excel Gauss Function, this is likely to be one of the following:

Common Errors
 #NUM! - Occurs if the supplied value of z is not a valid number. #VALUE! - Occurs if supplied argument is non-numeric.