NORM.S.INV function

NORM.S.INV(probability) NORM.S.INV(probability)

probability — Number or { Number }

A probability associated with the distribution.

Returns — Number or { Number }

The inverse of the cumulative NORM.S.DIST function.

Returns the inverse of the cumulative NORM.S.DIST function.

Example

NORM.S.INV(0.7)NORM.S.INV(0,7)

Returns roughly 0.5.