https://issues.apache.org/ooo/show_bug.cgi?id=124964
Issue ID: 124964
Issue Type: DEFECT
Summary: RATE function blows up
Product: Calc
Version: 4.1.0
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: major
Priority: P3
Component: ui
Assignee: issues@openoffice.apache.org
Reporter: da...@ezzio.us
Created attachment 83454
--> https://issues.apache.org/ooo/attachment.cgi?id=83454&action=edit
Shows RATE function blowing up
The attached spreadsheet compares the value calculated with the RATE function
with the value calculated with the IRR value. These values are validated
against the value calculated by the HP 10B II financial calculator.
Essentially, RATE and IRR give the same value when the number of payments is 3.
They give wildly different values when the number of payments is 4. The
values calculated by IRR always agree with the HP calculator.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
