Calculated column post code and status

[Anonymous]

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!

[Pragati11]

Hi @Anonymous ,

Can you please share screenshot of sample data and the output required?

Thanks,

Pragati