Adding Cells from two sheets together, need the total to equal zero if one of the cells equals zero.

[hurricaneadam2003]

I have three sheets a budget, actuals , and then a performance sheet (the difference between what we budgeted and what we spent). Each are divided by months and expenses. The equation is =SUM(Budget:Actuals!B6). I want to make it so cells in the performance sheet don't populate if there is a zero or no number in the corresponding cell in the actuals sheet. Right now the performance sheet looks like a duplicate of the budget. I would rather it be blank until we begin populating the actuals sheet.

 

[oldbrewer]

=if(or(sheet2!A1=0,sheet2!A1=""),"",sheet2!A1)

 

[hurricaneadam2003]

Thanks! I think I am messing it up though. Probably just one adjustment off. Here is what I got <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'}span.s1 {color: #006107}span.s2 {color: #ab30d6}</style>=IF(OR(Actuals!B6=0,Actuals!B6=(Budget!B6-Actuals!B6)),(Budget!B6-Actuals!B6),Actuals!B6)

 

[hurricaneadam2003]

I think I figured it.<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'}span.s1 {color: #006107}</style>=IF(OR(Actuals!B6=0,Actuals!B6=0),(0),(Budget!B6-Actuals!B6))