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...
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.