Format the cell to be a number with no decimals enter 0 and you should be ok
so then if you are adding the column this cell will have no value

"Chev320" wrote:

I have made a sheet for estimating purposes and i sometimes need a cell to
equal Zero (0) when i am not using that field. The last cell that gives me
the figures is.

=CEILING(SUM(F12*35,0),5)

Any help would be much appreciated.
TIA