https://bugs.freedesktop.org/show_bug.cgi?id=40460
ign_christian <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |WORKSFORME --- Comment #3 from ign_christian <[email protected]> --- I did some tests, found that we must enter "Guess" value to show the result. > Internal Return Rate (IRR) function is widely used in financial tasks. In > the attached spreadsheet example, LibreOffice gives "Err:523" at cell G11. > However, the value 0.3775... is a solution. This solution is found by > Gnumeric on the same spreadsheet file. By the way, MS Excel fails as > LibreOffice does. I guessed what you meant is cell G10 (not G11) = IRR(G11:G251;0), then correct result will be shown. Tested on LO 4.0.4.2 (Win7 32bit) Please REOPENED this bug if you can't reproduce this on latest stable release (3.6.6 or 4.0.4) -- 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
