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

INT(number)

 
 Returns the number rounded down.

 numberThe number you want to round down to an integer.

 REMARKS
 
  		• Negative numbers are rounded down.

     EXAMPLES
     
     A
    1=INT(1.5) = 1
    2=INT(-4.3) = -5
    3=INT(-8.9) = -9
    4=INT(10.3)-10.3 = -0.3
    5=INT(50.01) = 50
    6=INT(50.99) = 50
    7=INT(-50.01) = -51
    8=INT(-50.99) = -51
    9=INT("") = #VALUE!
    10=INT("some text") = #VALUE!
    		 
     Functions - I | Index - I | Office Online 

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