ROUNDDOWN Function

The ROUNDDOWN function in Excel returns a number rounded down to a specified number of places. Unlike on other functions, ROUNDDOWN rounds all numbers down. This is demonstrated in the examples below.

Syntax:

 =ROUNDDOWN(number,num_digits) 

Arguments:

  • number – Number to round.
  • num_digits – The number of digits the number is to be rounded down.
DigitsBehavior
>0 Round down to nearest .1, .01, .001, .0001 etc.
<0 Round down to nearest 10, 100, 1000, 10000 etc.
=0 Round down to nearest 1

ROUNDDOWN Function Example

Let’s look at the example below. It shows how Excel rounds down various numbers based on your criteria.

Rounding Functions in Excel

ROUND Function – Rounds to a specified number of digits.

ROUNDUP Function – Rounds numbers up a specified decimal place.

ROUNDDOWN Function – Returns a number rounded down to a specified number of places.

FLOOR Function – Rounds a given number down to the nearest specified multiple

MROUND Function – Round a number up or down to a given multiple.

CEILING Function – Rounds a given number up to the nearest specified multiple.

INT Function – Rounds a number down to the nearest integer.

TRUNC Function – Returns a truncated number based on a specified number of digits.