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

m.a.riosv <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]
                   |                            |rg

--- Comment #2 from m.a.riosv <[email protected]> ---
Function AND() does not work in that way, the formula should be:

IF(AND(A=5,B=6),27,29)

you also can get it without AND, using product '*' instead 'and' and '+'
instead 'or', because the result of a comparison it's '1' true or '0' false,
IF((A=5)*(B=6),27,29)

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to