How to round number to nearest 5/10/50/100 in Excel?
Sometimes, you may want to convert numbers to nearest 5/10/50/100 for calculation in Excel. This Tutorial provides some simple formulas to round numbers to nearest specific number, and also introduce the formulas to round numbers to next or last nearest one.
Round numbers to nearest 5
Round to nearest 5/10/50/100
Round to nearest 5  =ROUND(A2/5,0)*5 
Round to nearest 10  =ROUND(A2/10,0)*10 
Round to nearest 50  =ROUND(A2/50,0)*50 
Round to nearest 100  =ROUND(A2/100,0)*100 
Note:
You also can use this formula =MROUND(A2,5) to round numbers to nearest 5.
Round to next nearest 5/10/50/100
Round to next nearest 5  =ROUNDUP(A2/5,0)*5 
Round to next nearest 10  =ROUNDUP(A2/10,0)*10 
Round to next nearest 50  =ROUNDUP(A2/50,0)*50 
Round to next nearest 100  =ROUNDUP(A2/100,0)*100 
Round to last nearest 5/10/50/100
Round to last nearest 5  =ROUNDDOWN(A2/5,0)*5 
Round to last nearest 10  =ROUNDDOWN(A2/10,0)*10 
Round to last nearest 50  =ROUNDDOWN(A2/50,0)*50 
Round to last nearest 100  =ROUNDDOWN(A2/100,0)*100 
Easily Round numbers up or down or to even in Excel without formula

As we known, there are some formulas can round numbers, but you do not want to use formula to round numbers, the Round utility of Kutools for Excel can do you a favor. Click for 30 days free trial! 
Kutools for Excel: with more than 300 handy Excel addins, free to try with no limitation in 30 days. 
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
 Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
 Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
 Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
 Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
 Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
 Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
 Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
 Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
 More than 300 powerful features. Supports Office/Excel 20072019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30day free trial. 60day money back guarantee.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
 Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
 Open and create multiple documents in new tabs of the same window, rather than in new windows.
 Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Sort comments by
#18342
This comment was minimized by the moderator on the site
0
0
#18343
This comment was minimized by the moderator on the site
0
0
#18344
This comment was minimized by the moderator on the site
0
0
#18345
This comment was minimized by the moderator on the site
Report
0
0
#37818
This comment was minimized by the moderator on the site
0
0
#37827
This comment was minimized by the moderator on the site
Report
0
0
#20322
This comment was minimized by the moderator on the site
0
0
#20323
This comment was minimized by the moderator on the site
0
0
#22073
This comment was minimized by the moderator on the site
0
0
#22312
This comment was minimized by the moderator on the site
0
0
#22313
This comment was minimized by the moderator on the site
Report
0
0
#22775
This comment was minimized by the moderator on the site
0
0
#22776
This comment was minimized by the moderator on the site
Report
0
0
#25090
This comment was minimized by the moderator on the site
0
0
#25091
This comment was minimized by the moderator on the site
Report
0
0
#25092
This comment was minimized by the moderator on the site
0
0
#26857
This comment was minimized by the moderator on the site
0
0
#26858
This comment was minimized by the moderator on the site
Report
0
0
#26859
This comment was minimized by the moderator on the site
Report
0
0
#28826
This comment was minimized by the moderator on the site
0
0
#36415
This comment was minimized by the moderator on the site
0
0
#36546
This comment was minimized by the moderator on the site
0
0
There are no comments posted here yet