Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelNORM.S.INV Function in Excel

# NORM.S.INV Function in Excel

## NORM.S.INV Function in Excel

The NORM.S.INV function in Excel returns the inverse of the standard normal cumulative distribution, which means the distribution has a mean of zero and a standard deviation of one.

### Syntax

`= NORM.S.INV(probability)`

### Arguments:

• Probability â€“ A probability corresponding to the normal distribution.

## Possible Errors and Usage Notes

• When the probability of the given event occurring below a threshold value, the function returns the z-score of the threshold
• If the argument is a nonnumeric value, the function returns the #VALUE! error value.
• Probability <= 0 or if probability >= 1, then the function will return a the #NUM! error value.
• The probability argument should be on the outside of the range of (0,1), other than that will result in an error.

## How to use the NORM.S.DIST Function in Excel?

Using this function in a Worksheet is simple; all you need to do is enter the function as a formula of the cell in the formula bar.

Take a look at the given example

To find the inverse of the standard normal distribution of the given numbers, enter the numbers in columns A, and in column B enter the following C.

Formula: = NORM.S.DIST(A1,TRUE)

Here, A1 refers to the cell name or the cell address.

When entered, the function gives you the inverse of the normal standard distribution of the given numbers. Follow the same to other cells and you will get the inverse normal distribution for the rest of the numbers.

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021