The INT (Function rounds a number down to the nearest integer of a number) in Excel
The INT function helps you get the integers of a number, often used to process the result of a division in Excel.
The INT (Function rounds a number down to the nearest integer of a number) in Excel Picture 1
If you do not know about INT function, you follow the article below to know the syntax and usage of the INT function.
Description
The INT function rounds a number down to the nearest integer of a number (or a division multiplication operation).
Syntax
= INT (number)
Inside:
- number: real number, or a division multiplication operation that you want to round down to integers, required parameters.
For example
- number is a real number.
Example 1:
The INT (Function rounds a number down to the nearest integer of a number) in Excel Picture 2
Example 2:
The INT (Function rounds a number down to the nearest integer of a number) in Excel Picture 3
- number is a division multiplication operation.
Example 3:
The INT (Function rounds a number down to the nearest integer of a number) in Excel Picture 4
The syntax and usage of the INT function is very simple, you can combine it with other functions in Excel to process data more efficiently. Good luck!
You should read it
- Round a number in Excel (ROUND function)
- The round () function in Python
- MONTH function - The function converts a serial number into a month in Excel
- Object Number in JavaScript
- Round function, how to use rounded functions in Excel
- ROUNDUP function in Excel - Usage and examples
- PERMUT function - The function returns the number of permutations of a given number of objects in Excel
- How to calculate the number of days in Excel
- COUPNUM function - The function returns the number of interest payments on a security in Excel
- DAY function in SQL Server
- How to fix the SUM function doesn't add up in Excel
- NPER function - The function calculates the period number of an investment in Excel
May be interested
The Match function (the function searches for a specified value in an array or cell range) in Excel
The MODE function (returns the value with the most frequent occurrence in an array or data range) in Excel
Hide value 0 in Excel
Use Sparklines in Excel
The MIN and MAX functions (the smallest and largest value functions) in Excel
Hide / show the Formula Bar in Excel