 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.

## 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.