Find it hard to believe that Excel doesn't have the exlusive OR funcion.

I need something to say either A or B but NOT both. I suppose can write a longer formula to achieve this but....