Sunday, 22 July 2012

How to ROUNDUP Numbers in Excel

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


Thanks, TAMATAM

No comments:

Post a Comment

Hi User, Thank You for Visiting My Blog. Please Post Your Feedback/Comments/Query.

Subscribe to Blog Posts by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts