SOLVED

# If formula for contains specific text

Brass Contributor

# 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"

Jenny

2 Replies
best response confirmed by JennySommet (Brass Contributor)
Solution

# Re: If formula for contains specific text

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

Does this formula return the intended result?

# Re: If formula for contains specific text

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

Accepted Solutions
best response confirmed by JennySommet (Brass Contributor)
Solution

# Re: If formula for contains specific text

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

Does this formula return the intended result?