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
[TABLE="width: 248"]
<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>[TR]
[TD="width: 93, bgcolor: #D9D9D9"]Shift 1
[/TD]
[TD="width: 130, bgcolor: #D9D9D9"]Shift 2[/TD]
[TD="width: 106, bgcolor: #BDD7EE"]Combined
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0[/TD]
[TD="bgcolor: transparent"]DAY[/TD]
[TD="bgcolor: #FCE4D6"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0[/TD]
[TD="bgcolor: transparent"]DAY
[/TD]
[TD="bgcolor: #FCE4D6"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0[/TD]
[TD="bgcolor: transparent"]DAY[/TD]
[TD="bgcolor: #FCE4D6"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0[/TD]
[TD="bgcolor: transparent"]DAY[/TD]
[TD="bgcolor: #FCE4D6"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0[/TD]
[TD="bgcolor: transparent"]Night[/TD]
[TD="bgcolor: #FCE4D6"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0[/TD]
[TD="bgcolor: transparent"]Night[/TD]
[TD="bgcolor: #FCE4D6"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0[/TD]
[TD="bgcolor: transparent"]Night[/TD]
[TD="bgcolor: #FCE4D6"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0[/TD]
[TD="bgcolor: transparent"]Night[/TD]
[TD="bgcolor: #FCE4D6"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0[/TD]
[TD="bgcolor: transparent"]Night[/TD]
[TD="bgcolor: #FCE4D6"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0[/TD]
[TD="bgcolor: transparent"]Night[/TD]
[TD="bgcolor: #FCE4D6"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]DAY[/TD]
[TD="bgcolor: transparent"]0[/TD]
[TD="bgcolor: #FCE4D6"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]DAY[/TD]
[TD="bgcolor: transparent"]0[/TD]
[TD="bgcolor: #FCE4D6"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Night[/TD]
[TD="bgcolor: transparent"]0[/TD]
[TD="bgcolor: #FCE4D6"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Night[/TD]
[TD="bgcolor: transparent"]0[/TD]
[TD="bgcolor: #FCE4D6"] [/TD]
[/TR]
</tbody>[/TABLE]

 

[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.