Excel ROUND() Function
Excel ROUND() Function
The ROUND() function in excel rounds the numbers to specified digits.
Syntax
ROUND(Number,num_digits)
Parameter
Number(required)- This parameter represents the number which you want to round up.
num_digits(required)- This parameter represents the number of decimal places to which you want it to round up.
Category
Math & Trig
Returns
This function returns the rounded number value in the cell.
Example 1
Objective: Use ROUND function to reduce the decimal places of the number to its nearest integer value.
| Numbers | Rounded | Formula |
| 45.3976106 | 45.00 | =ROUND(A18,0) |
| 50.6546265 | 51.00 | =ROUND(A19,0) |
| 85.4139093 | 85.00 | =ROUND(A20,0) |
| 33.5893471 | 34.00 | =ROUND(A21,0) |
Example 2
Objective: Use ROUND function to reduce the decimal places of the number to its nearest 2 integer value.
| Numbers | Rounded | Formula |
| 45.3976106 | 45.40 | =ROUND(A18,2) |
| 50.6546265 | 50.65 | =ROUND(A19,2) |
| 85.4139093 | 85.41 | =ROUND(A20,2) |
| 33.5893471 | 33.59 | =ROUND(A21,2) |
Example 3
Objective: Round the value to the nearest hundredth value.
| Numbers | Rounded | Formula |
| 451.0000000 | 450.00 | =ROUND(A18,-2) |
| 123.4500000 | 100.00 | =ROUND(A19,-2) |
| 356.3200000 | 400.00 | =ROUND(A20,-2) |
| 323.0000000 | 300.00 | =ROUND(A21,-2) |