Excel ROUNDUP() Function

Excel ROUNDUP() Function

The ROUNDUP() function in excel returns a number rounded up to the nearest possible value and away from zero.

Syntax

ROUNDUP(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 a number rounded up to the nearest possible value and away from zero.

Example 1

Objective: Round up the value to the nearest integer

Numbers Rounded Formula
451.0000000 451.00  =ROUNDUP(A18,0)
123.4500000 124.00  =ROUNDUP(A19,0)
356.3200000 357.00  =ROUNDUP(A20,0)
323.0000000 323.00  =ROUNDUP(A21,0)

Example 2

Objective: Round up value to the nearest hundredth value.

Numbers Rounded Formula
451.0000000 460.00  =ROUNDUP(A18,-2)
123.4500000 200.00  =ROUND(A19,-2)
356.3200000 400.00  =ROUND(A20,-2)
323.0000000 400.00  =ROUND(A21,-2)

Example 3

Objective: Round down value to the nearest ten value.

Numbers Rounded Formula
451.0000000 451.00  =ROUNDUP(A18,1)
123.4500000 123.50  =ROUNDUP(A19,1)
356.3200000 356.40  =ROUNDUP(A20,1)
323.0000000 323.00  =ROUNDUP(A21,1)



ADVERTISEMENT
ADVERTISEMENT