Cell "show value" issue

[Eric Livesay]

I'm having a brain sneeze. I have forgotten how to set a cell to not show a sum value when all cells aren't filled in. Here's the issue: I have a "sub-total" cell that delivers the sum of 12 other cells and a "delivery fee" cell that has the value of $3.00. I need the "Total" cell to be blank if there isn't a value in the "Sub-total" cell so the sheet can be printed and filled in manually.

Thanks, eric

 

[DonkeyOte]

total cell

=IF(ISBLANK(subtotalcell),"",subtotalcell+deliverycell)

assumes you're only interested in blanks rather than zeroes in subtotal.

 

[al_b_cnu]

Hi, you mean something like =if(sub-total-cell=0,"",sum(xxxx))

 

[Eric Livesay]

Thanks al_b_cnu, that worked perfectly. lasw10's didn't work because I had "zero" values.

 

[DonkeyOte]

Glad you resolved, always best to be as clear as possible -- "isn't a value" doesn't necessarily read as = 0.