Report

Excel if statement with multiple text values in a column

Ask a question hnew16 - Last answered on Aug 5, 2017 at 10:56 AM by Mazzaropi
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?



Helpful
+0
plus moins
hnew16, Good morning.

Try to use:

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

Please tell us if it worked as you desire.
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!