True/False formula help

[djs6025]

Can you help me with this formula? I need a True/False formula to check to see if any of these words "minus, plus, incomplete" are present in cell L1. It sounds like it should be easy but I'm not sure why I can't get it to work. Thanks so much for your help.

Happy New Year!

Dan

 

[Alex Blakenburg]

If you really only want True or False returned and if the word is the only thing in L1 and not part of a longer text string then

=OR(L1="minus",L1="plus",L1="inccomplete")

Please update your account profile to show what version or Excel you are using. The solution can vary based on the version.

 

[djs6025]

If you really only want True or False returned and if the word is the only thing in L1 and not part of a longer text string then

=OR(L1="minus",L1="plus",L1="inccomplete")

Please update your account profile to show what version or Excel you are using. The solution can vary based on the version.

Hi Alex,
Thanks so much for the reply. I'm using Office Professional Plus 2016. There are several words in cell L1 and I just need to know if one of those 3 words are present in that cell.

Thanks,
Dan

 

[arthurbr]

Perhaps

=IF(ISERROR(search({"minus","plus","inccomplete"},L1)),"not present","present")

( "inccomplete" with two c's?)

 

[Alex Blakenburg]

Thanks for updating your profile.
Here is one way of doing that:

=(COUNTIFS(L1,"*minus*")+COUNTIFS(L1,"*plus*")+COUNTIFS(L1,"*incomplete*"))<>0

 

[Alex Blakenburg]

( "inccomplete" with two c's?)

The 2 c's was my typo and not in the original post. Your formula spills in my MS 365, I don't have an older version of Excel to see what it does on an older version or whether it needs a CSE.

 

[djs6025]

Thanks for updating your profile.
Here is one way of doing that:

=(COUNTIFS(L1,"*minus*")+COUNTIFS(L1,"*plus*")+COUNTIFS(L1,"*incomplete*"))<>0

Thanks Alex! That worked perfectly! I appreciate the help.

Happy New Year!

Dan

 

[Alex Blakenburg]

Thanks for letting us know. Glad we could help.
Happy New Year to you too.