The `INT` function in Excel is used to round a number down to the nearest integer. It essentially removes the decimal part of a number, providing the largest integer that is less than or equal to the original number.
Here’s how you can use the `INT` function:
- Basic Syntax:
The syntax for the `INT` function is:
=INT(number)
=INT(8.9)
- Examples:
- To round down 8.9:
This will return 8.
=INT(-3.7)
This will return -4. Notice that the `INT` function always rounds towards negative infinity.
=INT(A1)
- Using with Cell References:
- If you want to round down the number in cell A1:
This will return the integer part of the number located in cell A1.
=INT(B2*24)
- Practical Applications:
- Converting Time to Hours: If you have a time value like `3:14` in cell B2, you can extract the hour part by using:
This interprets the time as a fraction of a day and converts it into hours.
Keep in mind that the `INT` function simply truncates the decimal portion without rounding towards zero, as seen in the negative example above.
Unlock Your Potential
Excel
Access
Power BI
