Eike Rathke wrote:
On Wednesday, 2008-06-25 23:42:16 +0200, Regina Henschel wrote:
I'm working on BETADIST. For certain inputs my version of that function
returns a value, which is near to 1. The formula in the cell is
=BETADIST(B$3;$B$1;$A8) with B3=0,999 and B1=1e-9 and A8=1,5. The result
should be shown as 1,00000000000000E+000 but it is shown as
10,00000000000000E+000.
I couldn't reproduce that, using a number format code
0.00000000000000E+000
Did you do something different?
I don't see it with BETADIST either, but with "=1-7E-16" and that format
code, on Windows and Solaris/Sparc, but not Linux.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
