Microsoft KB Archive/215214

= XL2000: GAMMADIST Worksheet Function Returns #NUM! Error =

Article ID: 215214

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q215214



SYMPTOMS
In Microsoft Excel, when you use the GAMMADIST worksheet function in a formula, a valid formula may return the Excel error #NUM!.



CAUSE
This issue can occur if Excel cannot calculate the distribution in 100 iterations or less.

The gamma distribution worksheet function syntax is GAMMADIST(x,alpha,beta,cumulative). Excel may not be able to calculate the distribution in 100 iterations or less if all of the following conditions are true:
 * X is less than or equal to .11.
 * Alpha is less than or equal to x.
 * Beta is equal to 1.
 * Cumulative is true.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

