https://issues.apache.org/ooo/show_bug.cgi?id=124964
--- Comment #4 from MaineDave <[email protected]> --- OK, let's get something clear here. As the original post said, the IRR function returns the correct result. It is the RATE function that is malfunctioning. I have re-verified this issue. When the number of payments for the RATE function (in the previously attached spreadsheet) is changed from 3 to 4 (in cell C7), the Rate of return (in cell C11) changes from 80.59% to -196.93%. I see this behavior on the system described earlier. I also see it on a Mac running 10.6.8, with OpenOffice 3.4.1, on a Toshiba laptop running Windows 7 and OpenOffice 3.3.0, and on in the cloud at www.rollapp.com/app/oocalc running OpenOffice 3.4.1. I will attached a screenshot from the rollapp.com site. -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.
