Thread: divide and round up
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
  
Posts: 2,276
Default divide and round up
Hi,
=roundup(c5/4,0)



"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.
Reply With QuoteReply With Quote