if statement

  • Thread starter Thread starter Debra Reid
  • Start date Start date
D

Debra Reid

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?
 
Hi,

try this

=IF(OR(A1="v",A1="m",A1="d",A1="a"),"Found one","Nope not there")
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Sorry about the double posting. I have never used this before and when I
posted it gave me an error so I did not think it would post.

thank-you greatly. Both suggestions worked.

Debra
 
Back
Top