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.