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 assume "FALSE" is text, not Boolean False.
Yes, with copy/pasting or importing from Web that could be not printable characters. You may try to apply TRIM(), CLEAN() to formula, but that not always works. Better to have small sample file to check with few values in question.