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