Complex If Statement

Ok, I have a fairly complex (and probably unsophisticated) if then statement.

It worked on one row, but when I copied it down, it didn't seem didn't work anymore.

I'm confused by it, it's fairly long, and I'm not sure where the problem is... I've included an example, but I have to copy this down for 1000 rows, so I need that functionality.

Thanks!