# Learn How to Use Microsoft Excel NORM.INV Function

Written by | 0 Comments | 399 Views

In this article, you will learn how to use the Microsoft Excel NORM.INV function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel NORM.INV function return value and syntax with the help of some examples.

Microsoft Excel NORM.INV Function

The main purpose of the Microsoft Excel NORM.INV function is to get the inverse of normal cumulative distribution. That implies, with the help of NORM.INV function you can able to return the inverse of the normal cumulative distribution for the given mean and standard deviation. In case the probability of an event occurring below a threshold value, the function returns the threshold value associated with the probability. So, with the help of NORM.INV function, you can able to get the inverse of normal cumulative distribution.

Return Value of NORM.INV Function

The return value will be the threshold value associated with the probability.

Syntax of NORM.INV Function

=NORM.INV(probability, mean, standard-dev)

Where the arguments:

• probability: This is the probability of the event occurring below a threshold.
• mean: This is the mean of the distribution.
• standard-dev: This is the standard deviation of the distribution.

## How to Use Microsoft Excel NORM.INV Function? So we know that, Microsoft Excel NORM.INV function you can able to get the inverse of normal cumulative distribution. That implies, with the help of NORM.INV function you can able to return the inverse of the normal cumulative distribution for the given mean and standard deviation. In case the probability of an event occurring below a threshold value, the function returns the threshold value associated with the probability. So, with the help of NORM.INV function, you can able to get the inverse of normal cumulative distribution.