[Libreoffice-bugs] [Bug 126016] falla en la ayuda de la estructura función "SI" al usar paréntesis en la zona de valor si verdadero

[bugzilla-daemon at bugs.documentfoundation.org]

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

Jacques Guilleron <jalojo at laposte.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #3 from Jacques Guilleron <jalojo at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190621/5f7dca2a/attachment.html>