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

TRUNC(number [,num_digits])

 
 Returns the number with any decimal places removed.

 numberThe number you want to truncate.
 num_digitsThe number specifying the precision of the truncation.

 REMARKS
 
  		• This function is similar to the INT() function.
     
  		• If the "num_digits" is left blank then 0 is used.

     EXAMPLES
     
     A
    1=TRUNC(18.978) = 18
    2=TRUNC(12.345,1) = 12.3
    3=TRUNC(8.9) = 8
    4=TRUNC(PI()) = 3
    5=TRUNC(-4.3,1) = -4.3
    6=TRUNC(-4.9) = -4
    7=TRUNC(-4.3) = -4
    8=TRUNC(4.3) = 4
    9=TRUNC(4.9) = 4
    10=TRUNC(-4.3,2) = -4.3
    11=TRUNC("some text") = #VALUE!
    		 
     Functions - T | Index - T | Office Online 

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