How to use the ROUNDDOWN function in Excel

The ROUNDDOWN function rounds a number down (toward zero) to a specified number of digits.

The ROUNDDOWN function uses these arguments:
=ROUNDDOWN(number; num_digits)

Number (Required): The value you want to round down
Num_digits (Required): The number of digits to round to

USING THE ROUNDDOWN FUNCTION

Let’s round down 1233,345 to various precision levels:

1. One decimal place:
   =ROUNDDOWN(A1; 1) → Returns 1233,3

1. Two decimal places:
   =ROUNDDOWN(A1; 2) → Returns 1233,34

1. Nearest integer:
   =ROUNDDOWN(A1; 0) → Returns 1233

1. Nearest 10:
   =ROUNDDOWN(A1; -1) → Returns 1230

1. Nearest 100:
   =ROUNDDOWN(A1; -2) → Returns 1200

1. Nearest 1000:
   =ROUNDDOWN(A1; -3) → Returns 1000

Note: Unlike the standard ROUND function, ROUNDDOWN always rounds numbers downward regardless of the digit value.