[Libreoffice-bugs] [Bug 118878] weird behaviour in formulas

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #8 from Xavier Van Wijmeersch <xv3247 at gmail.com> ---
Elmar

I changed your formula to
=IF(NOT(X3>0);"??";IF(X3<14;"1C";IF(X3<18;"2T";IF(X3<26;"4A";IF(X3<65;"5M";IF(X3>64;"6S";"??"))))))
first: in the last IF i changed "64" to 64
second: three IF's did have the wrong row number; X4 and it needed to be X3
I used the second attachment

Version: 6.2.0.0.alpha0+
Build ID: 83d8331581ab43cf35325ca674cf62d4ba5dc5ad
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group threaded

-- 
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/20180802/6e728c8a/attachment-0001.html>