Bug 100990 - bad example of RATE function
Summary: bad example of RATE function
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: target:5.3.0
Keywords:
Depends on:
Blocks:
 
Reported: 2016-07-18 16:23 UTC by raal
Modified: 2016-09-22 17:03 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description raal 2016-07-18 16:23:39 UTC 
help http://vm173.documentfoundation.org/text/scalc/01/04060118.xhp#bm_id3154267

Example
What is the constant interest rate for a payment period of 3 periods if 10 currency units are paid regularly and the present cash value is 900 currency units.
=RATE(3;10;900) = -121% The interest rate is therefore 121%.


Formula =RATE(3;10;900) throws error in Calc.
Comment 1 Aron Budea 2016-07-18 23:23:44 UTC 
I can't say I understand the example, but it gives Err:523 for me, too.
Comment 2 Winfried Donkers 2016-07-28 06:58:57 UTC 
I confirm that the documentation is at fault.

=RATE(3;10;900) uses the default value of 0 for argument FutureValue.
With Payment (10) and PresentValue (900) being of the same sign, the FutureValue of 0 cannot be reached.
The error returned by Calc is correct.
Comment 3 Stanislav Horacek 2016-09-08 11:41:06 UTC 
Patch submitted to Gerrit:
https://gerrit.libreoffice.org/#/c/28745/
Comment 4 Commit Notification 2016-09-09 08:14:55 UTC 
Stanislav Horacek committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/help/commit/?id=ea2be76c292e9b2ad455bc47540d8e03626b7ee7

tdf#100990 correct example for RATE function