How to use the ROUNDDOWN function?

ball ball shaped blur daylight

  • Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010. 

This post gives you a better understanding of how to use the ROUNDDOWN function in Microsoft Excel. It looks at what it means, its formula syntax, key conditions of its use and also an example for you to test to see how it works with some sample data.

A spiral staircase going downwards - symbolise the ROUNDDOWN function.
Image by Dave Walker from Pixabay.


The ROUNDDOWN function simply rounds a number down, heading towards zero.

Formula Syntax of ROUNDDOWN Function

ROUNDDOWN(number, num_digits)

The ROUNDDOWN function syntax contains these listed arguments:

  • Number  –  Required. Any actual number that you prefer to be rounded down.
  • Num_digits  –  Required. The number of digits for which you seek to round number.
A glass of ball featuring an upside-down row of trees. Represents the ROUNDDOWN function in Excel.
Image by Kranich17 from Pixabay.

Key Conditions of using ROUNDDOWN Function

  • ROUNDDOWN mimics ROUND, although it constantly rounds a number down.
  • When num_digits exceeds 0 (zero), then number is rounded down to the verified number of decimal places.
  • Should num_digits be 0, then number is rounded down to the closest integer.
  • If num_digits is under 0, then number is rounded down to the left of the decimal point.


Copy the sample data in the below table, and paste it into cell A1 of a brand new Excel worksheet. For formulas to display results, pick them, press F2, and then press Enter. If you must at any time, you can change the column widths to gain a fuller picture of the entire dataset in all its beauty!

=ROUNDDOWN(3.2, 0)Rounds 3.2 down to zero decimal places.3
=ROUNDDOWN(76.9,0)Rounds 76.9 down to zero decimal places.76
=ROUNDDOWN(3.14159, 3)Rounds 3.14159 down to three decimal places.3.141
=ROUNDDOWN(-3.14159, 1)Rounds -3.14159 down to one decimal place.-3.1
=ROUNDDOWN(31415.92654, -2)Rounds 31415.92654 down to 2 decimal places to the left of the decimal point.31,400

Similar Functions






Other Links

Back to Software Bytes – Official Website

Back to Excel Tutorial

Leave a Reply

%d bloggers like this: