Statistical

GAUSS Function in Excel

Returns 0.5 less than the standard normal cumulative distribution.

Syntax

  • =GAUSS(z)

Arguments

  • z (required): The value for which you want the distribution

Examples

  • =GAUSS(2) - Probability between mean and 2 std devs - Result: 0.4772
  • =GAUSS(1) - Probability between mean and 1 std dev - Result: 0.3413

GAUSS for data analysis

  • Confirm whether you need entire columns, filtered subsets, or distinct values.
  • Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
  • Pivot tables complement single-cell statistical formulas for exploration.

Common errors

  • Returns probability from mean to z, not cumulative

Use cases

  • Statistical analysis
  • Probability calculations
  • Quality control

Frequently asked questions

  • What is the GAUSS function in Excel? GAUSS returns 0.5 less than the standard normal cumulative distribution. The syntax is =GAUSS(z). Typical use cases include statistical analysis, probability calculations, quality control.
  • How do I use the GAUSS function? To use GAUSS, type =GAUSS( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
  • What type of data does GAUSS work with? GAUSS works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.
  • Why is GAUSS not working in my Excel? Common issues with GAUSS include Returns probability from mean to z, not cumulative. Start by checking the syntax =GAUSS(z), then verify each referenced cell or range.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.