TipsMake
Newest

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!

Discover more
Samuel Daniel
Share by Samuel Daniel
Update 19 May 2020