How do I set the contents of cell to Null in Excel 2007?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to average the contents of a cell across multiple worksheet 12
Conditional Expression in cell 1
how to return data from a right hand side/and one cell down 4
setting a cell to null 1
Force unused formula cells to be null 4
Have DGET return Null instead of #Value! 3
How do you split a cell in half? 3
Change a Macro - Copy in Columns instead of copy in Rows 7

Back
Top