| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
empty cell question
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 |
|
#2
|
|||
|
|||
|
Post the formula that you're using.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "D" wrote in message ... 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 |
|
#3
|
|||
|
|||
|
Simple formula -- in column F5 =(sum)F5+E5 copied down the column
Thanks "D" wrote: 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 |
|
#4
|
|||
|
|||
|
Try
=IF(SUM(F5+E5=0),"",F5+E5) Regards Michael Mitchelson "D" wrote: Simple formula -- in column F5 =(sum)F5+E5 copied down the column Thanks "D" wrote: 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 |
|
#5
|
|||
|
|||
|
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,"") -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "D" wrote in message ... Simple formula -- in column F5 =(sum)F5+E5 copied down the column Thanks "D" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Empty cell control | Excel Worksheet Functions | |||
| Unsolvable cell naming question: Can anyone beat this one? | Excel Discussion (Misc queries) | |||
| Excel question? Regarding cell formula | Excel Worksheet Functions | |||
| Function making cell really "empty" | Excel Worksheet Functions | |||
Linear Mode
