Help with OR function

B

Bob

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.
 
N

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.
Click to expand...

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

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.
Click to expand...

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

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

Bob

Michael,
Thanks!
Bob

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

Michael Arch.
Click to expand...
 
B

Bob

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

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

Thanks again,
Bob
 
N

Noob Jedi

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

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

Thanks again,
Bob







- Show quoted text -
Click to expand...

It's initially the same thing.
 
Top