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]
