For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  

Math and trigonometry

Overview of Excel's Rounding Functions

These tables summarize the performance of Excel's worksheet functions designed primarily to round data

by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

Excel 2013 offers 15 functions that round data in various ways. The first table describes them briefly. The first table summarizes their key features.

Excel Rounding Direction Type of Rounding
Version Up Down > 0 < < 0 > Nearest Integer Multiple # Digits
CEILING 2003   x x
CEILING.MATH 2013 x   opt x opt
CEILING.PRECISE 2010 x x opt
EVEN 2003 x x
FLOOR 2003     x       x  
FLOOR.MATH 2003   x opt     opt  
FLOOR.PRECISE 2010   x         x  
INT 2003   x       x    
ISO.CEILING 2010 x         x opt  
MROUND 2003         x   x  
ODD 2003 x         x    
ROUND 2003         x     x
ROUNDDOWN 2003     x         x
ROUNDUP 2003       x       x
TRUNC 2003     x     x    

Charley's SwipeFile charts

Free Excel Dashboards