« Accuwebhosting - bad web hosting company | Main | DemoCamp Edmonton - May 20 2008 - Tech Show and Tell »

Excel: Round to the nearest 5

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)

Posted on Monday, May 5, 2008 by Registered CommenterJared in | CommentsPost a Comment

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>