FALSE statement

toony

New member
Joined
Mar 6, 2014
Messages
49
Reaction score
0
Points
0
Location
UK
Excel Version(s)
Excel 2016
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
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
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",""))))
 
Top