I’m currently using this simple IF function (If Team Column equals “Undergraduate Robing”, check the box (formula below) but I need the box checked if the team column equals “Undergraduate Robing" or “Faculty Robing” or “Marshals”. Is this possible?
Current Formula: =IF(Team1 = "Undergraduate Robing", 1, 0)
Any assistance is greatly appreciated.
Serena