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**:

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