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) |