Multiple IF statement with additional requirements

[Clash]

Hi all,

I have a spreadsheet (attached) that looks at home buyers and their purchases; however what I'm trying to find out is are the sales persons completing their paperwork.

For example, for every house there most be a completion date and posted as "Moved in", but there are a number where this isn't done.

Is there an easy way of asking both questions; if there is an compltion date, has "moved in" been entered and visa versa?

Many thanks

Clash.