Comment 4 for bug 1150956
Revision history for this message
| F.H. (fheinsen) wrote Re: LibreOffice Calc's RATE function sometimes produces incorrect results!!! | #4 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
7020100
(Get the code!)
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.