https://bugs.documentfoundation.org/show_bug.cgi?id=126016
Jacques Guilleron <jal...@laposte.net> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTABUG
Status|UNCONFIRMED |RESOLVED
--- Comment #3 from Jacques Guilleron <jal...@laposte.net> ---
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
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs