Using TRUNC()

This is an excerpt from our Excel CPE course – Must Know Excel tips Tricks and Tools for CPAs.

TRUNC()
No Decimals
TRUN - no pennies

If you don’t want the pennies in your calculation you can use =TRUNC(), short for TRUNCATE, or =INT(), short for INTEGER,  to turn your data into integers.

 
The two functions work differently but return the same value when working with positive numbers. You will get different answers from these two functions with negative numbers. TRUNC() removes the fractional part of the number whereas INT() rounds down to the nearest integer based on the value of the fractional part.

In the screen shot below, -6.45 returns a different value using INT as it -7 is the lower value.

TRUNC

 

Comments are closed.

  • “I am extremely impressed with the courses and the reasonable price.” -Janet A. May 2017

    - Janet

  • Thank you Patricia. I really love your courses. I learned so much about excel this weekend!”

    - Connie K.

  • “always love your site and prompt customer service !! ”  Dec. 2017

    - Thank you :)