View Single Post
  #1   Report Post  
Old June 3rd 15, 02:40 PM posted to microsoft.public.excel.worksheet.functions
Don B[_2_] Don B[_2_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2009
Posts: 5
Default IF Statement return wrong comparison

I have a If statement in L95 as follows: IF(L95="District Did Not Investigate" and L95 contains this statement It returns a FALSE answer when the answer should be TRUE. WHY?