NORM.S.DIST Function in LibreOffice Calc — Tested Examples
An explanation of LibreOffice Calc NORM.S.DIST, including tested formulas, examples, expected results and common mistakes.
Tested: Examples checked in LibreOffice Calc 25.2.3.2. What this means
The values of the standard normal distribution. At z=0, cumulative probability is 0.5, while probability density is approximately 0.39894228.
Syntax and arguments
=NORM.S.DIST(Number; Cumulative)
LibreOffice Calc formulas generally separate arguments with semicolons (;).
| Argument | Explanation |
|---|---|
Number |
The value for which the standard normal distribution is to be calculated. |
Cumulative |
0 or FALSE calculates the probability density function. Any other value or TRUE calculates the cumulative distribution function. |
Worked examples
Example 1: Find the standard normal cumulative probability at zero
=NORM.S.DIST(0;TRUE())
Expected result: 0.5. This value was returned in the LibreOffice Calc 25.2 test.
Example 2: Standard normal probability density at zero
=NORM.S.DIST(0;FALSE())
Expected result: 0.3989422804014327. This value was returned in the LibreOffice Calc 25.2 test.
How to interpret the result
At z=0, cumulative probability is 0.5, while probability density is approximately 0.39894228.
Mistakes and troubleshooting
- Check inputs and assumptions: A density is not the probability of a particular exact numeric outcome. Use cumulative differences for interval probabilities.
- Check argument order and format: Strings go in quotes, cell references do not. Functions that return arrays may require special entry.
- Verify your own data: Reproduce the example first. If your formula returns an error, inspect the referenced cells and individual argument values.
Related functions
Tested version and primary reference
2 example(s) on this page passed real calculations in LibreOffice Calc 25.2.3.2. This is not a claim about every possible input or other spreadsheet applications.