empty cell question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that has a column for figures for each day of the month,
I want to have an empty cell until the information is inputed for that day
or if there is not information the cell would stay blank and the next one
used as needed. I have my formula copied down for the month and that is why
there is a 0 until needed. Any help is appreciated.
Thanks
 
Simple formula -- in column F5 =(sum)F5+E5 copied down the column
Thanks
 
It depends on if there is a possibility that *either* cell may *not* have to
be populated, meaning ... will *both* cells *always* contain a number, or
could there be a time when one might remain empty.

See which of these works for you:

=IF(AND(F5<>"",E5<>""),E5+F5,"")

=IF(OR(F5<>"",E5<>""),E5+F5,"")
 
You must log in or register to reply here.

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

Excel formula, sum the value cell and if empty cell left blank 0
Blanking cells with formulas 2
Empty Cell 4
VBA set thick borders around non empty cells in range 0
Hide columns based on row values 2
fill down empty cells at every change in value 4
Need blank cells to remain empty 7
Sumif based within non blank cells 3

Back
Top