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

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
 
D

Dave Peterson

Maybe...

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

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

Dave Peterson

Maybe...

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Leaving a formula cell blank when data has not yet been added. 5
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Adding rows once data is entered 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Hide cell unless value entered into any cell on a row 3
Totaling a row only if there are values in it 4
Change color of cell when different cell has data entered 1
Trying to run excel vba code when cell value changes from empty to entered value. 1

Top