If formula for contains specific text

[JennySommet]

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

[#2 · Accepted solution]

@JennySommet 

=IF(ISNUMBER(SEARCH("executive",E2)),"exec",IF(D2="Undergraduate","UG",IF(D2="Postgraduate","PG","")))

Does this formula return the intended result? 

[#3]

It works well! Thank you very much for your fast response, much appreciated!