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 forgot to enter the formula as an array formula, close it with Shift+Ctrl+Enter instead of just Enter.
This is not a bug. First of all, you do not describe where exactly you put the formula "In a neighboring cell". However, it's clear that you don't read the article that you cite. I suppose that you see this: If you put the formula to B1, you see 0 If you put the formula to B2, you see -56 If you put the formula to B4, you see 0 If you put the formula to B5, you see -56 And these are absolutely correct results for the formula in normal mode, because the first argument of IF is evaluated by intersection. But the article tells about *array formula*, and explicitly tells that you need to press Shift + Ctrl + Enter keys. If you do that in Calc, you will get the same expected result. See also https://help.libreoffice.org/latest/en-US/text/scalc/01/04060107.html?DbPAR=CALC