How to Validate Email Addresses and Create Verified Status in Excel

Hi there, I have created a column to validate email addresses via Zerobounce which is returning the result Valid email OR Invalid email - I then want to create a final column which has the Email status as verified or unverified. I have tried using the AI formula generator but I've been unable to - can you provide some assistance.