Sunday, 22 July 2012

Excel ROUNDUP Function Syntax and Example

Microsoft Excel ROUNDUP Function:
ROUNDUP Works in the same way as ROUND, however The ROUNDUP function always rounds a number up (away from zero). 

ROUNDUP function will always round the numbers 1-9 up.
ROUNDUP can round either to the left or right of the decimal point.

Syntax:

 =ROUNDUP(number,num_digits)

If num_digits > 0,  number is rounded up to the specified number of decimal places to the right of the decimal point.

If num_digits < 0,  number is rounded up to the left of the decimal point (i.e. to the nearest 10, 100, 1000, etc.).

If num_digits = 0,  number is rounded up to the nearest integer.

Example: 


NUMBER
ROUNDUP
RESULT
1234.1234
 =ROUNDUP(A2,0)
1235
1234.1234
 =ROUNDUP(A3,1)
1234.2
1234.1234
 =ROUNDUP(A4,2)
1234.13
1234.1234
 =ROUNDUP(A5,3)
1234.124

For Better Understanding Please Refer below link of Round Function:

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts