Formulas > =NORMINV()

How To Use NORMINV() Function in Google Sheets


Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation.

Common questions about the NORMINV formula include:
What is the NORMINV formula?
What does NORMINV stand for?
What type of argument does the formula accept?

The NORMINV formula can be used to find a value from a normalized distribution with given mean and standard deviation. Specifically, it can be used for situations where you are trying to estimate a probability from observed data.

The NORMINV formula can be commonly mistyped as NORMVINV, NORMVNI, or NOMRINV.

Some common ways the NORMINV formula is used inappropriately include using the wrong function for the situation, entering the wrong arguments into the formula, or entering a non-numeric data type into the formula.

Common pitfalls when using the NORMINV formula include not understanding the arguments required, incorrect calculations when using the wrong arguments, and/or not double-checking the correctness of the formula.

Common mistakes when using the NORMINV Formula include entering the wrong arguments or using the argument order incorrectly.

Common misconceptions people might have with the NORMINV Formula may include using the wrong statistical method or thinking the NORMINV formula is the same as other related formulas such as NORM.DIST.

How To Actually Use NORMINV() in Sheets

NORMINV(x, mean, standard_deviation)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the NORMINV() formula:

Google Sheets GAUSS NORMDIST NORMINV NORMSINV in Cumulative Normal Distribution using ARRAYFORMULA

This video shows the use of ARRAYFORMULA in generating data sets for Google Sheets GAUSS NORMDIST NORMINV NORMSINV in Cumulative Normal Distribution,

Generate a NORMINV() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.