I have created a spreadsheet for staff scheduling and want to display a
result in a cell that could have 3 possible outcomes.

Firstly if there is a value in A1 and not A2 then display a result in B1
Secondly if there is a value in A2 and not A1 then display a result in B1
Thirdly if there is a value in A1 and A2 then display a result in B1

Can all this be done in 1 formula to display and 1 of the outcomes in the
same cell?

Thanks for any help.