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,00000000000000E+000 but it is shown as
10,00000000000000E+000.
It is really a display problem and not a problem of my function, because
the result of the formula =BETADIST(B$3;$B$1;$A8)+1 is correctly shown
as 2,00000000000000E+000.
To see the problem, you need my interpr3.cxx and the interpr6.cxx from
cws DEV300/odff04. You cannot use the normal version, because there the
function is not accurate enough to get that problem.
I have simulate the algorithm with MuPad, a high precision CAS. There I
get the value 0.9999999999999993332933300668465 (first digits) for my
result. But I don't know which value OOo has internally.
Does anyone know the reason or like to have a look at it or show me a
way to get the root of the problem?
Kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]