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

Math and trigonometry


Rounds a number towards zero

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


ROUNDDOWN(number, num_digits)

  • number  Required. Any real number that you want to rounded towards zero.
  • num_digits  Required. The number of digits to which you want to round the number.

Applies To

Excel 2003 and above

A Note About "Rounding"

In Excel, numbers can "round" in two ways.

First, they can round up or down. With this type of rounding, numbers get larger when they are rounded up, and smaller when they are rounded down.

Second, numbers can round towards zero or away from zero. When positive numbers are rounded towards zero, they get smaller; when negative numbers are rounded towards zero, they get larger.

Although Microsoft uses "round up" and "round down" to describe both types of rounding, we use "round up" or "round down" to describe the first type of rounding. And we use "round towards zero" or "round away from zero" to describe the second type.


  • ROUNDDOWN works like ROUND, except that it always rounds a number towards zero.
  • If num_digits is greater than 0 (zero), then number is rounded down to the specified number of decimal places.
  • If num_digits is 0, then number is rounded down to the nearest integer.
  • If num_digits is less than 0, then number is rounded down to the left of the decimal point.


You can download this example workbook here, along with all other example workbooks I've completed for this Excel help area.

Examples of Excel's ROUNDDOWN function.

Other ExcelUser Information

Other Help


Charley's SwipeFile charts

Free Excel Dashboards