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.
Syntax:= GAUSS(z)
The GAUSS function syntax has the following arguments:
 Z (required argument) – This is the real number at which we want to evaluate the GAUSS function.
Example: Let’s look at some Excel GAUSS function examples and explore how to use the GAUSS function as a worksheet function in Microsoft Excel:
Syntax: =GAUSS(A2)
Result: 0.499999713
Based on the Excel spreadsheet above, the following GAUSS examples would return:
Syntax: =GAUSS(A2)
Result: 0.499999713
Syntax: =GAUSS(A2)
Result: 0.039827837
Syntax: =GAUSS(A2)
Result: 0.493790335
Syntax: =GAUSS(A2)
Result: 0.477249868
Syntax: =GAUSS(A2)
Result: 0.499968329
Syntax: =GAUSS(A2)
Result: 0.498650102
Syntax: =GAUSS(A2)
Result: 0.341344746
Syntax: =GAUSS(A2)
Result: 0.499999999
Syntax: =GAUSS(A2)
Result: 0.499999942
Note:

 #VALUE! error – Occurs when any of the number arguments that are provided directly to the function are text strings that cannot be interpreted as numbers – that is, the value provided for Z is nonnumeric.
 #NUM! error – Occurs when the given value of Z is an invalid number.
 As NORM.S.DIST(0,True) always returns 0.5, GAUSS(z) will always be 0.5 less than NORM.S.DIST(z,True).
 The GAUSS function is not particularly meaningful for negative values of z. To calculate the probability that something falls in the range of 1.5 to the mean, we need to use the formula =GAUSS(1.5).
 If we use Excel 2010 or earlier versions, the formula is =NORM.S.DIST(z,True)0.5.