Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Maths and Trigonometry > ROUNDUP
 

ROUNDUP(number, num_digits)

 
 Returns a number rounded up to a specified number of digits.

 numberThe number you want to round up (away from zero).
 num_digitsThe number of digits you want to round the number to.

 REMARKS
 
  		• This function is identical to the ROUND() function, except that it always rounds a number up.
     
  		• If "num_digits" > 0, then "number" is rounded up to the specified number of decimal places.
     
  		• If "num_digits" = 0, then "number" is rounded up to the nearest integer.
     
  		• If "num_digits" is left blank, then "number" is rounded up to the nearest integer.
     
  		• If "num_digits" < 0, then "number" is rounded up to the left of the decimal point.

     EXAMPLES
     
     A
    1=ROUNDUP(3.2,0) = 4
    2=ROUNDUP(76.9,0) = 77
    3=ROUNDUP(3.14159,3) = 3.142
    4=ROUNDUP(16,-2) = 100
    5=ROUNDUP(-3.14159,1) = -3.2
    6=ROUNDUP(31415.92654,-2) = 31500
    		 
     Functions - R | Index - R | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top