FALSE statement

This gives me a FALSE statement. I took off the second “” at the end but makes no difference:


=IF(OR(AQ2246=0,AY2246=0),"",IF(COUNTIF(AJ$2:AJ2246,AJ2246)=1,IF(ISNUMBER(SEARCH("(dr)",E2246)),"DR",IF(ISNUMBER(SEARCH("(ba)",E2246)),"BA",""))))

Thank you all

Try

=IF(OR(AQ2246=0,AY2246=0),"",IF(NOT(COUNTIF(AJ$2:AJ2246,AJ2246)),"",IF(ISNUMBER(SEARCH("(dr)",E2246)),"DR",IF(ISNUMBER(SEARCH("(ba)",E2246)),"BA",""))))