2.1.1050 Part 4 Section 3.17.7.257, PROB

a.   The standard states that if the sum of the values in probability-range < 1, #NUM! is returned.

Office returns #NUM! if the sum of the values in probability-range is not equal to 1.

b.   The standard states that if any value in argument probability-range ≤ 0 or any value in probability-range > 1, #NUM! is returned.

In Office, values in argument probability-range may be ≤ 0 or > 1.

Show: