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

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

## NORM.S.INV Function:

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

In this article, we are going to see how to use **Excel NORM.S.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.S.INV Function – Description:**

- This function **returns the inverse of the standard normal cumulative distribution.**
- This distribution considers the **mean value as 0** and the **standard deviation value as 1**.

## Syntax:

**=NORM.S.INV(probability)**

### Parameter Description:

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

### Note:

- If probability 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/).

## Examples:

Let see some examples to understand how this function works.

### Example 1:

- In the below example image, you can see the **input**  **numbers** are given in **Column**  **B** , and its **output**  **values** are displayed in **Column**  **C**.

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

### Example 2:

- If probability 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-74.png)<figcaption id="caption-attachment-14324">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-36.png)<figcaption id="caption-attachment-14325">Example 3</figcaption>

From the above examples, you can learn how to use the **NORM.S.INV Function**.

## Summary:

In the above article, you can understand the usage of **Excel NORM.S.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**](https://geekexcel.com/how-to-use-excel-norm-s-dist-function-in-office-365-with-examples/)
- [**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/)

### Read Ahead:

- [How to Use Excel NORM.INV Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-norm-inv-function-in-office-365-with-examples/)
- [How to Use Excel EXP Function in Office 365? – [With Examples]](https://geekexcel.com/how-to-use-excel-exp-function-in-office-365-with-examples/)
- [How to Use Excel MAXA Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-maxa-function-in-office-365-with-examples/)