September 23, 2023

# How to use NORM.S.INV Function in Excel

The NORMS.S.INV function returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.

Syntax:= NORM.S.INV(probability)

The NORM.S.INV function syntax has the following arguments:

• Probability     Required. A probability corresponding to the normal distribution.

Example: Let’s look at some Excel NORM.S.INV function examples and explore how to use the NORM.S.INV function as a worksheet function in Microsoft Excel: To calculate the inverse of the Standard Normal Cumulative Distribution Function, we will use the following formula:

Syntax:  =NORM.S.INV(A2)

Result: -0.67448975 Based on the Excel spreadsheet above, the following NORM.S.INV examples would return:

Syntax: =NORM.S.INV(A3)
Result: 0.125661347

Syntax: =NORM.S.INV(A4)
Result: 1.281551566

Syntax: =NORM.S.INV(A5)
Result: 1.644853627

Syntax: =NORM.S.INV(A6)
Result: 0

Syntax: =NORM.S.INV(A7)
Result: 0.67448975

Syntax: =NORM.S.INV(A8)
Result: #NUM!

Syntax: =NORM.S.INV(A9)
Result: #NUM!

Syntax: =NORM.S.INV(A10)
Result: #NUM!

Note:

1. #VALUE! error – Occurs if any of the given arguments is non-numeric.
2. #NUM! error – Occurs when the given probability argument is less than zero or greater than one.
3. The precision of NORM.S.INV depends on the precision of NORM.S.DIST. NORM.S.INV uses an iterative search technique.

READ:  How to use WEIBULL.DIST Function in Excel #### Excel

View all posts by Excel →