https://bugs.documentfoundation.org/show_bug.cgi?id=144274
Bug ID: 144274 Summary: Formula not working for minimum positive number... but works in Excel. Product: LibreOffice Version: unspecified Hardware: x86-64 (AMD64) OS: Linux (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: busyst...@gmail.com Description: The following formula does not work in LibreOffice but works in Excel: To find minimum positive number.... =MIN(IF(A1:A4>0,A1:A4)) Given the following numbers: -56 23 -9 8 The is a site that discribes this formula in detail: https://www.extendoffice.com/documents/excel/2974-excel-find-smallest-positive-number.html Steps to Reproduce: 1. enter the following number is cells A1 to A4 -56 23 -9 8 2. In a neighboring cell enter this formula =MIN(IF(A1:A4>0,A1:A4)) 3. If you -56 that's wrong. If you see 8 that's correct. Actual Results: -56 that's wrong. Expected Results: 8 that's correct. Reproducible: Always User Profile Reset: No Additional Info: If you -56 that's wrong. If you see 8 that's correct. -- You are receiving this mail because: You are the assignee for the bug.