https://issues.apache.org/ooo/show_bug.cgi?id=124964
Regina Henschel <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |CONFIRMED CC| |[email protected] Ever confirmed|0 |1 --- Comment #7 from Regina Henschel <[email protected]> --- The call =RATE(Nper;Payment;Pv,Fv;PayType;Guess)) results a solution "Rate" of the equation 0=Fv + Pv*(1+Rate)^Nper + Payment*(1+Rate*PayType)*((1+Rate)^Nper-1)/Rate. This equation has in many cases not a single solution but more than one solution. For most values of Nper, there exist no closed solution, but a solution has to be found by iteration. Use the value "Guess" to make the algorithm converge to the expected range. When you omit this parameter, the default value of 10% is used, which is far away form the range expected in your example. We already discussed the problem in bug 15090 and on the mailing list at that time. The then decision was to keep the negative value. Gnumeric produces a value in the expected range, Excel produces an error. Can you provide a formula for a guess, which would work in all cases, where the algorithm converges to such negative value using the default guess? I set it to "Confirmed", because the behavior is indeed as described. Possible resolution can be "Wontfix" or a change to an enhancement request. -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.
