crayroge
New Member
- Joined
- Mar 17, 2020
- Messages
- 9
- Office Version
- 2016
- 2010
- Platform
- Windows
- Mobile
- Web
Hello,
I am trying to use this function below to give text names if these sentences contain certain values like class name update, term benefits, OR dates. I want the function to give these values instead of 'TRUE' or 'FALSE'. I can't for some reason see what I am doing wrong.....
=IF(ISNUMBER(SEARCH("Class Name",A3)),"Class Change")=IF(ISNUMBER(SEARCH("OR dates",A3)),"Override")=IF(ISNUMBER(SEARCH("Term all Benefits",A3)),"Benefit Term", "NA")
I am trying to use this function below to give text names if these sentences contain certain values like class name update, term benefits, OR dates. I want the function to give these values instead of 'TRUE' or 'FALSE'. I can't for some reason see what I am doing wrong.....
=IF(ISNUMBER(SEARCH("Class Name",A3)),"Class Change")=IF(ISNUMBER(SEARCH("OR dates",A3)),"Override")=IF(ISNUMBER(SEARCH("Term all Benefits",A3)),"Benefit Term", "NA")