GammaDist Worksheet Function

[Bob]

I have a visual basic macro which uses Excel's Gammadist
worksheet function. I just discovered that for certain
input values gammadiat returns #num. Does anybody know
of where I can obtain visual basic code which emulates
the gammadist function?

 

[Guest]

Try http://www.cse.csiro.au/poptools/ but maybe you
entered erronous data ...

Regards,
sulprobil

 

[Tom Ogilvy]

See this thread:

http://groups.google.com/[email protected]

Particularly the Post by Ian Smith

captured below:

This is known see
http://support.microsoft.com/default.aspx?scid=kb;en-us;215214#appliesto.

The function cdf_gamma in
http://members.aol.com/iandjmsmith/Examples.xls will evaluate
gammadist accurately.

Ian Smith