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

* This function was added in Excel 2010 to replace the NORMINV function.
* The normal distribution is a [[continuous distribution]]
* You can use the NORM.DIST function to return the probability distribution function from a normal distribution.
* 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!