2.1.1023 Part 1 Section 18.17.7.260, PROB

  • Article

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.