View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
James James is offline
external usenet poster
 
Posts: 542
Default How to round up to the nearest five

How can I make a 34 to a 35 etc etc.

How can i round up any number to the nearest five or ten?

E.G a 39 to a 40, a 6 to a 10 and a 1132 to a 1135.

thanks.