Trouble with if then statement in text column causing random character errors

I'm having a bit of trouble with an if then statement in a text column. My variables are coming across as random characters and causing errors. Usually works perfectly. Can anybody help here?