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

ROUND(number, num_digits)

 
 Returns a number rounded to a specified number of digits.

 numberThe number you want to round.
 num_digitsThe number of digits to which you want to round to.

 REMARKS
 
  		• Any digits less than 5 are rounded down.
     
  		• Any digits greater than or equal to 5 are rounded up.
     
  		• If "num_digits" > 0, then "number" is rounded to the specified number of decimal places.
     
  		• If "num_digits" = 0, then "number" is rounded to the nearest integer.
     
  		• If "num_digits" < 0, then "number" is rounded to the left of the decimal point.
     
  		• This function operates on the actual value in the cell and rounds them so they are consistent with the value that is displayed.
     
  		• Using this function will change the underlying value and not just the value that is displayed.

     EXAMPLES
     
     AB
    1=ROUND(24/5,1)*5 = 24 
    2=ROUND(23,2)*0.25 = 5.75 
    3=ROUND(-1.475,2) = -1.48 
    4=ROUND(123.4567,-2) = 100 
    5=ROUND(123.4567,3) = 123.457 
    6=ROUND(1.23/2,2) = 0.62=1.23/2 = 0.615
    		 
     Functions - R | Index - R | Office Online 

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