<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_CLOSED bz_closed" title="CLOSED INVALID - Formula not working for minimum positive number... but works in Excel." href="https://bugs.documentfoundation.org/show_bug.cgi?id=144274#c2">Comment # 2</a> on <a class="bz_bug_link bz_status_CLOSED bz_closed" title="CLOSED INVALID - Formula not working for minimum positive number... but works in Excel." href="https://bugs.documentfoundation.org/show_bug.cgi?id=144274">bug 144274</a> from <a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> Mike Kaganski</a> <pre>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 <a href="https://help.libreoffice.org/latest/en-US/text/scalc/01/04060107.html?DbPAR=CALC">https://help.libreoffice.org/latest/en-US/text/scalc/01/04060107.html?DbPAR=CALC</a></pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>