[Libreoffice-bugs] [Bug 121078] Calc IF function executes false condition even though true should have been

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121078

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #4 from Mike Kaganski <mikekaganski at hotmail.com> ---
1. The original description was wrong when described the column C: it should
say that a formula like "=IF(A1="";"";SUM(A1;B1))" is used there.
2. There is no bug in Calc; rather, there's an error in the formula in D, where
the result of "IF(C1="","",SUM(C2-C1)/C1)" is unconditionally multiplied by
100. In case of cells with empty neighbors, this results in ""*100, which is
naturally wrong, which is reported as #VALUE!.

The proper formula is "=IF(C2="";"";SUM(C2-C1)/C1*100)"

Closing NOTABUG.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181031/62c7657c/attachment-0001.html>