Microsoft KB Archive/95626

= Microsoft Knowledge Base =

Excel: CRITBINOM and NEGBINOMDIST Return #NUM! with 0 or 1
Last reviewed: September 12, 1996

Article ID: Q95626

The information in this article applies to:


 * Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0
 * Microsoft Excel for the Macintosh, versions 4.0, 5.0

SUMMARY
Pages 81 and 284 of the version 4.0 &quot;Microsoft Excel Function Reference,&quot; state that for the CRITBINOM and NEGBINOMDIST functions, if the probability_s argument is less than 0 (zero) or greater than 1, then the function will return the #NUM! error value.

This information is only partially true. The #NUM! error is also returned if the probability_s argument is equal to 0 or is equal to 1.

In addition, the #NUM! error is also returned if the alpha argument for the CRITBINOM funtion is equal to 0 or is equal to 1.

The documentation should also state the following:

For CRITBINOM ---

If probability_s is <= 0 or probability_s >= 1, CRITBINOM returns the #NUM! error value.

If alpha is <= 0 or alpha >= 1, CRITBINOM returns the #NUM! error value.

For NEGBINOMDIST --

If probability_s is <= 0 or probability_s >= 1, NEGBINOMDIST returns the #NUM! error value.