To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91870 Issue #|91870 Summary|PMT function with extremely small rates -> #VALUE! Component|Spreadsheet Version|OOo 2.4.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P4 Subcomponent|programming Assigned to|spreadsheet Reported by|drking
------- Additional comments from [EMAIL PROTECTED] Sun Jul 20 17:15:22 +0000 2008 ------- The formula for PMT (payment at end) is [p(1+r)^n - f]r / ((1+r)^n-1) where n = number of periods p = principal (the capital sum borrowed) f = the final balance owing after n periods r = interest rate (fixed rate) per period derived here: http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Derivation_ of_Financial_Formulas#PMT With extremely small values for r we get too close to divide by 0 Example: =PMT(1E-016;10;1000;0;0) gives #VALUE! Note that =PMT(4.567E-015;10;1000;0;0) is OK - larger, but with more displayed digits - so we have not run out of precision with the rate. Excel has the same problem, giving #DIV/0!. The solution may be to trap low values and apply another algorithm, also provided on the linked page. rate=0 is trapped anyway. This error will not arise in real life, so this should be low priority and I've marked it enhancement rather than defect. It is bad to have a function that can be beaten though, and there should be a record of the fact. --------------------------------------------------------------------- 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]
