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