| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want the cell to be blank instead of zero
My formula is very simple =G$1 always in all cell exception is when the cell
G$1 is blank I don't want a zero I want the cells to remain blank. I plan on putting H for holiday or R for Rain day in a gantt chart. So that on those days we know that we didn't work. I know that I could use "" double quotation marks with an IF statement but can't seem to put it together to make it work. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I want the cell to be blank instead of zero
=IF(ISBLANK(G1),"",G1)
Dave -- Brevity is the soul of wit. "Kim Shelton at PDC" wrote: My formula is very simple =G$1 always in all cell exception is when the cell G$1 is blank I don't want a zero I want the cells to remain blank. I plan on putting H for holiday or R for Rain day in a gantt chart. So that on those days we know that we didn't work. I know that I could use "" double quotation marks with an IF statement but can't seem to put it together to make it work. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I want the cell to be blank instead of zero
Thanks Works Great
"Dave F" wrote: =IF(ISBLANK(G1),"",G1) Dave -- Brevity is the soul of wit. "Kim Shelton at PDC" wrote: My formula is very simple =G$1 always in all cell exception is when the cell G$1 is blank I don't want a zero I want the cells to remain blank. I plan on putting H for holiday or R for Rain day in a gantt chart. So that on those days we know that we didn't work. I know that I could use "" double quotation marks with an IF statement but can't seem to put it together to make it work. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I want the cell to be blank instead of zero
Alternatively, conditionally format the cells to display whiite text an a
white background (i.e. blank) if the value is zero. "Kim Shelton at PDC" wrote: My formula is very simple =G$1 always in all cell exception is when the cell G$1 is blank I don't want a zero I want the cells to remain blank. I plan on putting H for holiday or R for Rain day in a gantt chart. So that on those days we know that we didn't work. I know that I could use "" double quotation marks with an IF statement but can't seem to put it together to make it work. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array formula returns blank in the cell where it is entered | Excel Worksheet Functions | |||
| Setting Purely BLANK Cell | Excel Worksheet Functions | |||
| Replace null string with blank cell | Excel Discussion (Misc queries) | |||
| Look for change next blank cell in Range | Excel Worksheet Functions | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
Linear Mode
