Often, the error is an extra space at the end of the value. If Excel is reading A1 as "PTE ", and B1 has =IF(A1="PTE",1,0), it will return a 0 because the two aren't equal. Test the lengths of the first column with =Len(A1) and drag down.

Edit: Just a hair too slow, I guess.