| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I set the contents of cell to Null in Excel 2007?
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| print excel spreadsheet splitting cell contents on multiple pages | Excel Discussion (Misc queries) | |||
| visual basic within Access If...Then | Excel Discussion (Misc queries) | |||
| Excel formula to find position of the contents of a cell within a column. | Excel Discussion (Misc queries) | |||
| make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
