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

ADVERTISEMENT
ADVERTISEMENT