Excel INT Function

Excel INT Function

An excel function that returns the integer part of the decimal number by rounding down to the integer. It can be used as a worksheet function or a VBA function. The function is categorized as math and trig function in excel.

For example: INT(10.8) will return 10 and INT(-10.8) will return -11.

So, we can say, negative numbers become more negative as INT function rounds down.

Syntax

=INT(Number)

Argument

Number. REQUIRED. Any positive or negative decimal digit from which integer is required

Purpose

Get the integer part of a decimal number by rounding down

INT function returns the integer part of the decimal digit by rounding down. However, if you only want the exact the integer part of both negative and positive numbers, it is good to use TRUNC Function.

Remarks

Excel provides a number of functions for rounding:

• To round normally, use the ROUND function.
• To round to the nearest multiple, use the MROUND function.
• To round down to the nearest specified place, use the ROUNDDOWN function.
• To round down to the nearest specified multiple, use the FLOOR function.
• To round up to the nearest specified place, use the ROUNDUP function.
• To round up to the nearest specified multiple, use the CEILING function.
• To round down and return an integer only, use the INT function.
• To truncate decimal places, use the TRUNC function.

Source:

https://exceljet.net/excel-functions/excel-int-function