How to Round Numbers Up or Down Using the ROUNDUP or ROUNDDOWN Functions in Excel

 

Round Numbers Up or Down Using the ROUNDUP or ROUNDDOWN Functions

Sometimes, you may want your numbers to just round numbers up or down instead of having the next digit decide that for you. That’s what the ROUNDUP and ROUNDDOWN functions are for, and and using them is pretty much identical to using the ROUND function.

Click the cell where you want your rounded result to go.

Head to Formulas > Math & Trig, and then choose either the “ROUNDUP” or “ROUNDDOWN” function from the dropdown menu.

Enter the number (or cell) you want to round in the “Number” field. Enter the number of digits to which you want to round in the “Num_digits” field. And the same rules apply as with the ROUND function. A positive integer rounds to the right of the decimal point, zero rounds to the nearest integer, and a negative integer rounds to the left of the decimal point.

Click “OK” when you’ve got things set up.

And just like with the ROUND function, you can also set up the ROUNDUP and ROUNDDOWN functions by typing them into the Function bar, and you can use them as parts of a larger formula.