INT
Formulas / INTRound down a decimal number to the nearest integer.
INT(number)
- number - required, the real number to round down to an integer
Examples
=INT(3.25)The function truncates any decimal portion of a number, rounding down to the lower integer. This example returns 3.
=INT(3.99)The function truncates any decimal portion of a number, rounding down to the lower integer. This example returns 3.
=INT(3.01)The function truncates any decimal portion of a number, rounding down to the lower integer. This example returns 3.
=INT(-3.1)The function truncates any decimal portion of a number, rounding down to the lower integer. This example returns -4 because INT rounds down to the lower integer.
=INT(-3.99)The function truncates any decimal portion of a number, rounding down to the lower integer. This example returns -4 because INT rounds down to the lower integer.
=INT(-3.01)The function truncates any decimal portion of a number, rounding down to the lower integer. This example returns -4 because INT rounds down to the lower integer.
Summary
The INT function is used to round a real number down to the nearest integer. It takes a real number as its argument and returns an integer result.
- The INT function returns the integer part of a decimal number, rounding down to the nearest integer.
- The INT function removes any fractional part of the decimal number, returning only the integer part.
Frequently Asked Questions
What is the INT function?
How does INT work?
What types of numbers can I use with INT?
- 3.14159
- -2.71828
- 4.0
