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:
=IF((A1=OR("Helen","George","Katie","Anna","Rachel","Chris","Tom")),1,(C27+1))
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...
Bookmarks