Exceljet

Quick, clean, and to the point

Excel INT Function

Excel INT function
Summary 

The Excel INT function returns the integer part of a decimal number by rounding down to the integer. Note the INT function rounds down, so negative numbers become more negative. For example, while INT(10.8) returns 10, INT(-10.8) returns -11.

Purpose 
Get the integer part of a decimal by rounding down
Return value 
The integer part of the number after rounding down
Syntax 
=INT (number)
Arguments 
  • number - The number from which you want an integer.
Usage notes 

Use the INT function when you want only the integer part of a decimal number, and it's ok to always round the number down. For example, INT (3.99) returns the number 3.

It's important to note that INT actually rounds down numbers to the next lowest integer value.

So, while INT (10.8) = 10, INT(-10.8) = -11.

Use the TRUNC function if you want the exact integer part of both negative and positive numbers.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.