INT

Rounds a number down to the nearest integer.

Syntax:

INT(number)

returns number rounded down to the nearest integer.Negative numbers round down to the integer below: -1.3 rounds to -2.

Example:

INT(5.7)

returns 5

INT(-1.3)

returns -2.

Application:

Imagine you are a manager at a company that is giving out bonuses to employees. The bonus is calculated based on their years of service, with each full year earning a specific bonus amount. Any partial year of service does not count towards the bonus calculation.

Here's a table showing the years of service for several employees and how the INT function would be used to calculate the number of full years of service for each employee.

	Employee	Years of Service	Formula	Full Years of Service
	A	B	C	D
1	John Doe	5.8	INT(5.8)	5
2	Jane Smith	10.3	INT(10.3)	10
3	Peter Jones	2.9	INT(2.9)	2
4	Mary Williams	15	INT(15)	15
5	David Lee	7.1	INT(7.1)	7

In this example:

John Doe has worked for 5.8 years. The INT function rounds this down to 5, so he gets credit for 5 full years.
Jane Smith has worked for 10.3 years. The INT function rounds this down to 10, so she gets credit for 10 full years.
Peter Jones has worked for 2.9 years. The INT function rounds this down to 2, so he gets credit for 2 full years. Even though the decimal is close to 3, the INT function always rounds down.
Mary Williams has worked for exactly 15 years. The INT function returns 15.
David Lee has worked for 7.1 years. The INT function rounds this down to 7, so he gets credit for 7 full years.

The INT function is perfect for this scenario because it ensures that only complete, full years of service are considered, accurately reflecting the company's bonus policy.