Formula Required

[Johnboy28]

Hi,

I'm after a formula that can calculate - If shift 1 equal zero it will return shift 2 and verse versa

Thank you

Shift 1	Shift 2	Combined
0	DAY
0	DAY
0	DAY
0	DAY
0	Night
0	Night
0	Night
0	Night
0	Night
0	Night
DAY	0
DAY	0
Night	0
Night	0

<colgroup><col width="93" style="width: 70pt; mso-width-source: userset; mso-width-alt: 3401;"> <col width="130" style="width: 98pt; mso-width-source: userset; mso-width-alt: 4754;"> <col width="106" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3876;"> <tbody> </tbody>

 

[Exceladd1ct]

Does this do the job?

=IF(A1=”0”, B1,A1)

 

[gallen]

This specifucally looks for zero value, if itsn't 0 then nothing will display

=IF(A2=0,B2,IF(B2=0,A2,""))

 

[Johnboy28]

Thank you. That works great.