View Single Post
  #3   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?

That is what I was looking for, thank you for your post.


"vezerid" wrote:

Replace the 0 with NA().

HTH
Kostis Vezerides

On Jan 25, 10:38 pm,
wrote:
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.