# NORM.S.INV

### Definition

Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.

### Sample Usage

### Syntax

NORM.S.INV(probability)

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

Probability Required. A probability corresponding to the normal distribution.

### Remarks

If probability is nonnumeric, NORMS.INV returns the #VALUE! error value.

If probability <= 0 or if probability >= 1, NORMS.INV returns the #NUM! error value.

Given a value for probability, NORM.S.INV seeks that value z such that NORM.S.DIST(z,TRUE) = probability. Thus, precision of NORM.S.INV depends on precision of NORM.S.DIST. NORM.S.INV uses an iterative search technique.

### In order to use the NORM.S.INV formula, start with your edited Excellentable

### Then type in the NORM.S.INV formula in the area you would like to display the outcome:

### By adding the values you would like to calculate the NORM.S.INV formula for, Excellentable will generate the outcome: