https://bugs.documentfoundation.org/show_bug.cgi?id=144274
--- Comment #2 from Mike Kaganski <[email protected]> --- 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 -- You are receiving this mail because: You are the assignee for the bug.
