Article updated on April 16, 2018

The NORM.INV function calculates the inverse of the normal cumulative distribution for a given mean and standard deviation.

Formula in cell C7:

=NORM.INV(C2,C3,C4)

Excel Function Syntax

NORM.INV(probabilitymeanstandard_dev)

Arguments

probability Required. A probability corresponding to the normal distribution.
mean Required. The average of the distribution.
standard_dev Required. The standard deviation of the distribution.

Comments

NORM.INV returns

  • #VALUE! if argument is non-numeric.
  • #NUM! if standard_dev ≤ 0
  • #NUM! if probability <= 0 or if probability >= 1
  • the standard normal distribution if mean = 0 and standard_dev = 1