2.1.1003 Part 1 Section 18.17.7.232, NORMSINV

  • Article

a.   The standard states that the function uses an iterative search technique.

Office does not require an iterative search technique to be used.

b.   The standard states that the function returns the inverse of the standard normal distribution.

In Office, the function returns the inverse of the standard normal cumulative distribution.

c.   The standard states that if probability < 0 or if probability > 1, #NUM! is returned.

Office returns #NUM! if probability ≤ 0 or if probability ≥ 1.