https://bugs.documentfoundation.org/show_bug.cgi?id=165988
raal <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #1 from raal <[email protected]> --- =IF(MIDB(A9;5;1)="3";LEFT(A9;1);0) Left returns text. Try =VALUE(IF(MIDB(A9;5;1)="3";LEFT(A9;1);0)) or =IF(MIDB(A9;5;1)="3";VALUE(LEFT(A9;1));0) -- You are receiving this mail because: You are the assignee for the bug.
