[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 #2 from Mike Kaganski <mikekaganski at hotmail.com> ---
C5 and C6 aren't blank and don't contain empty strings, which would qualify
them to fulfill `C5=""` condition. They contain a number (zero) as the result
of the formula adding two empty cells, and if you need to account for that
specific condition in your formula, then do that explicitly. E.g.,
=IF(OR(C1="";C1=0);"";SUM(C2-C1)/C1)*100

Closing NOTABUG. Please reopen if you think it's closed by mistake; please
explain why you do so.

-- 
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/b5e59c5b/attachment.html>