# NORM.INV

### [data-colorid=zika882mo5]{color:#2f2f2f} html[data-color-mode=dark] [data-colorid=zika882mo5]{color:#d0d0d0}Definition

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

### Syntax

NORM.INV(probability,mean,standard_dev)

The NORM.INV function syntax has the following arguments:

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

• Mean     Required. The arithmetic mean of the distribution.

• Standard_dev     Required. The standard deviation of the distribution.

### Remarks

• If any argument is nonnumeric, 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 NORMS.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.

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

A
1
Data
2
0.908789
3
40
4
1.5
5
6
NORM.INV
B
1
Description
2
Probability corresponding to the normal distribution
3
Arithmetic mean of the distribution
4
Standard deviation of the distribution
5
6
42.00000201
JavaScript errors detected