https://bugs.documentfoundation.org/show_bug.cgi?id=149624
Eike Rathke <er...@redhat.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |NOTABUG --- Comment #6 from Eike Rathke <er...@redhat.com> --- That is exactly what that commit was about to fix bug 146377. Error values in the IF() condition are to be propagated and not ignored taking the ELSE path. In the past the expression worked by chance, but is not correct. See also https://wiki.documentfoundation.org/ReleaseNotes/7.3#Changed_spreadsheet_functions This should work: =IFERROR(IF(SEARCH($D$1;$B4);"x");"") In the success case SEARCH() returns a value >=1 so the condition would be TRUE (for any value <>0) and the THEN path of "x" would be executed. Otherwise if SEARCH() returns an error value propagated by IF() the IFERROR() catches that and returns "". -- You are receiving this mail because: You are the assignee for the bug.