Cell to Show blank space if pulling value of 0

[Turner21]

Hi all, could use some help with a formula in my workbook.

Creating a total tab which pulls from two other tabs.

Looking for a formula that will pull the totals from the other tabs, but if the value is 0, than show the cell as completely blank.

Example: Cell B24 = (Tab1 Cell B24 + Tab2 Cell B24)

What can I add to show this cell as 0 if nothing is was input on those cells in tab 1/2.

Thank you.
Bill

 

[Joe4]

Welcome to the Board!

Either use this structure:
=IF(sum formula = 0,"",sum formula)

Or just use a Custom Format to not show 0 values.
See: Three ways to hide zero values in an Excel sheet - TechRepublic

 

[Weazel]

maybe something like...

=IF(SUM('tab1:tab2'!B24)=0,"",SUM('tab1:tab2'!B24))

 

[Turner21]

Perfect, thank you. Was trying the "If" formula for a bit was always missing something.

Thanks for the welcome.