https://bugs.documentfoundation.org/show_bug.cgi?id=126016
Jacques Guilleron <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTABUG
Status|UNCONFIRMED |RESOLVED
--- Comment #3 from Jacques Guilleron <[email protected]> ---
Hi jhon, Julien,
"Y", "O" are the "AND" and "OR" functions.
This is not obvious at first glance to read that, ahd this cannot be
translated. That's why you have to write your report in English.
So, you have written: =SI(Y(A1>0,B2>0),(10*20),"") in English
=IF(AND(A1>0,B2>0),(10*20),"")
To work, you have to change all the "," by ";"
=SI(Y(A1>0B2>0),(10*20),"") in Eglish
=IF(AND(A1>0;B1>0);(10*20);"")
See the small attachment.
Jacques
--
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
