Help with formula - if/and?

Hi all,

I'm wondering if anybody could help me with the attached workbook, I have highlighted the column I need help with in green. I have tried using the IF & AND functions but unfortunately no luck.

Essentially I want to autofill column C with the following conditions:
- If column A says 'Permanent' and column B is empty, Column C returns 'Correct Permanent Contract'
- If column A says 'Permanent' and column B has an entry, Column C returns 'Permanent Contract Error'
- If column A says 'Fixed Term' and column B is empty, Column C returns 'Contract End Date Incomplete'
- If column A says 'Fixed Term' and column B has an entry, Column C returns 'Contract End Date Complete'

Any help would be greatly appreciated if it can be done.

Thanks!

Clean all expected results.

Please Login or Register  to view this content.

Brilliant. Thanks a lot!!

One for luck

Formula:

Please Login or Register  to view this content.