Practice free

GAUSS function

GAUSS returns the probability that a standard normal value lies between 0 and z, the area under the curve from the mean out to z. It is 0.5 less than the cumulative NORM.S.DIST.

Example

Read it as a sentence: find how much of a standard bell curve lies between the middle and 1 standard deviation above it, which gives 0.341344746.

Practice this in the app

Syntax

GAUSS(z)

z (required)
A standard normal z-score.

Returns: The probability that a standard normal value lies between 0 and z.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=GAUSS(1) 0.341344746 Working example
=GAUSS("1") 0.341344746 Text-number in first arg
=GAUSS({1,1}) 0.341344746 Array in first arg (lifts, spills)
=GAUSS(-1) -0.341344746 Negative
=GAUSS(0) 0 Zero
=GAUSS(40) 0.5 Large
=GAUSS("abc") #VALUE! Non-numeric text in first arg
=GAUSS(NA()) #N/A Error in first arg

Watch out for

  • Equals NORM.S.DIST(z,TRUE) minus 0.5.
  • Negative z gives a negative result.

Where it works

Excel
GAUSS arrived in Excel 2013. Older versions do not have it.
Google Sheets
Same name, same behaviour for everyday use.

Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .