View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
 
Posts: 972
Default 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)