NORMINV Function in Excel: Syntax and Examples

This article provides a clear overview of NORMINV Function in Excel, with the main facts, useful context, and practical details organized for easy reading.

What This Feature Does

The function returns the inverse of the cumulative distribution with the standard deviation and a defined mean. The NORMINV function uses the iterative search technique, if the search after 100 times has not converged ? the function returns the value #N/A.

Syntax

NORMINV (probability, mean, standard_dev) .

Arguments

- probability: Probability corresponding to the normal distribution, is a required parameter.

- mean: The average value of the distribution, is a required parameter.

- standard_dev: The standard deviation of the distribution, is a required parameter.

Important Notes

- The parameters in the NORMINV function must be numeric, otherwise the #VALUE!

- Probability value is in the range: 0 < probability <1, otherwise the function returns the #NUM! error value.

- Required value standard_dev> 0, otherwise the error message #NUM!

- Where mean = 0 and standard_dev = 1 ? the distribution becomes the normalized distribution and the NORMINV value of the distribution = NORMSINV value of the distribution.

Example

Calculate the inverse value of the standard cumulative distribution with the following parameters:

in the target cell the value enter the following formula: = NORMINV (C14, C15, C16) .

Press Enter to get the result:

If the NORMINV function has mean = 0 and standard_dev = 1 ? the NORMINV function value is:

This value is exactly equal to the value of the NORMSINV function with the same corresponding probability:

So when the NORMINV function has mean = 0 and standard_dev = 1 , the value is exactly the same as the NORMSINV function.