View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
[email protected] hgreenesmith@gmail.com is offline
external usenet poster
 
Posts: 2
Default divide and round up

On Monday, September 21, 2009 at 12:40:02 PM UTC-5, Pammy wrote:
I have a formula: c5/4
I want a formula to divide: c5/4 then round up to a whole number. example:

if the answer is 17.3 I want the answer to be 18.


Very cool thanks! I also got it to work with =ROUNDUP(D5/B4,0) :)