How to Round Down in Excel

Jun 30, 2020 ยท 5 minute read

we have different methods for rounding the numbers down in excel here we are going to explain some of them.

How to Round Down Digits in Excel with Int Command;

If you want to round down a number to the nearest integer you can use this formula.

you should pay attention, this command round down negative digits away from zero.

For that, you can use this formula

=INT(D5)

In this formula, “D5” is the address of the cell which you want to round it down.

int

If you want to have decimal part of positive digits, you can use this formula;

=D5-INT(D5)

In this formula, “D5” is the address of the cell, which you want to calculate the decimal part of the number on it.

decimal

How to Round Down Digits in Excel with Floor.MATH Command;

“Floor.MATH” is the other formula which you can use it to round down the digits in excel.

This formula has 3 part

  • Number;

You should fill this part and it is the value which you want to round it down.

  • Significance;

This part is optional, it is the multiple integers, you want to round that value to it. if you don’t fill this part, the program will consider this number equal to one.

  • Mode;

This part is optional. if the number which you want to round it down is negative you can use from this part.

if you specify (-1) the negative numbers will round toward Zero and if you specify (0) the negative numbers will round away Zero.

Here we are going to explain this command by some example;

In this picture, we want to round down positive numbers to the nearest digit

For that, you can use this formula,

=FLOOR.MATH(E5,1)

Here “E5” is the address of the cell which you want to round them down. the second part in this formula is optional and if you don’t write anything the program will consider for this part number one.

It shows that you want to round down the value to the nearest integer.

floor math 1

If you want to round down the negative digits you can use this formula

In the third part of this formula, when you want to round down negative numbers toward zero you should use non zero numbers like

=FLOOR.MATH(E5,1,-1)

and if you want to round down the numbers away from zero you should use zero number.

=FLOOR.MATH(E5,1,0)

floor math 0

If you want to round down numbers to nearest multiple numbers two, you can use this formula;

For positive numbers, you can use this formula

=FLOOR.MATH(E5,2)

Here “E5” is the address of the cell which you want to round it down.

floor math2

For negative numbers you can use this formula for rounding down digits away from zero

=FLOOR.MATH(E5,2,0)

and this formula for rounding down numbers to nearest 2 multiple integers toward zero.

=FLOOR.MATH(E5,2,-1)

floor math 2 0

For rounding down the number to nearest 5 multiple integers you can use this formula.

=FLOOR.MATH(E5,5)

Here “E5” is the address of the cell which you want to round them down and five shows that you want to round the number down to multiple 5 integers.

floor math 5

For rounding down the number to nearest 10 multiple integers you can use this formula.

=FLOOR.MATH(E5,10)

Here “E5” is the address of the cell which you want to round them down and ten shows that you want to round the number down to multiple ten integers.

floor math 10

How to Round Down Digits in Excel with Round Down Command;

This formula has two parts;

The first part is the Number and it related to the value which you want to round them down.

Second Part is the “Num_digits”:

If “Num_digits” was less than zero it shows that you want to round down the numbers to the left of the decimal point and also shows that from which digit in the left of the decimal point, you want to round down the numbers.

If you choose zero shows that you want to round down to the nearest integer

If you choose the numbers higher than zero, the number shows that from which digit in the right of the decimal point, you want to round down the numbers.

Here we are going to explain it with some question.

If you have positive numbers and you want to round down them to the nearest decimal place you can use this formula.

=ROUNDDOWN(E5,1)

Here “E5” is the address of the cell which you want to round its value down.

round down 1

If you have negative numbers you can use from this formula too but you should pay attention the numbers will be round down to zero.

round down 1 n

For rounding numbers down to the nearest integer you can use this formula.

=ROUNDDOWN(E5,0)

In this formula, “E5” is the address of the cell which you want to round its value down.

round down 0

You can see for negative numbers the value of cell round down to the zero.

round down n0

If you want to round down the numbers to the first left digit of the decimal point you can use this formula.

=ROUNDDOWN(E5,-1)

Here “E5” is the address of the cell which you want to round its value down.

round down n1

If your numbers are negative you can see these numbers will be rounded down to the zero.

round down n 1

excel round