Re: [sc-dev] wrong display for special function result near 1

2008-06-26 Thread Eike Rathke
Hi Regina, 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

Re: [sc-dev] wrong display for special function result near 1

2008-06-26 Thread Niklas Nebel
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

Re: [sc-dev] wrong display for special function result near 1

2008-06-26 Thread Eike Rathke
Hi Niklas, On Thursday, 2008-06-26 14:30:11 +0200, Niklas Nebel wrote: 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

[sc-dev] wrong display for special function result near 1

2008-06-25 Thread Regina Henschel
Hello all, 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,00E+000 but it is shown as