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!

Samuel Daniel

Update 19 May 2020

You should read it

May be interested

The Match function (the function searches for a specified value in an array or cell range) in Excel
the match function helps you search for a specified value in an array, a range of cells, and then returns the position of the value in that array or range.
The MODE function (returns the value with the most frequent occurrence in an array or data range) in Excel
mode returns the most frequently occurring, repeated value in a given data array. mode is not as common as other functions, but sometimes you still have to use mode to get statistics when needed.
Hide value 0 in Excel
in the process of working with excel spreadsheets, for some reason, sometimes you want to hide all zero values. to do this, you only need to perform very simple steps, but if you do not pay attention you may not know how to do it.
Use Sparklines in Excel
spark lines in excel is a small chart that you can put inside cells to view data and charts on the same table. you may know a lot about how to use charts in excel but maybe you do not know sparklines.
The MIN and MAX functions (the smallest and largest value functions) in Excel
the function to return the maximum value (max) and the function to return the minimum value (min) are two common statistical functions used by a lot of people in the process of manipulating and processing data in excel.
Hide / show the Formula Bar in Excel
hide / show the formula bar in excel - many times, when calculating, processing data, you accidentally hide the formula bar in excel without knowing it, until you need to use it, you do not know what to do. how to display that formula bar again?