Help with OR function

[Guest]

I'm sure I'm doing something silly, but the following formula is evaluating
to #VALUE! instead of TRUE or FALSE (depending on what is contained in cell
I2):

=I2=OR("Ignore","Not Feasible")

Can someone kindly tell me how to fix my formula?

Thanks.

 

[Guest]

Try this:
=OR(I2="Ignore",I2="Not Feasible")

 

[Noob Jedi]

I'm sure I'm doing something silly, but the following formula is evaluating
to #VALUE! instead of TRUE or FALSE (depending on what is contained in cell
I2):

=I2=OR("Ignore","Not Feasible")

Can someone kindly tell me how to fix my formula?

Thanks.

What is your complete purpose of the formula? It looks like you may
have to use =if(or( in your formula.

 

[Noob Jedi]

I'm sure I'm doing something silly, but the following formula is evaluating
to #VALUE! instead of TRUE or FALSE (depending on what is contained in cell
I2):

=I2=OR("Ignore","Not Feasible")

Can someone kindly tell me how to fix my formula?

Thanks.

Sorry, should've given you my formula with it:

=IF(OR(I2="Ignore",I2="Not Feasible"),TRUE, FALSE)

 

[Guest]

Michael,
Thanks!
Bob

Try this:
=OR(I2="Ignore",I2="Not Feasible")
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.

 

[Guest]

Thanks for your suggestion! What I was looking for is:

=OR(I2="Ignore",I2="Not Feasible")

Thanks again,
Bob

 

[Noob Jedi]

Thanks for your suggestion! What I was looking for is:

=OR(I2="Ignore",I2="Not Feasible")

Thanks again,
Bob







- Show quoted text -

It's initially the same thing.