https://bugs.documentfoundation.org/show_bug.cgi?id=145070
--- Comment #3 from Eike Rathke <[email protected]> --- Oh, and for your varying test case (confusingly only in the repro steps) it is =LEFT(A1;4) => 10.5 (string) =LEFT(A2;3) => 9.7 (string) =LEFT(A1;4)>LEFT(A2;3) => FALSE =IF(LEFT(A1;4)>LEFT(A2;3)) => FALSE =IF(LEFT(A1;4)>LEFT(A2;3))=FALSE => TRUE Because operator '>' there does a string comparison where 9>1, not numeric. So, also correct and also not what you claim it was. If you want numeric comparison, use =NUMBERVALUE(LEFT(A1;4);".")>NUMBERVALUE(LEFT(A2;3);".") -- You are receiving this mail because: You are the assignee for the bug.
