Calculated column post code and status

I have two columns, status and post code.

Status can either be, in office or at home. Post code is the persons home address.

I’d like a calculated column that inserts the office post code (this will always be the same) if in office, and inserts the persons home post code if at home.

Thanks!