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

---
title: How to Use Excel NORM.DIST Function in Office 365? – [with Examples]
published: true
date: 2020-09-19 12:14:10 UTC
tags: ExcelFunctions,ExcelNORMDISTFunctio
canonical_url: https://geekexcel.com/how-to-use-excel-norm-dist-function-in-office-365-with-examples/
---

## Excel NORM.DIST Function:

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

In this tutorial, we will guide you to learn how to use **Excel NORM.DIST Function in Office 365** with its syntax, explanation, and examples. 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.DIST Function – Explanation:**

- This function **returns the normal distribution for the specified mean and standard deviation**.
- NORM.DIST Function returns values for the normal **probability density function (PDF)**, normal **cumulative distribution function (CDF)**.
- You can find the mean using the **AVERAGE**  **Function** and find the standard deviation using the [**STDEV**  **Function**](https://geekexcel.com/how-to-use-excel-stdev-function-in-office-365-with-examples/).

## Syntax:

**=NORM.DIST(x,mean, standard\_dev, cumulative)**

### Arguments Explanation:

**x – ** It is the input value to which you want to find the distribution.

**Mean – ** The arithmetic mean of the distribution.

**Standard\_dev – ** It is the standard deviation of 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 **mean** or **standard\_dev** 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/).
- If **standard\_dev is less than or equal to 0** , then it returns [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).

## Examples:

Let’s see some examples to understand this concept easily.

### Example 1:

- In the below screenshot, you can see the **input ranges in Column B & E ** and its  **mean value is given in Cell I4, the standard deviation is given in Cell I5.**
- The **CDF** values are displayed in **Column C** , **PDF** values are printed in **Column F**.

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

### Example 2:

- If the argument **mean** or **standard\_dev** 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-72.png)<figcaption id="caption-attachment-14289">Example 2</figcaption>

### Example 3:

- If **standard\_dev is less than or equal to 0** , then it returns [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).

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

From the above examples, you can clearly learn how to find **CDF** and **PDF** values using **NORM.DIST** Function.

## Summary:

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

### Similar Functions:

- **NORM.S.DIST Function**
- **NORM.INV Function**
- **NORM.S.INV Function**

### See Also:

- [How to Use Excel STDEVPA Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-stdevpa-function-in-office-365-with-examples/)
- [How to Use Excel QUARTILE Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-quartile-function-in-office-365-with-examples/)