ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Blank cell format needed (https://www.excelbanter.com/excel-discussion-misc-queries/232346-blank-cell-format-needed.html)

Greenham

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.

francis

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.



All times are GMT +1. The time now is 05:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com