IF Statement not working

[christinamfisher]

Hi! I am trying to convert 'TRUE/FALSE' values into binaries (0 and 1). I am using the IF statement =IF(B2="FALSE",0,1). The list is returning either all zeros or all ones. Ideas on how to fix this? I have tried converting to text and to general. I believe the syntax is correct as I have used it previously like this : =IF(E2="Under",1,0) in another workbook. I have also tried to copy and paste into another workbook. Any help would be GREATLY appreciated.

 

[jtakw]

It probably would have worked just using the first formula I suggested in Post #9 using just the CLEAN Function, this "strips" all the Line Breaks and Non-Printable characters ("hidden characters") in the cell.

I'm glad it's working for you now, and You're Welcome.