True/False formula help

djs6025

New Member
Joined
Feb 6, 2012
Messages
40
Office Version
  1. 2016
Platform
  1. Windows
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
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
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
Excel Formula:
=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.
 
Upvote 0
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
Excel Formula:
=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
 
Upvote 0
Perhaps
Excel Formula:
=IF(ISERROR(search({"minus","plus","inccomplete"},L1)),"not present","present")

( "inccomplete" with two c's?)
 
Upvote 0
Thanks for updating your profile.
Here is one way of doing that:
Excel Formula:
=(COUNTIFS(L1,"*minus*")+COUNTIFS(L1,"*plus*")+COUNTIFS(L1,"*incomplete*"))<>0
 
Upvote 0
Solution
( "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.
 
Upvote 0
Thanks for updating your profile.
Here is one way of doing that:
Excel Formula:
=(COUNTIFS(L1,"*minus*")+COUNTIFS(L1,"*plus*")+COUNTIFS(L1,"*incomplete*"))<>0
Thanks Alex! That worked perfectly! I appreciate the help.

Happy New Year!

Dan
 
Upvote 0

Forum statistics

Threads
1,224,835
Messages
6,181,245
Members
453,026
Latest member
cknader

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top