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