I often use Excel to do quick and dirty data manipulation tasks when it would otherwise take longer to do it in SAS.  Every once in awhile I need to search the internet to learn how to do something seemingly simple, such as rounding to the nearest 5.

In my searching, I stumbled across this nice little repository of Excel tips.  If I come across more, I'll try to remember to add them here.  If you have any good Excel links, please post them in the comments.  Thanks!

Excel Tips - http://www.contextures.com/xlfaqFun.html

Here are 2 ways to round a number to the nearest 5 using MS Excel. 

Method 1:

=ROUND(A1/5,0)*5

Method 2: Install the Analysis Tool Pack Add-In then type

=MROUND(A1,5)