It would be very helpful if you uploaded the workbook, seeing the actual data the If statement is checking is necessary in understanding why you're not receiving the results you're expecting.

edit: If to It ...