Excel formula to set cell value - Stack Overflow

Yes A1 and B1 are example cells. What I want to happen is that when the value "Yes" is placed in A1, the value of B1 changes to "-" but also when "yes" is placed into B1, the value of A1 changes to "-" Using Excel 2011 for Mac – Adam Jan 20 '13 at ...

stackoverflow.com