View Single Post
  #2   Report Post  
Old June 4th 15, 01:12 AM posted to microsoft.public.excel.worksheet.functions
Howard Silcock Howard Silcock is offline
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2013
Posts: 16
Default IF Statement return wrong comparison

On Wednesday, 3 June 2015 23:40:42 UTC+10, Don B wrote:
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?


Most likely there's an extra space in the text in L95 or a change of case somewhere. One way to get around this would be to change your formula to start
=IF(TRIM(UPPER(L95))="DISTRICT DID NOT INVESTIGATE" ...

That should give the right result whether or not there are extra spaces around the text or the case is incorrect.

Howard