What is the formula to make cells that auto-fill with a "0" to auto-fill blank instead?

[devinberry1997]

I have a sheet set so that when you populate the cells with totals on one tab, they auto fill in the "G" column on another tab. However, when there are no totals populating the column on the first tab the second tab populates the cells in that "G" column with a zero where I would like it to be blank. Any help would be appreciated!

 

[Asbestos_Jen]

What is the current formula in that column?
If G2 is =Sheet1!C2, you could use:

=if(Sheet1!C2=0,"",Sheet1!C2)

 

[devinberry1997]

What is the current formula in that column?
If G2 is =Sheet1!C2, you could use:

=if(Sheet1!C2=0,"",Sheet1!C2)

Current formula is: ='Report Sheet'!L8

I'm hoping the second image here gives you a better idea of what I'm trying to do.

 

[Asbestos_Jen]

In that case, this will do what you want.

=if('Report Sheet'!L8=0,"",'Report Sheet'!L8)

 

[RobOrBob]

Or you could just set a conditional formatting on the cells to make the font colour white and this will hide them whilst still retaining the zero value.

 

[devinberry1997]

In that case, this will do what you want.

=if('Report Sheet'!L8=0,"",'Report Sheet'!L8)

This worked PERFECTLY! Thank you so much for your help!

 

[Asbestos_Jen]

Glad to have helped. Thanks for the feedback.