Excel Tutorial: Rounding with TRUNC, INT and ROUND functions

In this EXCEL Tutorial we will discuss different rounding functions that can be utilized to adjust decimals of numbers. Other functions may be nested within the rounding functions so the end result of nested functions is outputted with the chosen amount of digits or decimal places

 

The INT function returns an integer number (no decimal places):

= INT( number )

 

The TRUNC function returns a number truncated to a specific number of digits:

= TRUNC( number, digits )

 

The ROUND function returns a number rounded to a specific number of digits

= ROUND( number, digits )

 

The following example shows the return result of the INT, TRUNC and ROUND functions on a number with four decimal places. The INT function returns a number without the decimal places.

The TRUNC functions cuts off the number at two digits, while the ROUND function rounds the number to two digits. The TRUNC and ROUND functions returned a different result because the ROUND function returned a number where the decimal was rounded up.

These functions are powerful at manipulating numbers to quickly and easily change number formats to display the desired number of digits.


Download this excel example here.

We have Advanced Excel Training and QuickBooks Courses in Davie (15 minutes from Ft. Lauderdale and 25 from Miami, call us for more information regarding the courses.


Hector Garcia CPA and QuickBooks/Excel Trainer

Hector Garcia CPA and QuickBooks/Excel Trainer

Share on linkedin
Share on facebook
Share on twitter
Share on whatsapp
Share on email
Share on print

Use our link to get 30% off for a year, valid through 07/31/2022

Popular Courses

Private QuickBooks Training onsite

Customized Training

Accounting & Bookkeeping Services

Video-Based Virtual QuickBooks Course

Share

Share on linkedin
Share on facebook
Share on twitter
Share on whatsapp
Share on email
Share on print

30% Off QuickBooks

Use our link to get 30% off for a year, valid through 07/31/2022