Tom’s Tutorials For Excel: The INT Function
INT function rounds a number down to the nearest integer.
Example, in cell A1 is 2.7. In cell B1, the formula =
INT(A1) returns 2.
For negative numbers,
INT returns the next number away from zero.
If cell A1 holds -2.7, the formula =
INT(A1) returns -3.
If you want a formula to return -2 in that case, use the
TRUNC function, example
More examples for
Round down to the nearest 5:
Evaluate to True or False for a whole number in A1:
Week number of current year:
Current quarter of current year:
="Q"&INT((MONTH(TODAY())+2)/3)&" - "&YEAR(TODAY())
Random number between 1 and 50:
Values in A1:A10, return one of them randomly: