To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91651 Issue #|91651 Summary|VDB function: Calc and Excel produce different results |; both wrong Component|Spreadsheet Version|OOo 2.4.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|drking
------- Additional comments from [EMAIL PROTECTED] Mon Jul 14 20:34:57 +0000 2008 ------- This is an isolated problem - only affects the year when depreciation is capped. The function in most normal use is OK. VDB(100000;20000;10;7;8) returns 971.52 (correct) VDB(100000;20000;10;7.25;7.75) returns 3276.80 (incorrect - can't be more!) Excel97 returns 0 - that's wrong too. Should be 971.52/2 I think. I've just finished a writeup of this function that (I hope) clarifies it fairly well: http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_VDB_functio n The graphs should help illustrate the situation. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
