View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chacky Chacky is offline
external usenet poster
 
Posts: 8
Default ROUNDUP Function

Can I use ROUNDUP to round up to the nearest 5.

If the answer to a calculation is 52, I want to round up to 55.

I know that ROUNDUP(52, -1) will round up to the next 10 i.e. 60
but can you round up to the nearest 5