Apr 24 2023 08:31 AM
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
Apr 24 2023 08:48 AM
Solution=IF(ISNUMBER(SEARCH("executive",E2)),"exec",IF(D2="Undergraduate","UG",IF(D2="Postgraduate","PG","")))
Does this formula return the intended result?
Apr 24 2023 09:19 AM