View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chev320 Chev320 is offline
external usenet poster
 
Posts: 13
Default Making a cell equal to Zero

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