< Go Back

Round a number down

Want to learn more about how to round a number down? This post will give you an overview of how to round a number down using the ROUNDDOWN function in Excel.

Formula

=ROUNDDOWN(number,digits)

Explanation

To round a number down regardless of the value of the number being rounded, the ROUNDDOWN function is used to return the digits rounded down to the number of specified digits.

Example

For instance, the formula in cell F4 is
=ROUNDDOWN(B5,C5)

Figure 1. Example of using ROUNDDOWN functi0n

This formula tells Excel to take the numeric value in cell D4 and round it down to the specified decimal places in cell E4 (3) which gives 5499.945

Note that even though the 4th digit after the decimal in 5499.9456  is six (6), but it is still returned (rounded down) as 5499.945.

From the example shown, the ROUNDDOWN function is used to round the same numerical value (5499.9456) to a descending order of digits, starting at -3 and moving down past zero to -3.

Notes

Notice that positive digits round to the right of the decimal point, while negative digits and zero are rounded to the left.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar