Previous Topic Next Topic

Excel if statement with multiple text values in a column

Closed
hnew16 - Aug 5, 2017 at 09:30 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 5, 2017 at 10:56 AM
Hello,

I am using excel 2017.

I am trying to use this if statement to give me a value of 1 or 0.

=IF((CQ2="Computer");1;0)

The problem is that in CQ2, I sometimes have a list of text values, such as "Television;Computer;Phone" or "Computer;Phone" or "Newspaper;Television;Computer;Phone".

This was exported from Google drive survey.

How can I make it so it inputs a value of 1 if the word Computer is present and if not a 0?



Related:

1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Aug 5, 2017 at 10:56 AM
hnew16, Good morning.

Try to use:

=IF(ISNUMBER(SEARCH("computer",CQ2)),1,0)

Please tell us if it worked as you desire.
0

Similar discussions

Excel - IF function with multiple words
Nick -
user -

14 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
using multiple if functions with data validation
chriswiec -
Zohaib R -

5 responses