https://bugs.freedesktop.org/show_bug.cgi?id=75583

          Priority: medium
            Bug ID: 75583
          Assignee: [email protected]
           Summary: UI: IRR is counted only when array is an argument
          Severity: normal
    Classification: Unclassified
                OS: Linux (All)
          Reporter: [email protected]
          Hardware: Other
        Whiteboard: BSA
            Status: UNCONFIRMED
           Version: 4.1.5.3 release
         Component: Formula Editor
           Product: LibreOffice

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

-- 
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

Reply via email to