IF function: Using text in logical_test with multiple variables and replacing with text

Hi all,

I really hope you guys will be able to help me - I'm new here and a bit of an excel newbie!

I am trying to work out if the IF function can be formulated to take multiple queries.

I have a database with 'Content' (A2) entries in the rows that I want to categorise into 'Department' (E2)

What I'd like to do is a formula that basically gives me the following:

E2=IF(A2="Olympics" or "London2012" or "Paralympics" or "#Energy2012", "Brand", "0")

Is it possible to effectively have keyword groups within the function?

Also, this content is being exported from Twitter so includes alot of @ and #, I noticed when typing @ in cells Excel rejects it. Is this going to cause a problems when sorting through the data?

Thanks in advance
Sarah