https://issues.apache.org/ooo/show_bug.cgi?id=124964
--- Comment #9 from MaineDave <[email protected]> --- (In reply to MaineDave from comment #8) > RATE(4;500;-600;500;0.8) = -1.940231 > > So, I don't see how providing a guess in the neighborhood helps. My mistake there. RATE(4;500;-600;500;0;0.8) = 0.819622 So, a guess in the neighborhood does make the difference. Obviously, the HP calculator has figured out how to come up with the right answer. So there is an algorithm that works in silicon. Also, the IRR function has figured it out as well. If "won't fix" were the resolution, you would be choosing to leave it broken. Getting the wrong answer in a financial calculation can be very significant. It tends to render everything about OO Calc suspect, an aspersion that IMO would be a tragedy. -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.
