Forum Discussion
Solved
If formula for contains specific text
Hello all!
Please can you advise how to construct the formula in COLUMN F attached to show:
IF Program: Account Name Contains "Executive" then "Exec", ELSEIF Degree Level = Undergraduate then "UG" ELSEIF Degree Level = Postgraduate then "PG"
Thanks in advance for your help!
Jenny
=IF(ISNUMBER(SEARCH("executive",E2)),"exec",IF(D2="Undergraduate","UG",IF(D2="Postgraduate","PG","")))Does this formula return the intended result?
2 Replies
=IF(ISNUMBER(SEARCH("executive",E2)),"exec",IF(D2="Undergraduate","UG",IF(D2="Postgraduate","PG","")))Does this formula return the intended result?
- It works well! Thank you very much for your fast response, much appreciated!
