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

FLOOR(number, significance)

 
 Returns the number rounded down to the nearest integer or significant figure.

 numberThe value you want to round down (towards zero).
 significanceThe multiple to which you want to round.

 REMARKS
 
  		• If any of the arguments are not numeric, then #VALUE! is returned.
     
  		• If "number" or "significance" have different signs, then #NUM! is returned (last example ?)
     
  		• Regardless of the sign of number, a value is rounded down when adjusted away from zero. If number is an exact multiple of significance, no rounding occurs.
     
  		• This function is very similar to the CEILING() function.

     EXAMPLES
     
     A
    1=FLOOR(2.5,1) = 2
    2=FLOOR(-2.5,-2) = -2
    3=FLOOR(1.5,0.1) = 1.5
    4=FLOOR(0.234,0.01) = 0.23
    5=FLOOR(28.4,0.5) = 28
    6=FLOOR(12.2,0.5) = 12
    7=FLOOR(28.4,0.1) = 28.4
    8=FLOOR(-2.5,2) = #NUM!
    		 
     Functions - F | Index - F | Office Online 

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