Hi All,

Hope everyone is well. I am trying to write a formula where column B either has a 1 or a 2 in the cell. If 1 exists then show open else if 2 exists then show closed. Any ideas?