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)