[Libreoffice-bugs] [Bug 108811] SOMME.SI / SUMIF equality tests returns wrong values - is not the same than IF equality test - in some cases

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #1 from david.lacorre at gmail.com ---
Forgot to change the formulas in the exemple given after copy and paste.

Should have been 

D3 = "=SUMIF($A$2:$A$4;C2;$B$2:$B$4)"
D4 = "=SUMIF($A$2:$A$4;C3;$B$2:$B$4)"
D5 = "=SUMIF($A$2:$A$4;C4;$B$2:$B$4)"

E2 = "=SI(C2=A2;1;0)"
E3 = "=SI(C3=A3;1;0)"
E4 = "=SI(C4=A4;1;0)"

-- 
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/20170627/1f354970/attachment.html>