The ROUNDDOWN function rounds down a number to a specified number of digits. In this guide, we’re going to show you how to use the ROUNDDOWN function and also throw in some tips and error handling methods.

Supported versions

  • All versions




number The number to be rounded.
[num_digits] The number of digits.


Firstly a reminder: Named ranges are added to ease of reading formulas.

Example 1

formula returns 314.16; because when num_digits is greater than 0, then number is rounded down to the specified number of decimal places.


Example 2

formula returns 315; because when num_digits is equal to 0, then number is rounded down to the nearest integer.

Example 3

formula returns 400; because when num_digits is less than 0, the number is rounded down to the left of the decimal point.

Download Workbook


  • Unlike generic rounding the ROUNDDOWN function rounds all numbers 1 to 9 down.
  • Use the ROUND for standard rounding.
  • Use the ROUNDUP to always round up.