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...
=IF(ISNUMBER(SEARCH("executive",E2)),"exec",IF(D2="Undergraduate","UG",IF(D2="Postgraduate","PG","")))Does this formula return the intended result?
=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!
