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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 5, 2017 at 10:56 AM
Related:
- Excel if statement with multiple text values in a column
- Fenix internet on bank statement - Guide
- Excel if statement increment by 1 - Guide
- How many if statements can you nest - Guide
- Excel date format dd.mm.yyyy - Guide
- Screenshot in excel - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 5, 2017 at 10:56 AM
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.
Try to use:
=IF(ISNUMBER(SEARCH("computer",CQ2)),1,0)
Please tell us if it worked as you desire.