Making a cell equal to Zero

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

The last comment didnt come through..
I need the last cell to equal 0 when i place a number in another cell, it
currently gives me a dollar amount ,if i enter, Example 4=$20.00... but if i
place a 100 in the cell it gives me a $1.00 Figure. So i am trying to make
the 100 equal 0. Can this be done. Sometimes i am not using certain cells and
almost want to shut them off or make them equal 0.

 

[Roger Govier]

Hi

Try
=IF(F12="","",CEILING(F12*35,5))

 

[Guest]

I tried it, with no luck, but thanks anyway.

Hi

Try
=IF(F12="","",CEILING(F12*35,5))