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.