Hi,

Unles your question is really more complicated tahn you describe, this does
what you want

=IF(COUNTA(A1:A2)0,"A Result","")

Mike

"Simony32567" wrote:

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.