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:


Excel Function Syntax



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.


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