Hide Values when data has not been entered into a cell.
Maybe...
=if(a1="","",sum(c1:e1))
Then this cell will look empty until a value is entered in A1.
Higgy wrote:
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
--
Dave Peterson
|