| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blank cell format needed
I am trying to create a running yearly log of the number of times an event
happened. How can I ask Excel to not show (blank) the cells for the upcoming months, until the number of events has been entered for that month, then have it total the current month by adding it to the total of the previous month. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Blank cell format needed
Hi
Try using the IF function. -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "Greenham" wrote: I am trying to create a running yearly log of the number of times an event happened. How can I ask Excel to not show (blank) the cells for the upcoming months, until the number of events has been entered for that month, then have it total the current month by adding it to the total of the previous month. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format if cell is not blank | Excel Discussion (Misc queries) | |||
| How do I make a blank cell with a date format blank? | Excel Worksheet Functions | |||
| Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
Linear Mode
