https://bugs.freedesktop.org/show_bug.cgi?id=48073
Bug #: 48073
Summary: Error 523 on TIR function
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.1 Release
Platform: Other
OS/Version: Linux (All)
Status: UNCONFIRMED
Severity: critical
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
I found a bug of TIR function on Calc
I have this cashflow
($54.970,00)
$602,00
$657,00
$657,00
$657,00
$657,00
$657,00
$657,00
$657,00
$776,00
$776,00
$776,00
$716,00
$716,00
$716,00
$716,00
$716,00
$816,00
$816,00
$816,00
$816,00
$816,00
$816,00
$816,00
$816,00
$973,00
$973,00
$973,00
$973,00
$973,00
$973,00
$973,00
$973,00
$973,00
$973,00
$973,00
$973,00
$973,00
$973,00
$973,00
$973,00
$803,00
$4.803,00
$803,00
$803,00
$803,00
$803,00
$803,00
$803,00
$803,00
$803,00
$803,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
when I calculate TIR =tir(values,..) the results its an error 523
The correct results should be TIR=0.631367307%
an observation, if I use values <(29000) on the first value of the cash flow,
the function work OK
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
