Christopher: > What specific version of Excel?
Excel 2003 on a Windows XP VM under VirtualBox. To get the answer, you must enable iterative calculations, increase the number of iterations, and lower the maximum change per iteration. Otherwise you will get the #NUM! error. > Unfortunately, this was not a different, exact command Try these, then: =RATE(50,36,-250,0) =RATE(50,37,-250,0) =RATE(50,38,-250,0) =RATE(50,39,-250,0) =RATE(50,40,-250,0) These RATE functions are supposed to return the internal rate of return of investing -250 in exchange for receiving a recurring payiment of respectively 36, 37, 38, 39, and 40 per period for a total of 50 periods, with no payment at the end. LibreOffice returns a nonsensical answer in ALL of these cases!!! -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1150956 Title: LibreOffice Calc's RATE function sometimes produces incorrect results!!! Status in “libreoffice” package in Ubuntu: Incomplete Bug description: STEPS TO REPRODUCE: Type "=RATE(50,35,-250,0)" on any cell, and press Enter. The result should be 0.1398, but LibreOffice shows -1.9474! ADDITIONAL INFORMATION: I'm using LibreOffice 3.5.7.2, Build ID: 350m1(Build:2), on Ubuntu 12.04, 64-bit version, with up-to-date packages. To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1150956/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
