Formulas > =NORM.INV()
How to Use NORM.INV() in Google Sheets
Description
How To Actually Use NORM.INV() in Sheets
NORM.INV(x, mean, standard_deviation)
Try NORM.INV yourself
In cells A1:A10, enter probabilities (between 0 and 1). In cell B1, use the NORM.INV formula to calculate the corresponding values for a mean of 100 and a standard deviation of 15.
Hints (2)
-
Remember that NORM.INV requires three arguments.
-
Make sure the probabilities in A1:A10 are valid for the formula.
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 BetterSheets.co/formulas
Learn more about the NORM.INV() formula:
Generate a NORM.INV() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses NORM.INV(). 2 free AI generations, no signup. Members get unlimited use.
Generate a NORM.INV() formula