Quick Links
When you work with decimal numbers, rounding might be part of your equation.
Microsoft Excel offers a few functions to help you quickly and easilyround to perfection.
Let’s take a look at how to use each of these ROUND functions in Excel.
The ROUND Function
The mostbasic of the functionsis ROUND.
With it, you’re able to use a number or cell reference and round up or down.
Related:12 Basic Excel Functions Everybody Should Know
The syntax is
where both arguments are required.
Keep these considerations in mind for thedigitsargument.
Here, we’ll round the value in cell A1 two places to the left of the decimal point.
The ROUNDUP Function
Maybe you have a sheet with numbers that you want to always round up.
This is when the ROUNDUP function is useful.
The syntax isROUNDUP(number, digits)where both arguments are required, just like the ROUND function.
This function also has the same three considerations for thedigitsargument.
To round 5.3692 up two decimal places, you would use the following formula to receive the result 5.37.
The ROUNDDOWN Function
ROUNDDOWN works just like its counterpart above except that it always rounds down.
The syntax isROUNDDOWN(number, digits)where both arguments are required like the above two functions.
And this function has the same three considerations for thedigitsargument.
These functions take the work out of rounding the numbers in your spreadsheet.
