# WorksheetFunction.Norm_S_Inv Method (Excel)

Office 2010

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

## Version Information

Version Added: Excel 2010

## Syntax

expression .Norm_S_Inv(Arg1)

expression A variable that represents a WorksheetFunction object.

### Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

Double

Probability - A probability corresponding to the normal distribution.

Double

## Remarks

• If probability is non-numeric, NORM_S_INV returns the #VALUE! error value.

• If probability < 0 or if probability > 1, NORM_S_INV returns the #NUM! error value.

Given a value for probability, NORM_S_INV seeks that value z such that NORM_S_DIST(z) = probability. Thus, precision of NORM_S_INV depends on precision of NORM_S_DIST. NORM_S_INV uses an iterative search technique. If the search has not converged after 100 iterations, the function returns the #N/A error value.