Christopher -- sure. I just tried this on Google Drive's Spreadsheet and on Microsoft Excel:
=RATE(50,35,-250,0) The result in both cases is approximately 0.1398. When I try the same formula in LibreOffice, I get a nonsensical answer. (I sure hope no one out there is using this function to calculate important financial figures!) I'm using LibreOffice 3.5.7.2 Build ID: 350m1(Build:2) on Ubuntu 12.04 64-bit. Hope this is helpful. -- 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
