Forum Discussion
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 ...
To replace FALSE on empty string
=IF( COUNTIF(F2,"*"&"Staff - Former"&"*" ), "", IF( COUNTIF(F2,"*"&"Friend of Staff"&"*"), "", IF( COUNTIF(F2,"*"&"Staff"&"*"),"Staff", "" )))
Didn't check the logic behind, but this formula
=IF( COUNTIF(F2,"*"&"Staff - Former"&"*" ), "",
IF( COUNTIF(F2,"*"&"Friend of Staff"&"*"), "",
IF( COUNTIF(F2,"*"&"Staff"&"*"),"Staff" )))have no errors.
I copied your formula and excel let me tab out of it, so we are so much closer. But I'm getting "false" instead of an empty cell. How do I fix that?
=IF( COUNTIF(F2,"*"&"Staff - Former"&"*" ), "", IF( COUNTIF(F2,"*"&"Friend of Staff"&"*"), "", IF( COUNTIF(F2,"*"&"Staff"&"*"),"Staff" )))
Thank you!!