- Feb 13, 2008
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.