Total newbie needing help with IF/OR function

So I don't really know how to use excel and after searching for an hour and a half on the internet for the solution without any fixes working, decided to give in and ask. Sorry!

Pretty simple, I want a cell to display a certain value if another cell has certain names in it.

So I tried:

Please Login or Register  to view this content.

wanting if any of the names were in cell A1 then it would come back as 1 and if not then as C27+1.. I just keep getting a #VALUE error. I've tried different things but I'm pretty clueless...

So simple! Thankyou so much!!! Literally was at my wits end