Are either of these what you're looking for:

=IF(OR(A2="Blue",A2="Red"),"Keep","Neither")

=IF(OR(A2={"Blue","Red"}),"Keep","Neither")

=IF((A2="Blue")+(A2="Red"),"Keep","Neither")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Katie" wrote in message
...
I know this is a crazy question but I was wondering if I want to say,

If A2 = "blue" or "red" then display "keep". How do I input the "or". I
know
And is displayed as "*".

Thank you.