Forum Discussion

askjacq's avatar
askjacq
Copper Contributor
Oct 05, 2021
Solved

if countif help

Here's my need. Is it possible?   I have a column F with group identifiers. I want the formula to say "Staff" if the cell in column F says staff. It is doing that perfectly! But wait!! I also have ...
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Oct 05, 2021

    askjacq 

    To replace FALSE on empty string

    =IF( COUNTIF(F2,"*"&"Staff - Former"&"*" ), "",
 IF( COUNTIF(F2,"*"&"Friend of Staff"&"*"), "",
 IF( COUNTIF(F2,"*"&"Staff"&"*"),"Staff",
     ""   )))

     

HansVogelaar's avatar
HansVogelaar
MVP
Oct 05, 2021

askjacq 

Why do you use COUNTIF here? You can simply use

 

=IF(F2="Staff","Staff","")

 

or if you want to return "Staff" for "Event Sponsor;Staff" too:

 

=IF(ISNUMBER(FIND(";Staff;",";"&F2&";")),"Staff","")

Resources