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

--- Comment #8 from Xavier Van Wijmeersch <[email protected]> ---
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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to