if(countif help

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

=IF(COUNTIF(B24,"*A*","*B*","*D*","*F*"}),"Y","N")

this command puts a Y if it finds ALL A B D F in a cell.

How do I get it to put a Y if it finds ANY or ALL of A B D
F not only ALL.

=IF(COUNTIF(B24,"*A*" or"*B*" or "*D*" or "*F*"}),"Y","N")?

thanks
Greg
 
=IF(OR(COUNTIF(B24,{"*A*","*B*","*D*","*F*"})),"Y","N")

note that the countif formula is not case sensitive
 
Back
Top