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

ROUNDDOWN(number, num_digits)

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

 numberThe number you want to round down (towards zero).
 num_digitsThe number of digits you want to round the number down to.

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

     EXAMPLES
     
     A
    1=ROUNDDOWN(12.34,1) = 12.3
    2=ROUNDDOWN(3.2,0) = 3
    3=ROUNDDOWN(12.99999,2) = 12.99
    4=ROUNDDOWN(89.6548,3) = 89.654
    5=ROUNDDOWN(3.14159,3) = 3.141
    6=ROUNDDOWN(-3.14159,1) = -3.1
    7=ROUNDDOWN(31415.92654,-2) = 31400
    		 
     Functions - R | Index - R | Office Online 

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