How to Use Excel NORM.S.DIST Function in Office 365? – [with Examples]
Tags: excelfunctions, excelnormsdistfuncti
Published: 2020-09-21 12:20:53

---
title: How to Use Excel NORM.S.DIST Function in Office 365? – [with Examples]
published: true
date: 2020-09-21 09:27:41 UTC
tags: ExcelFunctions,ExcelNORMSDISTFuncti
canonical_url: https://geekexcel.com/how-to-use-excel-norm-s-dist-function-in-office-365-with-examples/
---

## NORM.S.DIST Function:

![NORM.S.DIST Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/EXCEL_9oMVLLgCQK.png)<figcaption id="caption-attachment-14374">NORM.S.DIST Function</figcaption>

In this post, we are going to explore how to use **Excel NORM.S.DIST Function in Office 365** with its syntax, explanation, and examples. Let’s get into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## **NORM.S.DIST Function – Explanation:**

- This function **returns the standard normal distribution**.
- NORM.S.DIST Function returns values for the **standard** **normal probability density function (PDF)**, **standard normal cumulative distribution function (CDF)**.
- This distribution considers **mean value as 0** and a **standard deviation value as 1**.

## Syntax:

**=NORM.S.DIST(z,cumulative)**

### Arguments Explanation:

**z – ** The input value to which you want to find the distribution.

**Cumulative –** The boolean value that represents the form of the function. If it is **TRUE** , this function returns the cumulative distribution function ( **CDF** ). If it is **FALSE** , it returns the probability density function ( **PDF** ).

### Note:

- If the argument **z** is non-numeric values such as **letters** , and **symbols** , then this function returns [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).

## Examples:

Let’s see some examples to make you understand how NORM.S.DIST function will work.

### Example 1:

- In the below screenshot, you can see the **input ranges in Column B & E** , its **output CDF values are listed in Columns C and PDF values are displayed in Column F.**
- To find **CDF values** , you have to give **boolean value as TRUE**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-80.png)<figcaption id="caption-attachment-14338">Example 1</figcaption>

- In the below screenshot, you can see the output **PDF**  **values** in **Column**  **G**. To get PDF values, you need to give the boolean value as **FALSE**.

![Probability Density Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/new.png)<figcaption id="caption-attachment-14376">Probability Density Function</figcaption>

### Example 2:

- If the argument **z** is non-numeric values such as **letters** , and **symbols** , then this function returns [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-75.png)<figcaption id="caption-attachment-14339">Example 2</figcaption>

From the above examples, you can understand how to give inputs to this function and get the proper result.

## Verdict:

In this post, you can learn the usage of **Excel NORM.S.DIST Function in Office 365** with its syntax, explanation, and examples. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Functions:

- [**NORM.DIST Function**](https://geekexcel.com/how-to-use-excel-norm-dist-function-in-office-365-with-examples/)
- [**NORM.INV Function**](https://geekexcel.com/how-to-use-excel-norm-inv-function-in-office-365-with-examples/)
- [**NORM.S.INV Function**](https://geekexcel.com/how-to-use-excel-norm-s-inv-function-in-office-365-with-examples/)

### See Also:

- [How to Use Excel STDEVA Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-stdeva-function-in-office-365-with-examples/)
- [How to Use “Excel RAND Function” in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-rand-function-in-office-365-with-examples/)