Thread: divide and round up
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default divide and round up
=roundup(c5/4, 0)
--
HTH...

Jim Thomlinson


"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