Nov 02 2021 03:12 AM
Hello Everyone,
I need help to prepare a formula where if any task is assigned to Sam or Max, then the Column 'C' should return value as 'Okay' if Sam or Max are not assigned to the respective task then it should return as 'Not Okay',
Can you please guide me, how to do it?
It should be come like this with the help of formula :
Please help..??
I am using Microsoft Office 2019 Home and Student version
Here is a attached file
Nov 02 2021 03:34 AM
SolutionIn C2:
=IF(OR(ISNUMBER(SEARCH({"sam","max"},B2))),"Okay","Not Okay")
If the formula doesn't work as intended, confirm it with Ctrl+Shift+Enter.
Fill down.
Nov 02 2021 04:01 AM
Nov 02 2021 03:34 AM
SolutionIn C2:
=IF(OR(ISNUMBER(SEARCH({"sam","max"},B2))),"Okay","Not Okay")
If the formula doesn't work as intended, confirm it with Ctrl+Shift+Enter.
Fill down.