if statement
 

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?

if statement
 

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.


"Debra Reid" wrote:

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?

if statement
 

Text strings should be within quotes...

=IF(OR(A1="v",A1="m"),"Yes","No")

--
Jacob


"Debra Reid" wrote:

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?

if statement
 

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

"Mike H" wrote:

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.


"Debra Reid" wrote:

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?

if statement
 

Thanks this helps.

"Jacob Skaria" wrote:

Text strings should be within quotes...

=IF(OR(A1="v",A1="m"),"Yes","No")

--
Jacob


"Debra Reid" wrote:

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?

if statement
 

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?