Created attachment 98202 [details] the file with error expression Simple Expression: =IF(TRIM(E1)="10006- 38138021/0100";D1;0) should give the value from column E2, but gives zero. Operating System: Windows (other) Version: 4.2.3.3 release
Hello Roman, Instead of: =IF(TRIM(E1)="10006- 38138021/0100";D1;0) type: =IF(TRIM(E1)="10006- 38138021/0100";D1;0) Have a nice day, Jacques
Function TRIM removes excess spaces from a text string, also between words. https://help.libreoffice.org/Calc/Text_Functions/cs#TRIM Change expression as Jacques wrote. I mark this as RESOLVED NOTABUG, feel free to reopen if I'm wrong.