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

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

## Excel NORM.INV Function:

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

In this post, we are going to see the usage of **Excel NORM.INV 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.INV Function – Description:**

- This function **returns the inverse of the normal distribution for the specified mean and standard deviation**.
- 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.INV(probability,mean, standard\_dev)**

### Arguments Explanation:

**Probability – ** It is the probability corresponding to a normal distribution.

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

**Standard\_dev – ** It is the standard deviation of the distribution.

### Note:

- If any argument is **non-numeric values** such as **letters** or **special**  **characters** , then it returns[**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).
- If the **probability is less than or equal to 0 or greater than or equal to 1** , then this function returns [**#NUM!**  **Error**](https://geekexcel.com/how-to-fix-num-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 quickly.

### Example 1:

- In the below screenshot, you can see the **input probability values** in **Column B,** and its mean value is given in **Cell F3** , the **standard**  **deviation** value is printed in **Cell F4.**

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

### Example 2:

- If any argument is **non-numeric values** such as **letters** or **special**  **characters** , then it 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-73.png)<figcaption id="caption-attachment-14305">Example 2</figcaption>

### Example 3:

- If the **probability is less than or equal to 0 or greater than or equal to 1** , then this function 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-35.png)<figcaption id="caption-attachment-14306">Example 3</figcaption>

From the above examples, you can learn how to find an **inverse of normal distribution** using **NORM.INV** Function.

## Closure:

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

### Similar Functions:

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

### Read Ahead:

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