| Summary: | UI: IRR is counted only when array is an argument | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | yajupadu <yajupadu> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | jmadero.dev, serval2412 |
| Priority: | medium | ||
| Version: | 4.1.5.3 release | ||
| Hardware: | Other | ||
| OS: | Linux (All) | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
Wrong component -> Spreadsheet yajupadu: I don't understand why it's a bug since the description indicates: "An array or reference to cells whose contents correspond to the payments" So with an array, it's ok. If I name the range of cells and use this name, it's ok. Yes this is not a bug - the description of the component is pretty clear on this one. Closing as NOTABUG. |
Problem description: when trying to count IRR in this way =IRR(-10000,300,500,1200,2000,2000,5000,5000) getting error c IRR is only counted when array is given as an argument =IRR(A4:H4) - works = 9.12% Steps to reproduce: =IRR(-10000,300,500,1200,2000,2000,5000,5000) Current behavior: Err:504 Expected behavior: 9.12% Operating System: Fedora Version: 4.1.5.3 release