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)