Help with OR function
 

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.

Help with OR function
 

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

Michael Arch.




"Bob" wrote:

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.

Help with OR function
 

On Aug 28, 9:46 am, Bob wrote:
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.

Help with OR function
 

On Aug 28, 9:46 am, Bob wrote:
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)

Help with OR function
 

Michael,
Thanks!
Bob

"Michael" wrote:

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

Michael Arch.




"Bob" wrote:

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.

Help with OR function
 

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

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

Thanks again,
Bob


"Noob Jedi" wrote:

On Aug 28, 9:46 am, Bob wrote:
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)

Help with OR function
 

On Aug 28, 10:44 am, Bob wrote:
Thanks for your suggestion! What I was looking for is:

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

Thanks again,
Bob



"Noob Jedi" wrote:
On Aug 28, 9:46 am, Bob wrote:
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)- Hide quoted text -

- Show quoted text -

It's initially the same thing.