ExcelFlux

NORM.INV function

the inverse of the normal cumulative distribution.

Compatibility · Excel 2010+

Where can you use it?

Teams maintaining legacy workbooks. Compare the example inputs and expected results with the formula in your workbook when checking a calculation made in an older version.

Scenario in the workbook

Find the cutoff for a normally distributed score at the given probability. The probability refers to the lower tail.

A worked example from the workbook

RowA
6Probability
70.1
80.5
90.9
Record 1
=NORM.INV(A7,100,15)

Expected result80.77672652

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=NORM.INV(0.5,100,15)
Turkish Excel · tr-TR
=NORM.TERS(0,5;100;15)

Expected result

100

Compatibility function for older workbooks.

Worked examples

Find the cutoff for a normally distributed score at the given probability. The probability refers to the lower tail.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A
6 Probability
7 0.1
8 0.5
9 0.9
Case Formula Expected result
Record 1 =NORM.INV(A7,100,15) 80.77672652
Record 2 =NORM.INV(A8,100,15) 100
Record 3 =NORM.INV(A9,100,15) 119.2232735
Microsoft Excel reference