Thread: RoundUp
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default RoundUp

=CEILING(SUM(K32:K33),5)
--
David Biddulph

"Chev320" wrote in message
...
I am trying to round up to the nearest 5 in a formula, and i am having no
luck.. the formula is this "=ROUNDUP(SUM(K32:K33),0)"
I would appreciate any help you could give me.

Thanks