Here's another way...

=IF(OR(A1={"V","M","D","A"}),"Yes","No")

--
Biff
Microsoft Excel MVP


"Debra Reid" <Debra wrote in message
...
In using the "if" statement I would like the logic portion to state that
if
cell# = v or m or d or a but the if statement seems to only work if the
logic
is = to a number. Should I be using another formula?