[Libreoffice-bugs] [Bug 121575] Logical function IFS

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #7 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Mario Cataldi from comment #6)

The syntax for Calc operators is described in help:
https://help.libreoffice.org/latest/en-US/text/scalc/01/04060199.html. You may
see that there's no ternary A<B<C operators exist, so you have to use
equivalents using AND() and such spreadsheet functions. There is no 1:1
correspondence between standard math notation and Calc syntax.

So yes, "1<Value<1.5" returns something other than you would expect - see
Eike's answer.

-- 
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/20181121/4ffd5faa/attachment.html>