Hi,

I want a forumla that states IF cell F5 contains "paint" then return "@PAINT"

F5 may contain other values as well besides 'paint' so =if(f5="paint","@PAINT","") won't work.

Many thanks