Calculate Integer Part of a Number – Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on August 22, 2023
Download Example Workbook

Download the example workbook

This tutorial will demonstrate how to calculate the integer portion of a number in Excel and Google Sheets.

Calculate Integer Part of Number Main

Integer Portion of Number

To calculate the integer portion of a number, use the TRUNC Function to “truncate” off the decimal.



The TRUNC Function simply cuts off the decimal, it does not round.

INT and ROUND Functions

You might be wondering about the INT or ROUND Functions.

The INT Function will work exactly the same as TRUNC for positive numbers, but for negative numbers INT rounds numbers down away from zero.



The ROUND Function rounds number, which can give different answers than the other functions.



Calculate Integer Part of a Number in Google Sheets

All of the above examples work exactly the same in Google Sheets as in Excel.

Integer Value Google

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List