Hello,
the function GAMMALN is calculated with the Lanczos algorithm. The
precision of the result depends on some coefficients. In the current
version in OOo the coefficients give only a precision of up to 10
significant digits. I looked around for some better coefficient and
found them in Apache Library, see
http://commons.apache.org/math/
and there "special functions" which gives you
http://commons.apache.org/math/userguide/special.html
Download and unpack and look into
Apache Library\
commons-math-1.2-src\src\java\org\apache\commons\math\special\Gamma.java
Are we allowed to use this values?
The result would be excellent. If you compare in a Calc cell the values
calculated with GAMMALN with the directly calculated values (which is
possible for GAMMALN(n) and GAMMALN(n+0.5) with positive integer n) you
will get TRUE.
Kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
