WorksheetFunction.Norm_S_Inv (Excel)

Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of 0 (zero) and a standard deviation of one.

If probability is non-numeric, Norm_S_Inv returns the #VALUE! error value. If probability < 0 or if probability > 1, Norm_S_Inv returns the #NUM! error value. Given a value for probability, Norm_S_Inv seeks that value z such that NORM_S_DIST(z) = probability. Thus, precision of Norm_S_Inv depends on precision of Norm_S_Dist. Norm_S_Inv uses an iterative search technique. If the search has not converged after 100 iterations, the function returns the #N/A error value.

Norm_S_Inv (Arg1)

Arg1: Probability - A probability corresponding to the normal distribution.

Dim dblArg1 As Double: dblArg1 = 
Dim dblNorm_S_Inv As Double
dblNorm_S_Inv = WorksheetFunction.Norm_S_Inv(Arg1:=dblArg1)