INT function

Category: Math and trigonometry
Introduced: Excel 2003

Summary

Rounds a number down to the nearest integer

Syntax

INT(number) The INT function syntax has the following arguments:
• Number Required. The real number you want to round down to an integer.

Example

=INT(8.9)
=INT(-8.9)
=A2-INT(A2)

Microsoft Support Page

https://support.microsoft.com/en-us/office/int-function-a6c4af9e-356d-4369-ab6a-cb1fd9d343ef

Back to Functions