Hide Values when data has not been entered into a cell.

  • Thread starter Thread starter Higgy
  • Start date Start date
H

Higgy

I am trying to create a spreadsheet that has date functions with sums. I
would like to have the cells that will be populated with the sum to be blank
until the data is entered into the fuction Cell. Can anyone help? Thanks
 
Maybe...

=if(a1="","",sum(c1:e1))

Then this cell will look empty until a value is entered in A1.
 
Maybe...

=if(a1="","",sum(c1:e1))

Then this cell will look empty until a value is entered in A1.
 
Back
Top