Expand Minimize
This topic has not yet been rated - Rate this topic

2.1.990 Part 1 Section 18.17.7.232, NORMSINV

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.

Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.