https://bugs.documentfoundation.org/show_bug.cgi?id=121078
Mike Kaganski <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTABUG
Status|UNCONFIRMED |RESOLVED
--- Comment #2 from Mike Kaganski <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
