Forum Discussion
IF & AND not working
Hello. I have a curious case. On a Excel sheet, trying to use IF & AND. =IF(AND(SHEET1!C2="Normal";SHEET1!D2="FALSE");"OK";"NOK") C2 and D2 are "Normal" and "False" filled. The formula returns me...
Ok, this worked. The question is, why?
Both cells are text (normal and false are text), why one works with " and the other does not work?
I strongly suspect that the FALSE values are Boolean values, not really text.
If they had been text, your formula would have worked.
As I understood it works if enter such texts manually, but doesn't work if copy/paste values from Web. Thus instead of poor "False" it could be same word with addition of non-breaking space at the end or like.
