View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John A. John A. is offline
external usenet poster
 
Posts: 2
Default Excel formula needed to round up a value to a whole number

I'm making a cost estimation sheet, and need a cell to publish a whole
number. This cell is the result of a division formula involving two other
cells (ie. 300 sq ft of coverage divided by 200 sq ft of coverage per gallon
= 1.5 gallons). I want my formula to round the 1.5 gallons up to 2 gallons.

Please help!

Thanks,

John