# WorksheetFunction.Norm_Inv Method (Excel)

Office 2010

Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.

## Syntax

expression .Norm_Inv(Arg1, Arg2, Arg3)

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.

Arg2

Required

Double

Mean - The arithmetic mean of the distribution.

Arg3

Required

Double

Standard_dev - The standard deviation of the distribution.

Double

## Remarks

• If any argument is non-numeric, NORM_INV returns the #VALUE! error value.

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

• If standard_dev ≤ 0, NORM_INV returns the #NUM! error value.

• If mean = 0 and standard_dev = 1, NORM_INV uses the standard normal distribution (see NORM_S_INV).

Given a value for probability, NORM_INV seeks that value x such that NORM_DIST(x, mean, standard_dev, TRUE) = probability. Thus, precision of NORM_INV depends on precision of NORM_DIST.