Dana DeLouis wrote...
This is one way to get Gamma(A1):

=EXP(GAMMALN(A1))

It's been noted before that it's only good to about 9 or 10 digits
of
accuracy.

GAMMALN's poorer around 1 and 2, where it evaluates negative.

FWIW, the lngamma udf in the .xls file in following linked .zip file
does a reasonable job, accurate to 14+ decimal digits.

ftp://members.aol.com/hrlngrv/gammaln8.zip

Perhaps in a few more versions Microsoft might actually use the
publicly available (and not even GPLed) netlib code in all the
'engineering' and stats functions in Excel.
---------
www.coffeecozy.com

Use your Bodum and give up cold coffee for good!