NORMSINV

Definition: NORMSINV is a function that returns the inverse of the standard normal cumulative distribution for a specified probability.

Syntax: =NORMSINV(probability)

Situation: This formula is appropriate when you need to calculate the inverse of the standard normal cumulative distribution for a specified probability.

Example: If you want to find the value that corresponds to a standard normal cumulative probability of 0.3, the formula =NORMSINV(0.3) can be used, which returns -0.5244.