Error when adding Conditional Columns - We cannot convert the value null to type Logical.

I am dealing with a client's contact list excel file from Marketo, and have appended additional contacts to the file in the same format as the client's list - I did this in the original Excel. In que...