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 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 1The 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 2The 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 3The 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 4The 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!

5 ★ | 2 Vote