# NORM.INV

NORM.INV(probability, mean, standard_dev)

Returns the inverse of the probability distribution function for a normal distribution.

 probability The probability associated with the distribution. mean The arithmetic mean of the distribution. standard_dev The standard deviation of the distribution.

 REMARKS
 * The normal distribution is a [[continuous distribution]]* You can use the NORM.DIST function to return the probability distribution function for a normal distribution.* You can use the NORM.S.DIST function to return the probability distribution function for a standard normal distribution.* You can use the NORM.S.INV function to return the inverse of the probability distribution function for a standard normal distribution.* This function was added in Excel 2010 to replace the NORMINV function.* For the Microsoft documentation refer to support.microsoft.com

 A 1 =NORM.INV(0.908789, 40, 1.5) = 42 2 =NORM.INV(0.87, 0, 1) = 1.126 3 =NORM.INV(NORM.DIST(0.87, 0, 1, TRUE), 0, 1) = 0.87 4 =NORM.INV(1, 0, 1) = #NUM! 5 =NORM.INV(-1, 40, 1.5) = #NUM! 6 =NORM.INV(2, 40, 1.5) = #NUM! 7 =NORM.INV(0.908789, "some text", 1.5) = #VALUE!