Thread: How do I set the contents of cell to Null in Excel 2007?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] jones.derek@jdirving.com is offline
external usenet poster
  
Posts: 4
Default How do I set the contents of cell to Null in Excel 2007?
I'm using this currently, "IF(ISBLANK(I2),0,(I3-I5)/100)" the problem is that
since the cell has "0" in it, it is showing up in the associated graph when
that time frame has not happened yet. What I want to have the graph not pick
up those cells yet and the only way I know how to do this is to have a Null
value, and at the same time I want to avoid adjusting the Data Source each
month just to avoid this issue.
Reply With QuoteReply With Quote