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. |
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 |