Hi,
I am confused:
If I evaluate =vdb(20000,500,5,1.75,3.5,2,false()) in current
Gnumeric, I get 5035. Regina's email below seems to say that
Gnumeric yields 4873.33. That does not seem to be the case.
Andreas
On 18-10-25 03:24 PM, Regina Henschel
wrote:
Hi
members,
I have looked at issue 3920 for fractional startPeriod and
endPeriod. I get the problem, that Gnumeric, Excel and
GoogleDocs[1] calculate different from LibreOffice for the case of
fractional and switch at same time. So we need to define first the
algorithm before we can improve the wording.
Andreas, Alfred: Can you please explain, how the result on the
sheet "with_switch" is calculated?
Written without references it is about the formula
=VDB(20000;500;5;1.75;3.5;2;FALSE()).
LibreOffice calculates result 5035, which is identic to my
manually calculation on the same sheet. Others calculate result
4873.33
The results for fractional without switch (last parameter TRUE())
and for integer with switch are identical in all tested
applications.
[1]
https://docs.google.com/spreadsheets/d/1jNbUijAZbPyFbPOEKtNffQAJ5M8hkyrdqRPbU8mslUY/edit?usp=sharing
Kind regards
Regina
---------------------------------------------------------------------
To unsubscribe from this mail list, you must leave the OASIS TC that
generates this mail. Follow this link to all your TCs in OASIS at:
https://www.oasis-open.org/apps/org/workgroup/portal/my_workgroups.php
|