I really don't know what else to tell you...
Did you try them in Google Spreadsheets?
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1150956
Title:
LibreOffice Calc's RATE function sometimes
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
PS. It would be a LOT better if LibreOffice returned a #NUM! error
instead of an incorrect number.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1150956
Title:
LibreOffice Calc's RATE function
F.H., regarding the following in Microsoft Office Professional Plus 2010 Word
Version 14.0.6023.1000 (32-bit) :
=RATE(50,35,-250,0)
=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)
all of these produce errors. Excel Options - Formulas - checked
F.H., regarding your comments
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1150956/comments/4 :
...and on Microsoft Excel:
What specific version of Excel?
=RATE(50,35,-250,0)
Unfortunately, this was not a different, exact command as previously
requested in
F.H. thank you for reporting this and helping make Ubuntu better. As per Excel
Microsoft Office Professional Plus 2010 Excel Version 14.0.6023.1000 (32-bit),
the result of:
=RATE(B5,B4,B3,0)
is:
#NUM!
Could you please provide a different, exact command that demonstrates
this problem?
**
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
