S
Simony32567
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.
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.